Why my WRITE @RECORD ... erase data (OpenInsight 32-Bit)
At 16 JAN 2003 10:10:54AM Alan Kezber wrote:
I need to recover some data from archive table to an other table. I opened my table and read each record, after for each record, I wrote into my Invent table with write @record…. (STORED PROCEDURE) I recoverED my data from archive table but in my invent table,the write @record… erase some data . Someone could tell me why?
(oPEN iNSIGHT V 4.0.2)
At 16 JAN 2003 02:47PM Richard Bright wrote:
I thought Don explained that you should NOT use @Record. If you are using @Record in a stored proceedure called from a data-bound form, there is a good chance of getting things messed up.
At 16 JAN 2003 03:11PM Alan Kezber wrote:
My stored procedure is not called from a data-bound form. I opened my table and select , after I used write @record…
At 17 JAN 2003 07:10AM Uwe Schroeder wrote:
See my response to your question of yesterday
At 17 JAN 2003 08:06AM Don Miller - C3 Inc. wrote:
Alan ..
I have used a lot of my old AREV code from non-databound forms without any problems .. it uses @RECORD, @ID, @MV, @DICT, etc. I've had zero problems with it. I DO tend to use the SELECT BY SETTING CURSOR construct or an RLIST Select statement rather than the RBASIC SELECT construct. I've just tested an RBASIC SELECT and can report that it works as expected in OI 3.7 and OI 4.12, though. The test file had 1335 records with no multi-part keys. The keys were alphanumeric and not integers, though.
I wish I could offer more help.
Don Miller
C3 Inc.
At 17 JAN 2003 09:16AM Oystein Reigem wrote:
Alan,
Your code does look OK. Have you shown all your code?
- Oystein -
At 01 FEB 2003 07:56AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Writing @RECORD should not be erasing data, but writing out the contents. Have you actually checked that the contents of @RECORD (and presumably @ID) are what you expect them to be?
World Leaders in all Things RevSoft
