> cSQLDataSource = "xyz" > cSQLUserId = "xyz" > cSQLPassword = "xyz" > > nPecasHandle = SqlConnect (cSQLDataSource, cSQLUserId, cSQLPassword) > > SqlTables (nPecasHandle, "Table", "TmpTables") > > Select TmpTables > Browse > > SqlDisconnect (nPecasHandle) >>
>TABLE_QUALIFIER Table qualifier identifier >TABLE_OWNER Table owner identifier >TABLE_NAME The table name as it appears in the data dictionary >TABLE_TYPE The table type as it appears in the data dictionary >REMARKS A description of the table >>But now, when I accessed a SQL Server 2000 database, it returned:
>TABLE_CAT Character 128 >TABLE_SCHEM Character 128 >TABLE_NAME Character 128 >TABLE_TYPE Character 32 >REMARKS Character 254 >>There is a reason (or explanation) for that? I'm running a VFP 6.0 SP5 app in a win2k professional.