Hi Borislav, thanks for your answer.

Although that is not what I like to hear, at least it is good I know about it. I got a feeling that this issue will not be fixed soon if at all.

Now have to think of some way to workaround this, perhaps creating a view of the table and redefine the field name there, but that is another story...

David


>>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
>