Page 1 of 1

how to access mysql flags

Posted: Tue 28 Feb 2006 13:36
by tester
Hi, I am evaluating your dbExpress drivers and coz I am new to dbExpress I need some little advice. Is it possible to read mysql field flags?

AUTO_INCREMENT_FLAG ( TField->DataType==ftAutoInc ? )
MULTIPLE_KEY_FLAG ( ? )
NOT_NULL_FLAG ( TField->Required ? )
PRI_KEY_FLAG ( TField->FieldKind==fkLookup ? )
UNIQUE_KEY_FLAG ( ? )

If u can point me to some document/help. Thx for your time.

Posted: Tue 28 Feb 2006 15:23
by Antaeus
Because of dbExpress restrictions dbxMda don't allow to retrieve such information from the server. We advise you using special MySQL Server commands (e.g. DESCRIBE, SHOW COLUMNS etc) to get information about columns. See MySQL Reference for more information.