Advantage Knowledgebase Item

Ref No:

121031-2579

Last Modified:

Wednesday, October 31, 2012

Product:

Advantage StreamlineSQL

Category:

Configuration

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