I'm having problem to use ALTER TABLE on a dbase file using DSN-less
connection.
It' an online conversion application where users submit their dbase files
and the app will add some columns before posting it back to the user via
email.
The code only works if there is no data in the table.
My workaround solution was
1. to create another dbase table based on the original structure of
submitted dbase file
2. add 2 additional columns
3. populate the new table from original dbase file
I'm not too sure what SQL statement to get an exisiting table strucutre.
Below are the code snippets.
<cfset MyConnectionString = "Driver={Microsoft dBase Driver (*.dbf)};
DefaultDir=C:\web\lis\translator\;">
<!--- This DOESN'T WORK UNLESS THERE IS NO DATA--->
<cfquery name="GetExample" connectstring="#MyConnectionString#"
dbtype="DYNAMIC">
ALTER TABLE india drop Address
</cfquery>
Thanks
Nyon
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
