Advantage Developer Zone

 
 
 

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
Was This Item Helpful?