>What does 1=0 do? How come when I use SPT it works, like this:
>
>= SQLEXEC( gnDataSource, "SELECT * FROM parcel WHERE JobOrderID=<somevalue>"
>
If the above works well enough I am pretty sure there is something different in your specific CA class.
If you connect through the same gnDataSource, you could manually fix/check the SelectCmd in the BeforeCursorfill() HookMethod
(typing without checking the actual method names, but the parameters are all reference ones - you cannot miss it)
One other thing: make sure there is a corresponding index on the MySql-Backend for the JobOrderID column
(but even that should not take hours, more like minutes....)
Build and Query your CA from the Command window with only one or two colums and perhaps
a smaller copy of that table for test reasons - the before and after hookmethods give you excellent points to
log duration, statement used, No. of records returned and so on. This is data as well ;-)
HTH
thomas