🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: comp.sys.next.programmer
1 messages
1 total messages Started by Ralf E. Stranzenbach Thu, 19 Nov 1992 22:56
SybaseDemo.dbmodel seems to be defective
#1839
Author: 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.
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads