Group,
Some of you are old time coders. I'm relatively new to coding.
As I look at old cursors that were written in a time before me
I look at ways for speed improvements.
Many of you already know this but I keep experimenting with SQL
commands inside R:BASE and still have much to learn but just
found this one.
UPDATE tEDITable820 SET +
CUSTNO = CUSTNO +
FROM CUSTINFO,tEDITable820 +
WHERE (INT(tEDITable820.EDIFMStore)) = (INT(CUSTINFO.FM_CUSTNO)) +
AND tEDITable820.EDI_CustID = CUSTINFO.EDI_CustID
Notice the INT around the statement. It's because the EDI data transmitted
is text and I need to compare it another text in the table. A text field of
00520 is not equal to 0520.
This nugget lets me remove a cursor.
Jan
