Thanks for the compliment. I have never seen the odd/even thing happen on a SQLCONNECT or SQLSTRINGCONNECT. Must be a "Ric" thing. < bg >


>Hi Mark,
>
>Well, I have thank you for your time. I have found a rather peculiar circumstance. FYI (since it appears to be only on my system) when every SQLEXEC() call in the CABuilder executes, every odd instance of that SQLEXEC() returns 0 (zero). Every time. However, every even instance of that same SQLEXEC() returns 1 (one). Every time. So, the first time, the SQLEXEC() is returning a zero, the second - a one, the third - a zero, the fourth a one, etc. Really weird. I only discovered this by testing SQLEXEC() from the command wind after SET STEP ON.... The trace window would return a zero, and then I would run the SQLEXEC() from command window and get a one... accidentally, I repeated the same SQLEXEC() in the command and got the zero. This happens every time.
>
>I have gone back through the code provided and 'doubled' every SQLEXEC(). There is one exeception - the SQLCONNECT() if fine. It execcutes correctly the first time, every time.
>
>In your experience, is it possible for VFP to be executing too quickly to register the SQLEXEC() return value from SQL? Or, is it Ric in New Zealand just being 'different'? <g> Anyway, the doubling of the commands in code seems to be working great!! I really think this utility is way cool....