Thanks
Simon
>Think of ISQL (Ineractive SQL) as SQL's version of vfp's command window. It is used to interactivly run Select statements. Most DBMS'have one. MS SqlServer as on called ISQL as well. In SqlAnywhere's case, they have some command line options that allows you to automaticly login and launch a sql script.
>
>
>>Hi James
>>
>>Sorry for sounding ignorant but what is ISQL?
>>
>>Thanks
>>Simon
>>
>>>Simon,
>>>
>>>You can use the OUTPUT statement to extract data in a number of formats. One of the is foxpro which gives you a 2x type dbf file.
>>>
>>>Select * from table ;
>>>output to c:\file.dbd format foxpro ;
>>>
>>>This will only work using ISQL. You can also automate ISQL with command line options so the extracts can be part of a batch file.
>>>
>>>Using VFP you can do about whatever you want through ODBC. Just remember that vs5.5 has to have an client app running to allow ODBC to connect. If you have a lot of data to output the option above is much faster.
>>>
>>>
>>>>Hi
>>>>
>>>>I have a customer who wishes me to extract some data on an on going basis from an app. I can use the built in export function in the application with some work arounds but in the process I discovered that the application was using SQL Anywhere 5.5 so I thought it would be better to use VFP to extract the data because I could automate the whole thing.
>>>>
>>>>Not being familiar with SQL Anywhere I wondered if some current users might give me a little information on how and what is required to export data from SQL Anywhere into VFP tables for further analysis.
>>>>
>>>>Thanks
>>>>Simon White
Simon White
dCipher Computing