For this no problem.
What you have to know is that a dBase datasource is represented by all .dbf files
found in the same directory, each of them being a table. Then adding a new table
is just a question of adding a new file. (although I didn't check, the driver may need to be reinitialized
in order that the new file is acknowledged, I don't know)
>>2. a new column is added to the dbase file
For this, I don't know if the ALTER TABLE SQL command is supported by the driver.
>>3. insert values into a new column based on a pre-defined column
This is standard SQL
>>4. send the file back to the users via email.
This is standard CFML, even CF 4.5
>>1. how to read a dbf file on the fly without using OBDC.
A dbf file is a fixed format text file. However it contains zeros, so you cannot work on it directly in CF.
But it is pretty straightforward in C in a CFX_ custom tag.
>>2. is there Cold Fusion commands to create a new column in a dbase file?
In CF no, but in principle there is one in SQL : ALTER TABLE <table name> ADD <column name> <data type> <size>
but you should verify that this command is supported by the dBASE ODBC driver.
If (it is not) AND (your project is important) AND (you have a substantial budget)
THEN I could do a CFX that would do it for you.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
