[REBOL] RE : Re: RE : Re: RE : MSSQL results
From: fmarcia:marcopoly at: 2-Oct-2002 14:58
In fact, it works nice with your approach.
The problem is that I will have to rewrite all my stored procs and that I loose the logic
"from 1 statement to several dataset".
I'm going to try another approach: contact RT support.
Franck.
-----Message d'origine-----
De=A0: Vos, Doug [mailto:[doug--vos--eds--com]]
Envoy=E9=A0: mercredi 2 octobre 2002 14:40
=C0=A0: ['rebol-list--rebol--com']
Objet=A0: [REBOL] Re: RE : Re: RE : MSSQL results
So what about another approach where you set up two ports:
sql-A: {select top 1 * from customers}
sql-B: {select count(*) nb from customers}
insert dbport-1 sql-A
insert dbport-2 sql-B
result-rows-A: copy dbport-1
result-rows-B: copy dbport-2
This seems like it would work OK.
Not familiar with your situation...
What do you lose from this approach?
-DV