Home > Archive > Visual Basic > March 2006 > Help with temporary recordsets
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help with temporary recordsets
|
|
|
| Hi,
I have a temporary recordset which is based on two recordsets. When I load
this temp. recordset into a datagrid the id's are our iof order i.e. 5, 3, 1
etc. Is there any way I can order the recordset by the id column once it is
in memory?
Appreciate any help on this
Thanks
Damon
| |
| Martin Walke 2006-03-28, 6:56 pm |
| Hi Damon,
Can't you just order the temp recordset at the time you create it? Failing
that write the recordset to a new table, use that to populate your datagrid
ordering it when you open it. What does your SQL statement look like?
Martin
"Damon" <nonsense@nononsense.com> wrote in message
news:qn7Wf.23607$H%3.574@newsfe5-gui.ntli.net...
> Hi,
>
> I have a temporary recordset which is based on two recordsets. When I
> load this temp. recordset into a datagrid the id's are our iof order i.e.
> 5, 3, 1 etc. Is there any way I can order the recordset by the id column
> once it is in memory?
>
> Appreciate any help on this
>
> Thanks
>
> Damon
>
|
|
|
|
|