Using the A TMySQL40Connection to access MySQL I get the following error:
":2" is an invalid integer
While using a TSQLQuery running the following SQL:
select * from tests
Can anyone shed some light on this. I've tried setting "ParseSQL" to
false, which would defeat my purpose. Even with that I keep getting this
error. Some times the ":2" will be a ":3". There are three other
TSQLQuery objects in use that don't have problems. They all have similar
queries they just access different tables.
I'm wondering if this doesn't have something to do with data types. Here
is the structure of the table:
Field Type Null Key Default Extra
id int(11) PRI auto_increment
organization int(11) MUL 0
name char(32)
target char(128)
test char(16)
next_run datetime MUL 0000-00-00 00:00:00
frequency int(11) 0
last_run datetime 0000-00-00 00:00:00
result char(4)
All of the tables in question have very few records. They probably will
never exceed 30 records per table.
THX - Jon
--
Jon Foster
JF Possibilities, Inc.
[EMAIL PROTECTED]
541-410-2760
Making computers work for you!
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
