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
