General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Jim, still thanks for your reply!
>Sorry, disregard. I *thought* you said table name, but I see you wrote FIELD name.
>Hi David,
>
>It's because VFP does not allow a numeric first character as an ALIAS, so it assigns its own ALIAS to the table.
>
>You can circumvent it by assigning your own (valid) ALIAS to the table, then use that ALIAS to SELECT it.
>
>cheers
>
>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only