|
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) |
