Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: marka1966
  • Content: Threads
  • Order by date
  1. marka1966

    Effects of ERROR 1147 - "Target is engaged in relation."

    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...
  2. marka1966

    CreateQueryDef changes dropdown values to input parameters

    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...
  3. marka1966

    CreateQueryDef changes dropdown values to input parameters

    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...
  4. marka1966

    Read a Variable as a Literal not a value

    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...
  5. marka1966

    .BAK file from web host dbf backup

    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...
  6. marka1966

    default sysmenu - record\replace screen

    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?
  7. marka1966

    Database relations - child record does not change after SELECT

    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...
  8. marka1966

    Move all *.dbf names in a selected directory to an array

    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...

Part and Inventory Search

Back
Top