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!

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

Recent content by KALEMO

  1. KALEMO

    macro substitution error in select statment

    This statement works in VFP 2.6, but i get a "Group By Clause is missing or invalid" error when it is run in VFP 9: sele lctable as table, lccond as condition, lcsource as grsource, ; iif(type(lcsource) = "C", padr(alltrim(&lcsource),14), ltrim(trans(&lcsource, "$$$,$$$,$$$.99"))) as...
  2. KALEMO

    macro substitution error in select statment

    This statement works in VFP 2.6, but i get a "Group By Clause is missing or invalid" error when it is run in VFP 9: sele lctable as table, lccond as condition, lcsource as grsource, ; iif(type(lcsource) = "C", padr(alltrim(&lcsource),14), ltrim(trans(&lcsource, "$$$,$$$,$$$.99"))) as...
  3. KALEMO

    do not want double quotes on .csv export

    Help Please! I need to export a table to a .csv file ~ i cannot have double quotes in the output file, only commas separating the data. Thank you!
  4. KALEMO

    Create Table from Array

    I have an array that is storing only field names and now need to create a table where the field names in the table are the same as the field names in the array. I've tried altering an existing table using ALTER TABLE CTRAC; RENAME COLUMN FIELD7 TO laCTRAC[1,7] and have tried CREATE TABLE...
  5. KALEMO

    Error Importing Excel Table

    When I use the Wizard to import a local Excel file or an Excel file on the server, I receive the error &quot;an error occurred making a temporary copy of <location and file name>...HOWEVER, if I type 'SET DEFAULT TO <LOCATION>' at the command window in VFP and THEN use the wizard to import an...
See more

Part and Inventory Search

Back
Top