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
Title:
Field start with a digit
Miscellaneous
Thread ID:
01164666
Message ID:
01164666
Views:
68
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.
Next
Reply
Map
View

Click here to load this message in the networking platform