Very Computer

Good afternoon!

I'm working on a Visual Foxpro (VFP) program which, given a target FoxPro
table, will create or recreate a new table in SQL Server. Given that I have
literally hundreds of FP tables to migrate over and refresh, whose
structures occasionally change, I had to tackle something like this!

Anyhow, this is SQL Server 6.5, SP4, client is an NT Workstation (4.0,SP3).
VFP 5.0, Visual Studio service packs applied...

?SQLConnect( 'SQLSRV: Adm_DB', 'sa', '<password>' ) returns a >0 connection
handle, indicating success against this system dsn.
?SQLTables( handle, 'TABLES' ) returns 1, indicating completion and success.
Yet, the VFP cursor (defaults to SQLRESULTS) is always empty. Has the
columns it should, it's just always empty.
It does not matter, in SQLTables(), if you pre-create and supply a cursor,
darn thing still fails...

Created a system dsn to pubs (dsn name SQLSRV Pubs), then tested the sql
calls above -- sqltables always returns no tables.
Tested the ADOWorks (Access97) system dsn; sqlconnect() also works, and
sqltables() returns a list of tables.

Any suggestions from any of you will be heartily appreciated.
Bill Blackman

SQLTables looks in the database that you are logged into.  Do one of two
things:
1) If you are using an SQL User setup to log into SQL, set the default
database in user setup.
2) issue the command = sqlexec(<your connection handle>, "SET DATABASE TO
<DATABASE>")

Douglas,

Thanks for your reply and your suggestion.

A major part of my problem turned out to be alot more mundane: in
SqlTables() I was supplying the cursor name that I wanted the results placed
into, as the doc.s say you can. The doc.s do not say that that name MUST be
<= 10 characters long...

Oh, well, so much for my habit of writing code using variable names that are
self-descriptive!

Thanks again.
Bill Blackman