General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Field start with a digit
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
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