Have you tried : SET ANSI OFF
That makes are mor forgiving with reserved words in rbase Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Ramsour Mike Skickat: den 26 januari 2009 21:42 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Incorrect syntax near the keyword 'file' Greetings: I am getting the error message noted in the subject line from the Microsoft ODBC driver while trying to pull data from a SQL database into R:BASE. The problem is being caused by the fact that there is a field named "FILE" (of all things!) in the SQL database. Using Turbo V-8 I am using the ALIAS option on the SATTACH command to rename the "file" column but I still get the error. The strange thing is that my code was working up until the R:Cornucopia update on or about 11/26/2008. The problem exists on both Windows XP and Windows 2000. I have googled the error message but have not found a solution for this particular situation. I would appreciate any suggestions that would help me solve this problem or be able to work around it. Here is the syntax I am using. The FNAME field is the one named "FILE" in the source SQL database. The SQL Server table attaches without any problem but as soon as I do any queries on it I get the error. SCONNECT BADATA IDENTIFIED BY <user> <password> SATTACH COIL USING ID + ALIAS ID,STARTDATETIME,NUMBERTXT,PROCESSLINETXT,GRADEINT,GAGE,WIDTHDBL, + TYPETXT,LINESPEEDAIM,LENGTHDBL,LINESTOPS,TOTALTIMETXT,DOWNTIMETXT,PATH,FNAME , + NEEDTOBATCHPRINT,HASBEENARCHIVED,NEEDTOLINEPRINT,FLAG3,FLAG4,FLAG5,FLAG6, + FLAG7,NOTEFILE Thanks Mike Ramsour
