Advantage Knowledgebase Item
Last Modified: Wednesday, October 31, 2012 Product: Advantage StreamlineSQL Title: Receiving Invalid Column Name When It Is Longer Than 10 Characters Problem Description: Advantage is returning an error 2134 about an invalid column name. In this instance the full error was:
- Error 7200: AQE Error: State = S0000; NativeError = 2134; [iAnywhere Solutions][Advantage SQL Engine]Invalid column name: COLUMN_NAME
The column name in question is longer than 10 characters, and when shortened to less than 10 it is successful. Also in this case the creation of the table was with a script using the AdsExecuteSQLDirect command. Solution: DBF table column names are limited to a 10 character length, and ADT and VFP tables are limited to 128.This is most likely that ADS is attempting to create a DBF table type, when the desired table type was ADT. This can be set in the script above with the command "AdsStmtSetTableType" before calling AdsExecuteSqlDirect.
For more information about the commands see below:
http://devzone.advantagedatabase.com/dz/WebHelp/Advantage10.1/index.html?ace_adsexecutesqldirect.htm
http://devzone.advantagedatabase.com/dz/WebHelp/Advantage10.1/index.html?ace_adsstmtsettabletype.htm
Was This Item Helpful?
|