Persistent Autoinc fields

[softsmith]

MySQL version 7.2.8 for XE2

When I create persistent fields from either a MySQL or MyTable, Autoinc fields are shown as TWordfield instead of TAutoincfield.
How can I change this so autoinc fields are created ? (Of course the database tables have been set correctly to autoinc)

Thanks for your help

[DemetrionQ]

Hello.

MyDAC fills in auto-incremental fields automatically on inserting a new record to a dataset, independently on whether they have the TWordField type or TAutoIncField.

[softsmith]

Thanks for your reply.

Unfortunately, I work a lot with memory tables and string grids, and it is important that I know what the data type is when I copy data from the MyQuery to the memory table or string grid.
I could check each time with a "SHOW FULL COLUMNS FROM xxxtable", and then see what the "extra" column is, but this means a round trip to the database every time.

Any suggestions ?

Thanks

[softsmith]

I have just been reading the help file, and one thing I found interesting was the section on data type mapping. Can this be extended to cover autoincs ?

Thanks

[DemetrionQ]

Hello.

Data Type Mapping is not designed for definition of auto-incremental fields or mapping in TAutoIncField.
You can define whether a field is auto-incremental in the following way:

Code: Select all

  if MyQuery1.GetFieldDesc('YourField').IsAutoIncrement then
    // ...  Field is AutoIncrement

[softsmith]

Thanks for that. Just what I was looking for.

Regards

[DemetrionQ]

If any other questions come up, please contact us.

[m227]

Hi,
Is there any way to make Field TAutoInc type when obtaining field definitions from MySQL Table? One of components I use require it, if the key value of new record would be set automatically.
Michal

[ViktorV]

The similar question has already been discussed on our forum. Follow the link viewtopic.php?f=7&t=7332