Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field start with a digit
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01164666
Message ID:
01164843
Views:
12
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
Map
View

Click here to load this message in the networking platform