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
