🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1250

Query doesn't show fields

#1250
From: Peter van Mierlo
Date: Wed, 18 Mar 1998 00:00
23 lines
1316 bytes
Hi,

I have 2 databases, no 1 called 'Personal', which contains peoples
names, addresses etc. The second datase is called 'Dossier'
Defined a query (PersDos.QBE) which contains the commands:

Select Personal Order PersId in Select
select Dossier Order DosId in Select

On a form for 'Dossier' the this.view ="PersDOS.QBE"...so far so good..
Now i use a combobox on this form to select a person from 'Personal',
which goes OK...the next step is to display several fields from Personal
on this form. The only thing is...i can select a person from the
combobox but the other fields like birthdy,male/female I can show on the
screen
and also when selecting a other person these fields are not been
displayed.

I think i'm doing something wrong but can't find out WHAT...!


Greetings Peter
Technical Details
Message-ID: <35104305.4A18@worldaccess.nl>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,45b861339138745b,start
X-Google-Attributes: gidff5a1,public
From: Peter van Mierlo <annazkh3@worldaccess.nl>
Subject: Query doesn't show fields
Date: 1998/03/18
Message-ID: <35104305.4A18@worldaccess.nl>
X-Deja-AN: 335229833
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Reply-To: annazkh3@worldaccess.nl
Content-Type: text/plain; charset=us-ascii
Organization: St. Annaziekenhuis
Newsgroups: borland.public.vdbase.data.sql