-
- Cannot access the selected table (Error 1152)
by jmom
- 6 Replies
- Last post
by jmom
- You have attempted to select a table outside the 32K work area range or are attempting to reference a file variable in a table that is not open .
I am getting this error more often. I open the table in the load event of my form and there is no use or close table statements until the "Exit" button is clicked. How can u test if u go beyond the 32K work range
-
- Search Button
by honey1016
- 1 Replies
- Last post
by CChalom
- why my Search button is not go to the correct records but it will go with one records again and again this is my sample program in Search Button. Please correct my program. Thank you
****** sample******
public v_recno
sele pds_data set order to tin
flag = 0
IF EMPTY(thisform.txtTin.value) thisform.txtTin.setfocus flag=1 ELSE IF !EMPTY(thisform.txtTin.value) SEEK ALLTRIM(t
-
- How to make the new records on top of the existing records on the Grid
by MillBear
- 3 Replies
- Last post
by dni
- Hi
There is existing records in the Grid. When I enter a new few records next to the existing ones in the grid, all the new datas are rolled on the bottom of the grid instead of the top (see Figure 1).
'Goto Top' don¡¯t seem work well for my coding. How to make new records on top
Valid Procedure of the TextBox
do while i<50 and .textbox.value = dpq_refno
-
- visual foxpro to excel
by Lakshmi N
- 5 Replies
- Last post
by PB_UK
- Sir,
I have 2 excel sheets.
one sheet contains sapcode,sapname,grpcod,prdcod,amt
another sheet contains sapcode,so many other fields and amt
both sheet contains multiple sapcodes
now my job is to
1. read first sheet into a dbf (sum(amt) group by sapcode because multiple sapcodes)
2. read second sheet into a dbf (sum(amt) group by sapcode because mul
-
- working with old screen arrays
by ibbm
- 7 Replies
- Last post
by ibbm
- I am converting an old fox 2.5 screen array to fox 6. I would rather not replace the array with a grid but I am having problems trying to do this. In my old program I declared screen(10,17) I added a property to my form call screen but it's not happy with me. I tried to declare ThisFrom.screen(10,17) but it comes up an says screen is not an array. Any suggestions on how this can be done.
Th
-
- How to add my own objects to a grid programatically
by Aleniko29139
- 7 Replies
- Last post
by AndyKr
- Hi all;
I'm using this method to construct the columns within the grid. I need
however to construct the grid so the cells are my own class objects.
WITH thisform.kgrdledger1
.columnCount = -1
.RecordSource = "CurRpt"
.addcolumn(1)
.columns(thisform.kgrdledger1.ColumnCount).name = "colAmount"
.colAmount.controlsource = "curRpt.Amount&
-
- DataGridView Validating in VB.Net
by Sixon
- 1 Replies
- Last post
by CetinBasoz
- I've create a datagridview binding a table from Ms Access database like this :
Date Item Qty Price
20/01/2007
12:00:00 PM A0001 18 2,516
21/01/2007
12:00:00 PM A0002 5 2,304.5
22/01/07
12:00:00 PM B0008 10 2,168.46
Here are several problem
-
- Third party utility
by Sixon
- 1 Replies
- Last post
by Markish
- Sometimes I got the error message " The table has been corrupted and must repair before use again" And the help says that to repair the table must use third party utilities. What third party utility thanks....
-
- Open C# screen in VFP
by satyenshanker
- 1 Replies
- Last post
by Alex Feldstein
- Is it possible to open a screen developed in C# within VPF
Satyen
-
- vfp8 code errors in vfp9
by orderinc
- 11 Replies
- Last post
by orderinc
- The following code snippet works fine in VFP8 but the 'use (mfile)' invokes the catch code in VFP9. When running without try catch, use (mfile) simply does nothing the 1st time it is run, but does open up the file the 2nd time it is run. I am deleting the CDX file previous to this code being run.
mfile=mmomfile
select 0
try
mtagfound=.f.
use (mfile)
mi=1
milen=30
-
- Microsoft is going open-source the core portions of the Visual FoxPro DBMS!
by Fernando D. Bozzo
- 12 Replies
- Last post
by Fernando D. Bozzo
- I want to be between the first ones to bring this news:
http://www.eweek.com/article2/0,1759,2105307,00.asp
!Can't believe that!
Best regards,
Fernando D. Bozzo
-
- VFP 8 Form Issue
by TRJ48
- 8 Replies
- Last post
by TRJ48
- I have developed a form in VFP 8 which has multiple grids on it. It runs fine from VFP but when I run it from the EXE it gives the following error when trying to load the form. Error Loading File - Record Number 66. ResoGrd <or one of its members>. Parent : Not a Table. I checked the parent field in the .SCX and it looked fine - it just had the form name. I tried deleteing all of the objcode
-
- Trigger syntax
by Victor BA
- 2 Replies
- Last post
by CetinBasoz
- I have this in a Delete trigger (using Expression Builder):
delete from session where user='o'
and it sends a syntax error, what exactly must be in the triggers or what i'm doing wrong
BTW, "session" is another table, not the one with the trigger, and "user" is a field in that table
Thanks
-
- VFP6 to VFP9 broke Dataenvironment.OpenTables
by GeofS
- 12 Replies
- Last post
by Tamar E. Granor
- The <form>.Load() code below, which used to work fine with VFP6, now generates a syntax error (Error #10) after compiling with VFP9. The error occurs on the OpenTables() line. It occurs with multiple forms, all of which have their AutoOpen and AutoClose properties set to FALSE. What has changed to break this simple code local lReturn with this if type('.dataenvironment') = 'O' * m
-
- Command Window in Vista
by AlexBB
- 14 Replies
- Last post
by Tamar E. Granor
- I hope Tamar Granor will read it. It seems she may be familiar with Vista.
I have touched on this problem in my previous post. In VFP 9 Management Studio under Vista, the Command WIndow behaves like the mouse cursor/pointer when you set it up in slow motion and with traces. In addition it frequently bounces back to the place it started. It is unbelievably weird. It is very very, and I mean
-
- VFP and Word Merge
by Stuman99
- 3 Replies
- Last post
by Stuman99
- I am adding word automation to our VFP application. I like the ease of use of Bookmarks and have no problems navigating thru a document that has existing bookmarks. My problem is that users will need to create new documents and add bookmarks into the appropriate places of the new documentation. How do I provide the user with a pick list that will allow them to insert the available bookmarks. Is th
-
- Setting a date in VP 6
by ibbm
- 4 Replies
- Last post
by ibbm
- I want to set a date field to zeros
I use to use "replace datefield" with {"00/00/00"} but vp 6 doesn't like it.
Any help would be appreciated. Thanks
-
- Moving foxpro database
by anonyfake
- 3 Replies
- Last post
by AndyKr
- I'm attempting to move a database from foxpro 3.0 to 9.0 (new machine) I can move files essentially without an issue, but once they are on the new machine, I have no clue on how to resume the application. I'm clearly a foxpro neophyte, any help would be greatly appreciated.
-
- Combobox problem
by Yuniel Lorenzo
- 4 Replies
- Last post
by MarciaAkins
- Hi out there
Ok I have this code to fill a combobox:
thisform .comMagent. RowSourceType = 6
thisform .comMagent. RowSource = "cmmage.masteragen"
and doesn't work and is supouse to work, the only way that it can work is usinglike this:
USE cmmage
thisform .comMagent. RowSourceType = 2
thisform .comMagent. RowSource = "cmmage.masteragen"
-
- foxpro Passing variable to a form
by Bit
- 2 Replies
- Last post
by Markish
- Hi,
I've 2 VFP forms, namely "Main" and "FRM_B"
1.> Form " Main" content:
do form frm_B
Messagebox (ans)
2.> Form " FRM_B" content
ans = "U"
return ans
When Main is run, the "ans" is not "U" as expected.
How can I pass the variable variable " ans" from FRM_B to Main
-
- Get column name in SQL query
by Victor BA
- 14 Replies
- Last post
by Naomi Nosonovsky
- How can i obtain all the records in a specific column like:
select field1 from table
but instead of the name "field1" use a column number i'm guessing :
select 2 from table // The number 2 being the third column (starting at 0)...
is this the right way
Thanks.
-
- Philadelphia VFP User Group--Wednesday, May 16
by Tamar E. Granor
- 2 Replies
- Last post
by Tamar E. Granor
- The Philadelphia VFP User Group will meet this Wednesday, May 16 at 7 PM at Valley Forge Pension Management, 715 Twining Road, Suite 202, Dresher, PA 19025. As always, feel free to bring something to eat and arrive as early at 6:30 for discussion and dinner. We have a double dose this month. Members Craig Benson and Bob Pierce will present. Speaker: Craig Benson Bio: Co-Founder and Director of Dev
-
- My exe does not running other PC
by mezofi
- 14 Replies
- Last post
by mezofi
- Hi! I built a project and I have a big problem. It is run only my PC, and if I put it on a pendrive (exe). But if I put it on an other PC , this program show only main page. Then when I click someone button, the program show an error message: Command contains unrecognized phrase/keyword (Error 36) It is very strange, because if it is on my pendrive the program good have not got any error. Mez fi f
-
- Do SP2 fixes to SQL processing fix ENGINEBEHAVIOR 70 execution?
by Craig Roberts Minnesota
- 0 Replies
- Last post
by Craig Roberts Minnesota
- It is impressive the detail of the fixes in each and every service pack.
Every so often in an application I'm refactoring and we're upgrading to VFP 9, we need to run with
SET ENGINEBEHAVIOR 70
Because we have descriptive fields in SQL - GROUP BY queries.
For Service Pack 1 or 2, are fixes like
SQL internal error when using a UNION
apply when running wit
-
- MS Access importing visual foxpro tables
by Dave Mosby
- 14 Replies
- Last post
by Dave Mosby
- Win XP Pro - Access 2003 - current ODBC driver for VFP
Set up an ODBC connection via control panel/admin services using a free table directory
- the target directory has many dbf files that are visible in the "browse" window -
- I then try to use the Access link table "wizard" - choose ODBC connection -
- select the ODBC link I created -
- the "wizard&qu