Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!dev!dgis!jkrueger
From: jkrueger@dgis.dtic.dla.mil (Jon)
Newsgroups: comp.databases
Subject: Re: INGRES locking problem?
Message-ID: <907@dgis.dtic.dla.mil>
Date: 29 Jun 90 02:53:35 GMT
References: <1990Jun28.224823.28883@portia.Stanford.EDU>
Organization: Defense Technical Information Center (DTIC), Alexandria VA
Lines: 24

chesky@portia.Stanford.EDU (Snehylata Gupta) writes:

>id number 	|	call date	|	notes
>		|			|
>		|			|
>12345678	|			|	record1
>12345678	|			|	record2

>select call_date, notes
>from notes_tbl
>where id_number = :id

Looks like you're doing a singleton select on a column
with duplicate values (your primary key no less???)
If so you get the first one that matches.  If not,
please show more of your code so it's clear what's
happening in the select loop, e.g. are you presenting
the data to the user?  Using INGRES forms simple fields or
table fields?  And so on.

-- Jon
-- 
Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger
Drop in next time you're in the tri-planet area!