APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX System Administration :
Is it possible to change the field names that are used by APPX/ODBC?
First, before you run asql.exe, set the expert mode environment variable as follows:
 
ASQL_EXPERT_MODE=1
 
1) Run asql and select the file that you wish to import the schema for.
2) Click on the "Show Script" button. The "create table" script should be displayed in the lower window.
3) Remove all of the comment lines from the script
4) Change field names to suit your purposes
5) Remove the last ";" from the very end of the script
6) Click on the "Try Again" button.
7) If "OK" is displayed, then everything probably worked as expected.
8) If there is an error, drop the table and try again.
9) WinSQL can be used to verify that the table, field names, and indexes were created as expected.
 
[Append to This Answer]
2007-May-16 11:59am
Previous: (Answer) Can we update records in APPXIO files using SQL Statements from SQL Server?
Next: (Answer) French Characters in Oracle
This document is: http://board.appx.com/cgi-bin/fom.cgi?file=484
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.