Retrieving default field values from MSSQL table via BDE

Hedley

Delphi Developer

Sat, 14 Feb 2004 23:25:37 GMT

Retrieving default field values from MSSQL table via BDE

I need to retrieve the default value for a field in a table in a MSSQL database.

I have tried using the BDE's DbiGetVchkDesc function. In the resulting VCHKDesc structure I assemble a string from the aDefVal array. Instead of the actual value I get a string (eg DF__READER_READ_08246310). If I let MS Enterprise Manager generate a SQL script for the Database definition I see this string, and the accompanying default value.

This is all fine, however in my application I can't get to this default value.

Any ideas?

Thanks
Hedley

Other Threads

1. Retrieving default field values from MSSQL table

2. Retrieving a string field with more tha 255 chars (MSSQL x BDE)

3. Retrieving string fields with more than 255 chars (BDE x MSSQL)

4. Setting Default Field Values when Building a Table on the Fly

5. ADOX and default value of a table's field

6. Alter table, how to setup default field values?

7. how to create table with field's default value

8. Creating a paradox table with default value in some fields

9. Default Field Values When Creating Tables In Code

10. retrieving SQL Default Values