Hi Razzak, I just installed the latest version of R:Base turbo V8 & it's doing the same error the first versions of V8 did.
When updating an SQL server table, it will apply the same value to all the rows affected by the pointer. In the case below, (f_docligne is an SQL server table) it will affect the latest value to all the rows in the select clause. DECLARE c1 CURSOR FOR SELECT nligne,codeart,pr FROM pv OPEN c1 FETCH c1 INTO vno,vcodeart,vpr PAUSE 3 USING .vcodeart CAPTION 'Mise à jour PR: ' OPTION themename longhorn WHILE SQLCODE <> 100 THEN PAUSE 4 USING .vcodeart CAPTION 'Mise à jour PR: ' OPTION themename longhorn UPDATE f_docligne SET dl_prixru = .vpr WHERE dl_no = .vno FETCH c1 INTO vno,vcodeart,vpr ENDWHILE DROP CURSOR c1 This code worked fine with the previous version (before the changes in indexes). I hope you can help. Thanks, Philippe. Ménard Pacifique [EMAIL PROTECTED] Tel: +687 27.62.23 ext 220 Mob: +687 77.15.76 Fax: +687 27.68.42 -----Message d'origine----- De : [email protected] [mailto:[EMAIL PROTECTED] De la part de A. Razzak Memon Envoyé : jeudi 18 septembre 2008 07:00 À : RBASE-L Mailing List Objet : [RBASE-L] - R:BASE 7.6 and Turbo V-8 Updates (09/17/2008) Wednesday, September 17, 2008 (4:00pm Eastern) To All Users of R:BASE 7.6 and Turbo V-8 for Windows: In our quest for perfection, we are constantly embracing the latest technology and development tools, through the end-user feedback, which gives us great pleasure and satisfaction in providing you with the R:BASE you have always wanted. It is my pleasure to announce the fine-tuned updates of R:BASE 7.6 and Turbo V-8 for Windows, that takes advantage of network connection methods as well as the speedy indexes in a true multi-user environment. In addition, these updates also include an enhanced UNLOAD command to include the correct string for SCONNECTed databases and SATTACHed tables when used as "DNS-Less" connection. All updates of R:BASE 7.6 for Windows (Build:7.6.4.30919) and R:BASE Turbo V-8 for Windows (Build:8.0.18.30919) are now available at: R:TimeMachine: http://www.rtimemachine.com Enjoy these special updates and make sure to have fun! Very Best R:egards, Razzak. --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
