🚀 go-pugleaf

Hello Geoff

    Tried your examples on a 1 Million records file and got no errors as
long
    as i had Create/Delete Rights on the network

    Vdb creates a temporary file __QB000.... in the current working
directory

    in your example you say C:\mydir1 and c:\mydir2 ( both really on the
same pc ??? )
    ( mydir1 was probably on the network  )

    I put the MYFILE.DBF on another PC and let the sqlexec run

CD c:\temp
? SQLEXEC( "SELECT * FROM 'T:\TEMP\MyFile' WHERE Employee = '0001994'",
"NewFile" )

This created the NEWFILE.DBF in my c:\temp directory and printed 0 in the
command window


Yves Bentein
Ostend, Belgium


Geoff Wass wrote in message <352C97F3.58F38EB7@ibm.net>...
>=============================================================
>Hello Everyone!
>
>
>
>Geoff Wass
>Kuala Lumpur, Malaysia
>
>
>============ cut here =================
>
>PROCEDURE Test
>
>   CLEAR
>
>   SET SAFETY OFF
>
>   CD c:\MyDir1
>   ? SQLEXEC( "SELECT * FROM 'c:\MyDir1\MyFile' WHERE Employee =
>'0001994'", "NewFile" )
>   USE NewFile
>   COUNT
>   USE
>
>   CD c:\MyDir2 && THIS WORKS!
>   ? SQLEXEC( "SELECT * FROM 'c:\MyDir1\MyFile' WHERE Employee =
>'0001994'", "NewFile" )
>   USE NewFile
>   COUNT
>   USE
>
>   CD c:\MyDir1
>   ? SQLEXEC( "SELECT * FROM 'c:\MyDir1\MyFile' WHERE Employee =
>'0001994'", "NewFile" )
>   USE NewFile
>   COUNT
>   USE
>
>   CD c:\MyDir2 && THIS WORKS!
>   ? SQLEXEC( "SELECT * FROM 'c:\MyDir1\MyFile' WHERE Employee =
>'0001994'", "NewFile" )
>   USE NewFile
>   COUNT
>   USE
>
>   CD c:\MyDir2
>   ? SQLEXEC( "SELECT * FROM 'c:\MyDir2\MyFile' WHERE Employee =
>'0001994'", "NewFile" )
>   USE NewFile
>   COUNT
>   USE
>
>   CD c:\MyDir1
>
>   SET SAFETY ON
>
>RETURN
>=============================================================
>
>