OK, that works. I like the output from OSQL better than ISQL. I'll have to play with it for a while to see if I want to use this instead of SQL-DMO.
>ISQL parameters are case sensitive so you've to use -L not -l.
>
>>When I try it a cmd window opens asking me for a password. So it is trying to connect to a server to validate.
>>
>>>For -L option you don't have to login to any servers.
>>>
>>>>Yes, but you still have to connect to a server to use ISQL.
>>>>
>>>>>Dan,
>>>>>
>>>>>ISQL/OSQL are command-line utilites so you can run them using VFP RUN command and than parse there output.
lcTempFile = ...
>>>>>RUN ISQL -L > "&lcTempFile"
>>>>>? FILETOSTR(lcTempFile)
>>>>>