Need some expert advice on a cursor problem I’m having. The situation is a large form in which is using about 10, one at a time. Nothing “exotic” is going on with the cursor in question. All of them work except one. Data is being retrieved from 2 tables. The cursor is dropped, declared, opened and then the data is to be fetched. This is the point where things go south.
The SQLCode being returned is ‘100’ and the Error Variable value returned is ‘406’, which means End-Of-Data. In trying to determine the cause, a BROWSE was placed before the FETCH having converted the DECLARE statement. The three rows expected are displayed. Put a SELECT after, again converting the DECLARE statement plus adding a LIMIT = 1 clause. No problems. Two very simple questions here: 1: Why is R:Base returning the End-Of-Data condition when the SELECT clause is correct? 2: What needs to be done to fix the situation? Thank you in advance for your help. Stu Hellman [cid:[email protected]]<http://www.qmiusa.com/> Stuart Hellman Software Designer Email: [email protected]<mailto:[email protected]> Toll Free: 800-446-2500 International: 01 630-529-7111 Extension: 1029 www.qmiusa.com<http://www.qmiusa.com> . ________________________________ This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
