>Add where 1=0 in your SelectCmd command. In addition, specify there all columns instead (and if you don't need some, remove them)

What does 1=0 do? How come when I use SPT it works, like this:

= SQLEXEC( gnDataSource, "SELECT * FROM parcel WHERE JobOrderID=<somevalue>" 

Also works in MySQL Query Browser. I used the same CA class to access all my other tables with no problems.

It worked initially when the number of records of Parcel table was just a few thousand. It started freezing up when it grew. The weird thing though, is even if I use the NoDATA option, it still freezes up!

Dennis