Advantage Developer Zone


Advantage Knowledgebase Item

Ref No:
Last Modified:
Wednesday, October 31, 2012
Advantage StreamlineSQL
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.
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:
Was This Item Helpful?