Fred,
>I really can not understand, what is wrong in this code:
>
>select aa.*, bb.fullname as FName, " " as ntflag, .f. as currmnth, .f. as recap ;
>>>> from &lcSourceTbl aa, Towns bb;
>>>> where &lcWhere and;
>>>> aa.price >= 1000 and !deleted() ;
>>>> into table &lcTempTable
>>>>
>>
>>Ok, I changed to aa and bb instead of a and b, and still have the same problem.
>>It works fine, if I comment:
>>
>>*!* set talk on
>>*!* set talk window
>>*!* set confirm off
>>
>>
>>and if I uncomment, it gives me this error. If it's a bug, could somebody report it to MS, if not, I don't know, where else to look...
>>Do I need to investigate more? :(
>>
>>>>
>Are you still getting the "beyond string" errors? You say your SELECT doesn't
work, but we can't see what code you've got in your WHERE clause, etc, because of the macros. Maybe it's something in there? Is this VFP5 or 6? I seriously doubt that M$ will fix any more bugs in VFP5...
Yes, as I said, I'm still getting the same 62 Error, if I uncomment these lines in VFP5.0. If I comment them, it doesn't complain. In VFP6.0 it works fine in both cases. The similar SQL works fine in FPD2.6 also.
These are variables in macros:
lcYear=thisform.txtYear.value
lcWhere=thisform.where()
lcWhere=iif(empty(lcWhere),'',lcWhere+' and ')+'aa.CCODE+aa.TOWN=bb.County+bb.TOWN'
lcState=thisform.cmbState.displayvalue
OutPutDir='J:\REDP\Output\ATD\'
lcTempTable=OutPutDir + 'PrntATD'
lcSourceTbl=lcState+"SAL"+right(lcYear,2)
Thanks in advance.
If it's not broken, fix it until it is.
My Blog