|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Field DataTypes / Keys |
| Author |
Message |
|
|
| Posted : 2008-02-06 04:51:04 |
I've recently purchased FlexODBC for managing an old DOS based Flex database. I'm able to return data fine and update data. I'm looking at writing some windows based applications that will allow me to update / delete data from tables. I have a couple of Concerns:
1) How can I check the existing field data types of a table?
2) I'm concerned about inserting records in a table that have a "Record" number. I'm concerned maybe the old DOS based application (which will still be used) may be keeping a "control file" with the next Record number to insert. I don't want any data collisions or conflicts. Any suggestions?
Thanks,
Dave |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-02-06 07:30:50 |
You can use the FlexODBC stored procedure sp_columns tablename to see the structure of any DataFlex table.
You can't insert values into the Record_Number column (field), this a internal column used and maintained automatically by the DataFlex embedded DBMS itself. |
|
|
|
|