WAIT WINDOW MyUDFThatChangesACursorAndReturnsAStringValue()
:)
>You are mistaken. The WAIT statement cannot change data in a cursor.
>
>>
>>I solved a weird bug in our code....
>>
>>and it has to do with this WAIT WINDOW
>>
>>
>>WAIT WINDOW 'Charged to Account No. ' + ALLTRIM(STR(mAR_Link)) TIMEOUT 2
>>
>>
>>When the code runs up to this statement, I can stop the code and see that I have 4 records in a table called REGTEMP which is used EXCLUSIVELY.
>>
>>After the WAIT WINDOW executes and I stop the code, I now have only 1 RECORD in REGTEMP! And this record is missing some of its data in some of the fields!!
>>
>>
>>When I change the WAIT WINDOW to....
>>
>>
>>WAIT WINDOW 'Charged to Account No. ' + ALLTRIM(STR(mAR_Link)) NOWAIT
>>
>>
>>Everything is happy in FoxPro land..... and the code works.... I still have my 4 records in REGTEMP!
>>
>>Anyone come across a bug like this in WAIT WINDOW???
>>
>>Thanks!
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up