Buddy, It would look something like this:
WHERE Quote# = ‘123456’ AND Window = 1 AND CostType = ‘A' AND T2.SnapShotID = 9 AND T1.MasterPart# = T2.MasterPart#') The WHERE clause should be good. As stated before, the DECLARE, and OPEN return a 0 (zero). The FETCH doesn’t want to cooperate. I appreciate the input. Stu From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Wednesday, June 28, 2017 10:20 AM To: [email protected] Subject: RE: [RBASE-L] - Peculiar Cursor Behavior Stu Would it be possible to show us final vWhere variable with the actual values. Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Stuart Hellman Sent: Tuesday, June 27, 2017 1:11 PM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - Peculiar Cursor Behavior There are different sets of tables used for different processes, so that is why the WHERE clause is a variable SET VAR vTable = 'QuoteDetail' SET VAR vWhere = ('WHERE Quote# = .vQuote# AND Window = .vWindow ') SET VAR vWhere = (.vWhere & 'AND CostType = .vPrimAlt') SET VAR vWhere = + (.vWhere & 'AND T2.SnapShotID = .vSnapShotID AND T1.MasterPart# = T2.MasterPart#') BROWSE T1.MasterPart#, length, ummult FROM &vTable T1, snappartmast T2 &vWhere DECLARE QteDetail CURSOR + FOR SELECT T1.MasterPart#, T1.Length, T2.UMMult + FROM &vTable T1, SnapPartMast T2 &vWhere OPEN QteDetail FETCH QteDetail + <--Here is where the 406 error code is returned in my error variable INTO vQPart# vInd, vLength vInd, vUMMult vInd IF SQLCODE = 100 THEN GOTO EndLoop ENDIF From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Tuesday, June 27, 2017 9:28 AM To: [email protected]<mailto:[email protected]> Subject: RE: [RBASE-L] - Peculiar Cursor Behavior Stuart Is it possible for you to show the complete browse and declare statements. Buddy From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Stuart Hellman Sent: Tuesday, June 27, 2017 8:51 AM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - Peculiar Cursor Behavior 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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.
