-
From: Wilfred Verkley [SMTP:[EMAIL PROTECTED]]
Sent: Friday, June 04, 1999 11:52 AM
To: Multiple recipients of list delphi
Subject:RE: [DUG]: ADO Hierarchial Record Sets
Does anyone remember the 1rst Normal Form rule? If Codd were dead, he would
be turning in his grave
The idea behind the ADO hierarchial record sets is this.
Say you have customers
and you have Current Orders
and you have Old Orders
You can run a query (odd as it may seem, but very powerful)
SHAPE {SELECT * FROM customers}
APPEND ({SELECT * From orders Where orderdate
#1/1/1996# And
Computer Software LTD
P.O Box 13-155
Christchurch
New Zealand
Phone/Fax (NZ) 03-3651-112
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Chris Crowe
Sent: Thursday, 3 June 1999 20:27
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO
...
What you get back is a single record set, of all the customers like a
normal Select * from
Customers. But there is two extra fields RsOldorders, and rsRecentorders.
They are a full
record set in their own right.
[ snip ]
The whole thing is handled via ADO. Puts things like the BDE to
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Kerry Sainsbury
Sent: Friday, 4 June 1999 08:43
To: Multiple recipients of list delphi
Subject: Re: [DUG]: ADO Hierarchial Record Sets
...
What you get back is a single record set, of all the customers
The whole thing is handled via ADO. Puts things like the BDE to
shame, well
it is new
technology.
You might want to check out "Nested Tables" or "NestedDataSet" in
the Delphi
help.
... Then come back and apologise :-)
Chris Crowe [EMAIL PROTECTED] said
Well I did not know it was
Well said Kerry!
Max
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Kerry Sainsbury
Sent: Friday, 4 June 1999 08:43
To: Multiple recipients of list delphi
Subject: Re: [DUG]: ADO Hierarchial Record Sets
...
What you get back is a single record set
-Original Message-
From: Wilfred Verkley [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 04, 1999 11:52 AM
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO Hierarchial Record Sets
Does anyone remember the 1rst Normal Form rule? If Codd were
dead, he would
Of Grant Black
Sent: Friday, 4 June 1999 12:19
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO Hierarchial Record Sets
-Original Message-
From: Wilfred Verkley [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 04, 1999 11:52 AM
To: Multiple recipients of list delphi
Isn't fields an array (ie 0..10) or somethinh like that, if you want to use
the field name use use ttable.fieldbyname('fieldame')
richard
"Chris Crowe" [EMAIL PROTECTED] on 03/06/99 08:32:17 am
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL
have you done :-
rsoldOrders :=createOLEObject('ado.recordset') ??
problem is, that "rsoldOrders " needs to be assigned to a Recorset object.
I have code at home for this, (delphi code) can you wait till then ??
Jeremy Coulter
Application Developer
Application Development Centre
Compaq
Subject: Re: [DUG]: ADO Hierarchial Record Sets
Isn't fields an array (ie 0..10) or somethinh like that, if you want to use
the field name use use ttable.fieldbyname('fieldame')
richard
"Chris Crowe" [EMAIL PROTECTED] on 03/06/99 08:32:17 am
Please respond to [EMAIL
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Coulter, Jeremy
Sent: Thursday, 3 June 1999 11:28
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO Hierarchial Record Sets
have you done :-
rsoldOrders :=createOLEObject('ado.recordset') ??
problem
When I did this experimentally I used the DirectAccess code unit from Opus,
which is true Delphi source code, rather than OLE. I think they now call it
DirectDAO. They used a Fields property of their Database object, something
like
DbEngine:= CreateEngine(); // create our root
:43
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO Hierarchial Record Sets
didn't see any code anywhere like that in the email I got.
Jeremy Coulter
Application Developer
Application Development Centre
Compaq Computer New Zealand Ltd.
Phone:64 3
15 matches
Mail list logo