Groups | Search | Server Info | Login | Register

Groups > comp.lang.clipper > #1734

Re: expression error ( in index key )

Show all headers | View raw

Hi Scott,

1. if file( "SCANFILE.DBF" ) = .T.

    why not use

    if file( "C:\SCANFILE.DBF" ) // = .T. is not necessary

2 after that line, is SCANFILE.DBF still in use? Then first close it, only then erase SCANFILE.NDX

3 do you suppose correctly that the DBFNDX RDD doesn't work with production indices?
   if DBFNDX does use production indices, then USE SCANFILE.DBF fails because there is no SCANFILE.NDX on disk (it got erased)

4 use SCANFILE.DBF
   index on ITEM to SCANFILE.NDX

  can be omitted when DBFNDX tries to open the production index, just write

  use c:\SCANFILE.DBF

5 if DBFNDX doesn't work with production indices (i really don't know), then check whether there is a second SCANFILE.DBF somewhere trailing in your PATH; use SCANFILE.DBF uses the SCANFILE.DBF that it finds first

hth,

lohen

Op maandag 19 februari 2024 om 19:25:10 UTC+1 schreef Scott Coffey:
> Hoping for a minor miracle here... 
> 
> I have a Clipper application running on a handheld device (Pocket PC). 
> I'm using PocketDOS as the OS on the handheld device. I'm trying to 
> port this application to a handheld running Windows CE 7.0. Although 
> I had some issues installing PocketDOS on the Windows CE device (was 
> unable to use the installer and had to install manually), I got it 
> installed and am able to launch and run the Clipper application on 
> this device. 
> 
> The application runs fine until I try to create an index, then the 
> application fails when I try to use that index. 
> 
> Example: 
> 
> Program A uses the following statement: 
> 
> use c:\SCANFILE.DBF index C:\SCANFILE.NDX alias SCANFILE 
> 
> That works fine as long as I'm using the original index created on the 
> old Pocket PC handheld. Then I have a program that does: 
> 
> if file( "SCANFILE.DBF" ) = .T. 
> if file( "SCANFILE.NDX" ) = .T. 
> erase ("SCANFILE.NDX") 
> endif 
> use SCANFILE.DBF 
> index on ITEM to SCANFILE.NDX 
> endif 
> 
> That runs OK, but the next time I try to run program A, it fails on 
> the "use" statement with the error: "expression error ( in index key 
> )" 
> 
> The database files and indexes were copied from the working device to 
> the new device. As stated, accessing the database files via the index 
> works OK initially, but when I try to recreate the index the program 
> then fails as described. If I re-copy the files, the program works 
> again until I try to recreate the index. 
> 
> Any ideas out there? 
> -- 
> Scott at Scott dash(-) Coffey dot net

Back to comp.lang.clipper | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

expression error ( in index key ) Scott Coffey <none@noemail.com.invalid> - 2024-02-19 13:25 -0500
  Re: expression error ( in index key ) frank van nuffel <fannuffel@gmail.com> - 2024-02-20 05:38 -0800
  Re: expression error ( in index key ) Dlzc <turkeyheadedmutha@gmail.com> - 2024-02-20 07:32 -0800
  Re: expression error ( in index key ) Scott Coffey <none@noemail.com.invalid> - 2024-02-21 09:06 -0500
  Re: expression error ( in index key ) Scott Coffey <none@noemail.com.invalid> - 2024-02-21 13:00 -0500
    Re: expression error ( in index key ) frank van nuffel <fannuffel@gmail.com> - 2024-02-21 10:27 -0800
      Re: expression error ( in index key ) frank van nuffel <fannuffel@gmail.com> - 2024-02-21 11:10 -0800
        Re: expression error ( in index key ) frank van nuffel <fannuffel@gmail.com> - 2024-02-21 11:15 -0800
          Re: expression error ( in index key ) Scott Coffey <none@noemail.com.invalid> - 2024-02-22 11:12 -0500

csiph-web