----- Original Message -----
Sent: Tuesday, October 26, 2004 6:44
PM
Subject: [RBG7-L] - PK and Rule
headaches
Hi all
I am having 2 problems, I am using the
latest build of 7.1 RBWin
1) I have a simple table 2 columns, Kid
and Teamname.
the data looks something like this
Kid
Teamname
danlel
soccer
daniel
baseball
....
....
The PK is on both columns, that way I can't put
in Daniel in twice for
soccer.
Well, I opened the table and tried to edit
daniel and change it to Daniel and
I get a PK error about unique. I tried a
few times then I got an error about
resources required by command not
availavle.
Below is the table structure and data. I
loaded it on comcomp and tried several
times to change basl to Basl. Sometimes
it worked on the first row but on the
second I either get an error or Rbase takes a
long time to update the row then
gets stuck, I have to Esc from the table
to do anything else.
2) I had a similar thing happen with
rules. I had some bad data in that voilated
the rule but when I went back to edit the data
so the data is correct with the rule
I get a resources error and can't change the
data.
No big deal, I just deleted the rule fixed my
data and remade the rule.
But when I got the PK error I started wondering
if I am doing something wrong
or what?
Thanks
Marc
CREATE TABLE `Team` +
(`TeamName` TEXT
(20) NOT NULL +
('Value for column TeamName cannot be null')
, +
`kid` TEXT (25) NOT NULL
+
('Value for column kid cannot be null') )
SET CASE OFF
SET
AUTOSKIP OFF
SET REVERSE ON
SET BELL OFF
SET NULL '-0- '
SET
DATE YEAR 5
SET DATE CENTURY 19
SET DATE SEQUENCE MMDDYYYY
SET TIME
SEQUENCE HHMMSS
SET TOLERANCE 0.
SET ZERO ON
LOAD
`Team`
NONUM
'Soccer Elite 89','Rebecca'
'Soccer United
94','Daniel'
'Baseball','Daniel'
'Magic','Rebecca'
'1','basl'
'2','basl'
'3','basl'
'4','basl'
'Past
/ possible play','BASL'
'misc xx','Misc'
END
SET DATE FORMAT
'mm/dd/yyyy'
SET TIME FORMAT 'HH:MM AP'
SET DATE SEQUENCE
MMDDYY
SET TIME SEQUENCE HHMMSS
ALTER TABLE `Team` ADD PRIMARY KEY
+
(`TeamName` +
`kid` ) +
('Values for rows in Team must be
unique',+
'Cannot delete - values exist in another
table',+
'Cannot update - values exist in another table')
RULES
'No such person Please add to the Kids file'
+
FOR `Team` SUCCEEDS
+
WHERE EXISTS (SELECT Kid FROM Kids WHERE Kids.Kid = Team+
.kid)
