469,631 Members | 1,294 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

Updating a dynamic recordset. Best way...

Ant
Hello, I'm developing a program that will include a window showing current &
previous records using a scrollable recordset. I need to add records to the
recordset & have new records immediately available in the current record.
What is the most common way of adding new records. Is it:

i) by adding records via the same form & hence using the same recordset?
(This seems the simplest way as you can keep the scope of the data object
local to the form, but might look a bit messy) or:

ii) Create an input form which opens to accept new record details, then
updates the underlying table. (This would seem trickier as you would need to
declare the scope of the data object global, (something I don't want to do),
or preferably to refresh the recordset on the first form through an event,
such as getfocus or paint, once the input form has been unloaded? ).

In short, what is the most acceptible method for data input to a dynamic
recordset?

Thanks for your thoughts on this, Ant
Nov 22 '05 #1
1 1465
Ant,

Although ADODB is usable in dotNet is mostly used in that ADONET.

In this international dotnet Newsgroups is I thought only one person giving
really consequently answers on ADODB questions.

The newsgroup for ADODB is more.

microsoft.public.data.ado

Probably you get there your answer much quicker.

I hope this helps something

Cor

"Ant" <An*@discussions.microsoft.com>
Hello, I'm developing a program that will include a window showing current
&
previous records using a scrollable recordset. I need to add records to
the
recordset & have new records immediately available in the current record.
What is the most common way of adding new records. Is it:

i) by adding records via the same form & hence using the same recordset?
(This seems the simplest way as you can keep the scope of the data object
local to the form, but might look a bit messy) or:

ii) Create an input form which opens to accept new record details, then
updates the underlying table. (This would seem trickier as you would need
to
declare the scope of the data object global, (something I don't want to
do),
or preferably to refresh the recordset on the first form through an event,
such as getfocus or paint, once the input form has been unloaded? ).

In short, what is the most acceptible method for data input to a dynamic
recordset?

Thanks for your thoughts on this, Ant

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Roy Adams | last post: by
12 posts views Thread by CJM | last post: by
1 post views Thread by Simon Gare | last post: by
1 post views Thread by Nathan Bloomfield | last post: by
2 posts views Thread by barret bonden | last post: by
2 posts views Thread by deejayquai | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.