10.1B and "Default" keyword as table column name.

Posted by Admin on 21-Jan-2007 18:37

10.1B objects to use of Default as a table column name, even when delimited by double quotes...

"Default" integer

Using keyword "Precision" in this manner is not a problem.

This used to be OK on 10.0B3.

Any comments?

Henk

All Replies

Posted by Admin on 22-Jan-2007 01:56

We have similar problems when trying to import SQL-data. The ABL has the keyword forget list, but the SQL92 engine doesn't.

Advice: enter a support ticket.

Posted by Thomas Mercer-Hursh on 22-Jan-2007 11:38

My advice is to get ProRefactor and fix the name.

Posted by Admin on 22-Jan-2007 11:56

My advice is to get ProRefactor and fix the name.

Sometimes you don't have a choice when you have to support a foreign schema. Besides that it's kind of weird that 10.1 creates more problems than 10.0 and that the SQL-client has no "keyword forget list". Why can't you use quotes around keywords in SQL for instance?

This thread is closed