🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.programmer
Article #1839

SybaseDemo.dbmodel seems to be defective

#1839
From: Ralf E. Stranzenbach
Date: Thu, 19 Nov 1992 22:56
40 lines
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!ralf

Show 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