Article View: comp.sys.next.programmer
Article #1839SybaseDemo.dbmodel seems to be defective
From: Ralf E. Stranzenbach
Date: Thu, 19 Nov 1992 22:56
Date: Thu, 19 Nov 1992 22:56
40 lines
1967 bytes
1967 bytes
Hi,
i tried to get some things done using NeXT's dbKit adaptor for the
SyBase database server. I spent some time (the whole evening) to get
a very small program working. The things it should do is to show a
list of "Authors" and, in a second browser, a list of their
publications.
As a first step i would be pleased to see the cartesian product of
Authors * "their titles".
But even this very small example failed. Everytime i tried it to "Run"
from the InterfaceBuilder it crashed.
After some time peeking around i noticed, that the model
"SybaseDemo.dbmodel" has some missing relationships:
RelationName Local Field matches External Field
----------------- ----------------- ------- -------------------
Author.Titles = Author.authorId >> TitleAuthor[authorId]
Title.Authors = Title.titleId >> TitleAuthor[titleId]
TitleAuthor.author = TitleAuthor.authorId > Author[authorId]
TitleAuthor.title = TitleAuthor.titleId > Title[titleId]
After i've entered this relationships by hand, my tinyApp(tm) works...
IS THERE ANY REASON WHY THESE RELATIONSHIPS WERE MISSING ?
I thought about it, but i do no reason why it should be better not to
enter these valid relationships... Therefore i am currently somehow
confused.
- ralf
--
Ralf E.Stranzenbach - (NeXT)-Mail: ralf@reswi.en.open.de
Fido: Ralf_Stranzenbach 2:245/5800.12
(Voice)-Phone: +49 2302 / 68403
--
Computer sind die praktische Anwendung der Murphyschen Gesetze.
Technical Details
Message-ID:
<RALF.92Nov19235609@jodokus.en.open.de>Path:
arc1-ca.pugleaf.net!sparky!uunet!mcsun!Germany.EU.net!horga!reswi!reswi!ralfShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!mcsun!Germany.EU.net!horga!reswi!reswi!ralf From: ralf@reswi.en.open.de (Ralf E. Stranzenbach) Newsgroups: comp.sys.next.programmer Subject: SybaseDemo.dbmodel seems to be defective Date: 19 Nov 1992 22:56:09 GMT Organization: News Server fuer en.open.de Lines: 40 Message-ID: <RALF.92Nov19235609@jodokus.en.open.de> NNTP-Posting-Host: localhost.en.open.de