Search results for query: *

For additional information: The relations are the first files opened during the start of the App. I have orders set for all child tables. I didn't have any problems with the relations until I added the "SET RELATION TO nameid INTO forn ADDITIVE" line. I will try the suggestions and report...

I have setup the following relations. ************************************* SELECT 1 USE d:\database\comp.dbf SHARED SELECT 2 USE d:\database\name.dbf SHARED SELECT 3 USE d:\database\forn.dbf SHARED SELECT 4 USE d:\database\misc.dbf SHARED SELECT 5 USE d:\database\data.dbf SHARED SELECT 6 USE...

Thanks. I also discovered that VBA handles the single quote just like the double.

I am creating a text string to insert into the CreateQueryDef command but the resulting query has the dropdown field values in brackets. They need to be in quotes. (This is my first attempt at this type of thing in VB) --------------------------------------------------------- Example: Dim dbs...

I am creating a text string to insert into the CreateQueryDef command but the resulting query has the dropdown field values in brackets. They need to be in quotes. (This is my first attempt at this type of thing in VB) --------------------------------------------------------- Example: Dim dbs...

In FoxPro2.6 you can do what is called "Macro Substitution". That is you can set a variable to a value (m.MyString="SELECT * From Dbf01 Where field1=xyz INTO ARRAY qryRay"" and have the contents of the variable executed. (&MyString) Example: ***************** If...

My company prints aprox 750,000 sheets of paper from 250 different reports each month. On several occasions the reports seem to have corrupted and would only print 1 record from the source data containing numerous records. The only solution I was able to find to this problem was to cut the...

Another route is to increase memory in your system. 128meg is the minimum memory for XP. NAV Realtime Protection also slows FoxPro26. Try disabling it. It helped considerably on my Terminal Server. MarkA1966

I know NOTHING! about SQL7 and don't even know where to start. Situation: Employee died and did not have documentation on the SQL7 database of subscribers. I managed to locate the server the data was on and had the web host's control pannel do what they called a "backup" of the data...

RGBean and Gilesy, I have over come the character limit using Macros many times. Most my queries are from 8 related tables with about 35 different fields to output. The A_str = '<half of code>' b_str = '<other half>' c_str = a_str + b_str &c_str type solution has worked...

Sorry didn't complete the information I posted... Have you tried &quot;SHOW GET <YourVarHere>&quot; where the variable is the one given to the second or third list box? Marka1966

Have you tried using a &quot;SHOW GET <YourVarNameHere> ?

I am using FPW26. I am trying to use the screen that is used to do replaces in databases when you open a database in the development environment and select record then replace from the default system menu.

I would like to use the replace screen accessed by the default sysmenu without having to completely recreate it. Can anyone tell me how to access the code that generates the screen?

Thanks, Works like a charm. I added: IF EOF() STORE 1 TO nTmpRec ELSE STORE RECNO() TO nTmpRec ENDIF GOTO nTempRec

I have 4 databases in FPW26 related as follows: 'Actives' related to 'Name' 'Name' related to 'Company' 'Cancels' related to 'Name' 'Name' related to 'Company' 'Actives' and 'Cancels' are the same structure with a cancel date added to the 'Cancels' database. Both are indexed on a numeric...

Thank you, More help than I had expected. Marka1966

Thanks. I told you I was just brain dead. Marka1966

I am working on a FPW 2.6 program that checks the field names, data type, size, etc. against a template dbf. All I want the user to do is select any .dbf file in a directory and the program will then retrieve all the .dbf files in the directory and store the file names to an array to be...