>Larry,
>
>where can i find a list of all forbidden words with SQL 7?
>
>Joerg Karpa
>
>>You have to change the name of your field. Level is a keyword in SQL Server and any SQL command using this field will fail because of this.
>>
>>FWIW, I had to do the same thing when I migrated a VFP application to SQL Server and I had a USER table. USER is a keyword so I had to change it to USERS.
If you are going to be doing any significant work on SQL Server 7, then I recommend picking up a book on the subject. The same is true for any RDBMS back-end (Oracle, Sybase, Informix, DB2). Each of them has its own functions and keywords that are foreign to the others and especially to VFP.
Check you local bookstores or visit
www.amazon.com or
www.bn.com (Barnes & Noble).
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao