>Hi all,
>
>I noticed that although I can open a table with a field start with a digit, I cannot browse such table. The error is: "The data source for this object must be a variable reference."
>
>The table is a MSSQL table defined as:
>CREATE TABLE [TestTable] (
> [ID] [nvarchar] (10) NOT NULL ,
> [01] [int] NOT NULL DEFAULT (0)
>)
>
>The VFP code returning the error is:
>lnHandle = SQLCONNECT("an_odbc_dsn")
>SQLEXEC(lnHandle, 'select [01] from TestTable')
>BROWSE
>
>Is it just my problem or is it a known issue?
>
>TIA.
It is a known issue, neither fields nor file names can begin with digit.
lnHandle = SQLCONNECT("an_odbc_dsn")
SQLEXEC(lnHandle, 'select [01] AS _01 from TestTable')
BROWSE
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.