The question on the DataType = ftInteger. why?

[zhbj]

Hello, visit access the database, a table of a field data type is automatically numbered, with TADOConnection, TADOQuery access, the return DataType = ftAutoInc,

but with TUniConnection, TUniQuery visit but return is ftInteger, somehow?

[AndreyZ]

Hello,

It's a standard UniDAC behaviour. Please describe why you need this functionality.

[zhbj]

Thanks to reply, because the import data, the "auto-numbered" fields are not imported, if the auto-numbered fields and integer fields are usually shown as ftInteger, rather than ftAutoInc and ftInteger, which can not be confirmed Need to skip, which need to fill in the data.

[zhbj]

Hello,

It's a standard UniDAC behaviour. Please describe why you need this functionality.

Thanks to reply, because the import data, the "auto-numbered" fields are not imported, if the auto-numbered fields and integer fields are usually shown as ftInteger, rather than ftAutoInc and ftInteger, which can not be confirmed Need to skip, which need to fill in the data.

[zhbj]

In addition, do you have no other way to distinguish ftAutoInc and ftInteger with Unidac ?

[AndreyZ]

You can use the following code to determine if a field is autoincrement:

Code: Select all

TCRFieldDesc(UniQuery.GetFieldDesc('fieldname')).IsAutoIncrement

Note that you should add the CRAccess unit to the USES clause of your unit.

[zhbj]

You can use the following code to determine if a field is autoincrement:

Code: Select all

TCRFieldDesc(UniQuery.GetFieldDesc('fieldname')).IsAutoIncrement

Note that you should add the CRAccess unit to the USES clause of your unit.

Thanks!

[AndreyZ]

Feel free to contact us if you have any further questions about UniDAC.