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!

Search results for query: *

  • Users: KALEMO
  • Content: Threads
  • Order by date
  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...

Part and Inventory Search

Back
Top