saving hierarchical data in a smart way?

From: "Jens" <jens.burup@xxxxxxxx>
Date: Wed, 14 Sep 2005 23:09:09 +0200

Hi
I got 3 tables bound to each other hierarchicaly (one to many), first I save
the top level table with a known key,
and then I search the table for my known key to find the autogenerated ID ,
and then insert that ID into the next table,
and so on.

Is there a smarter way to save all data in one quiry?

Regards
Jens

.

Prev by Date: Re: Query tables in two access databases with password
Next by Date: Re: Help: inappropriate OLEDB timeout:
Previous by thread: Error: There was a problem retrieving the list OLE DB providers
Next by thread: Re: Help: inappropriate OLEDB timeout:
Index(es):
- Date
- Thread

Relevant Pages

[Redruth/Cornwall] Wanted: i440 BX mainboard
... ATX standard form factor required (midi tower). ... Regards ... Jens ... Prev by Date: ...
(uk.adverts.other)
Wanted: i440BX mainboard for PIII slot1 proc.
... Standard ATX form factor (midi tower) requiered. ... Regards ... Jens ... Prev by Date: ...
(uk.local.southwest.adverts)
Re: Outlook 97: No transport providers
... have upgraded my Outlook and now it works. ... Regards ... Jens ... Prev by Date: ...
(microsoft.public.outlook)
Windows Server 2003 IAS Log session Time
... does anybody know how i can log the session time for users in IAS on ... Best regards, ... Prev by Date: ...
(microsoft.public.internet.radius)
AVR / ATiny GNU C-compiler?
... Is there a GNU C-Compiler and a free workbench available for the ATiny 13? ... Regards ... Jens ... Prev by Date: ...
(comp.arch.embedded)