Bernie: >> update TmpSline set itemno=.xitm, price=.prc, LastCost=.LstCost where >> SeqNo=.vSeqNo >> where vSeqNo=1
Is your column SeqNo Text? Is vSeqNo also Text? The reason I ask is because: >> BUT, if I just define the SeqNo as int and don't use not null unique the >> update will work (SeqNo=.vSeqNo) It would appear that vSeqNo is defined as Integer and it is possible that it could cause problems if your columns is Text. On the second issue, I am not exactly sure what the problem is, I seem to remember that you mentioned that SeqNo was an auto-number column, if so, how is it defined? I use a variable to get the value of auto-number columns all the time without any problem. Have you tried TRACEing your form to see what is happening, and when the values are changing? Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis Sent: Friday, June 24, 2005 7:22 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: R:Scope 7.5 Hi Sami, I had done the reload but I did it again and still get the disk i/o error. This is the command that gets the error update TmpSline set itemno=.xitm, price=.prc, LastCost=.LstCost where SeqNo=.vSeqNo where vSeqNo=1 BUT, If I change the where clause to limit=1 then the update works. So what's going on here? The Seqno is defined as not null unique BUT, if I just define the SeqNo as int and don't use not null unique the update will work (SeqNo=.vSeqNo) BUT, if I don't use the not null unique, I run into a strange problem in the form when I exit the first row and enter the second row: I think this is a catch 22 (I don't expect you youngsters to understand that statement) Remember my missiles about GetProperty? Well I took the advice of many of you and used a form expression instead, in order to get the Sequence No. (I have used the GetProperty in several forms before, and have not had this problem, BUT this situation is a little different) I decided to display the SeqNo in the form to see what's going on -- and this will amaze you. After entering the first row data as soon as I touch enter to go to the second row, the SeqNo changes to 8 Now I have 2 rows in the table with the SeqNo = 8 That baffled me for a few hours, when I said could it be because there are 8 rows in the region? so I changed the number of rows to 7, and sure enough the SeqNo changed to 7 So then I thought if I made it unique it wouldn't be able to change the SeqNo That brings me back to the update problem. Is this a catch 22 or not? Signed, BUT by Bernie Lis ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, June 24, 2005 5:21 PM Subject: [RBG7-L] - Re: R:Scope 7.5 > Bernie - > > You should always DISCONNECT before running Autochk so that TEMP tables > are > removed. > > The "out of disk space" error usually means corrupted indices and a RELOAD > should fix that. > > Try it before you create the temp table again and see what happens. > > Sami > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Sami Aaron > Software Management Specialists > 913-915-1971 > [EMAIL PROTECTED] > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis > Sent: Friday, June 24, 2005 4:04 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: R:Scope 7.5 > > John, > Not now. I tried it again and it works, there may have been before? > > Here's what led to this situation: > I did the following project: > project temporary TmpSline from Sline using all where limit=0 > I can insert rows into this table but when I tried to update some fields, > it > > said "out of disk space" > autochk said "error in dbinfo block" > Rscope 7.5 could not check all, 6.5 said no errors. > when I disconnect and reconnect autochk said no errors > Rscope, I guess does not show temp tables, is that correct? > So I don;t know what to do about updating this temp table. Any suggestions > > ----- Original Message ----- > From: "John Minyo II" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[email protected]> > Sent: Friday, June 24, 2005 3:45 PM > Subject: [RBG7-L] - Re: R:Scope 7.5 > > >> At 02:10 PM 6/24/2005, you wrote: >>>in checking dbinfo, I get no errors >>>in checking structure all, I get access violation ....... >>>If I check structure one at a time, I get 0 errors for each table. >>>Same for data all gets access violation.......... >>> >>>Anyone else experience this? >>>Bernie Lis >> >> Dear Bernie Lis, >> >> Is there a phantom table (empty field) in the >> "Select Table.." List Box? >> >> John >> > >
