>>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
Look closer to your SelectCmd - it currently does not have a where condition at all!
If it's not broken, fix it until it is.
My Blog