Page 1 of 1

LongInt and Integer

Posted: Fri 10 Feb 2006 12:06
by Maksim Krivohizha
Hi all!

Database fields described as follow:
....
`crid` int(4) unsigned NOT NULL auto_increment,
`cgid` int(4) unsigned NOT NULL default '0',
....

All this types represented as TLargeIntField in MyDAC.
Manual definition of this fields as TIntegerField cause error:
Type mismatch for field 'crid', expecting: Integer actual: Largelnt.
How can i use TIntegerField instead of TLargeIntField?

MyDac 4.00.2.8.

Tnx.

Posted: Fri 10 Feb 2006 14:11
by Ikar
MyDAC tries to choose the most appropriate field type for server data type. The most appropriate field type for UNSIGNED INT data type is TLargeIntField. To use TIntegerField, you should define your fields as INT (without UNSIGNED).

Posted: Fri 10 Feb 2006 16:13
by Maksim Krivohizha
Really, i redefine fields in database as you advise - it work, now we have what we need.

Thank you!