Fielddefs

[auditdi30]

Hello!

I am using paradox tables, and Delphi 7.

1. is it possible to change the fieldnumber in fielddefs?? Etc. if I make a table with 3 fields; name, adr, and pos. And later want to change it to name, post and adr. How to do that by code?

2. Is it also possible to delete a field in a table, by code?? If so, how??

Know that both this questions can be solved in Database Desktop, but want to do it by code!

TIA
Kåre!

 

[smays]

This may not answer your question the way you want, but unless you are specifically wanting to modify (alter) the actual Paradox table file, you can control in software both at design time and run time the *displayed* relative position of the fields without affecting the actual relative position of the fields in the actual Paradox tables.

For example:
SELECT name, adr, post FROM table_name;
SELECT name, post, adr FROM table_name;

The TDBGrid (should you use it) will show the order of the fields as they appear the in SELECT statement.

Steve.

 

[lespaul]

yes you can delete a field in code (actually running a SQL command):

ALTER TABLE tableName DROP COLUMN fieldName

Leslie