I'm trying to write a Delphi program that accesses a MySQL database via
MyODBC. It's going pretty well except for a sticky problem I'm having with
an unsigned integer column.
I have a column named 'IP', type unsigned integer, that will hold IP
addresses. However, Delphi seems to assume this column is a signed integer
column and limit the range accordingly. At least that's my best guess for
what's happening. For example, this code fragment:
IP := $FFFFFFFF;
Str( IP, IPstring );
tblDigital.FieldByName('IP').AsString := IPstring;
throws an exception saying that 4294967295 is not a valid value for this
field.
Do I have any options other than giving up and using a signed BIGINT field?
----------
David Brodbeck, System Administrator
InterClean Equipment, Inc.
Ypsilanti, Michigan
[EMAIL PROTECTED]
(734) 975-2967 x221
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
