Fernando,

Strange. I see the same behaviour in VFP7. MS Access returns the same format as SQL Server. This is certainly not documented. SqlColumns() has an optional "NATIVE" parameter that returns fieldnames based on the back end, but SqlTables() should return the same structure, at least according the docs.

>Hi,
>
>I have a program that connects to an ODBC Data Source, and performs some functions. Please, assume the following code fragment below:
>

> cSQLDataSource = "xyz"
> cSQLUserId     = "xyz"
> cSQLPassword   = "xyz"
>
> nPecasHandle = SqlConnect (cSQLDataSource, cSQLUserId, cSQLPassword)
>
> SqlTables (nPecasHandle, "Table", "TmpTables")
>
> Select TmpTables
> Browse
>
> SqlDisconnect (nPecasHandle)
>

>
>In all my DSNs till now (Informix, Oracle and VFP) when I call SqlTables () it creates a cursor with field names as defined in the help file:
>

>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.
>
>Thanks in advance.
>
>Fernando