>>
>>the SELCTCMD is defined by code. Its just like:
>>
>>THIS.SELCTCMD = 'SELECT Cur1.[Field "C"] FROM myTable AS Cur1'
>>
>>
>>Or I do not understand what you mean with catch.
>
>Are you sure you pasted this from your code? As the property name is .SelectCmd - note the typo you made twice here.
>
>What happens if you run the same command as SPT? And, BTW, why don't you give an alias to that field, i.e.
>
>
>THIS.SELECTCMD = 'SELECT Cur1.[Field "C"] as FieldC FROM myTable AS Cur1'
>
Nope, it's not a copy from my code. This is just like. The original statement is a bit longer, but that is what failed. And, I can't give the original statement. We have to simulate it. Alias was skiped in the example for lazyness. The real thing has it.
The typo was made once - this is called
copy and paste error. :)
By SPT you mean to run it as SQLEXEC like
?SQLEXEC(m.lnHld,'SELECT Cur1.[Field "C"] AS FieldC FROM myTable AS Cur1')
?
This ends up the with same problem, was my first try after the CA failed. :(
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]