Empty recordset
-
Not sure how to word this, or maybe my brain just isn't working today: I need to add records to a table. I know how to do this if I SELECT a set of data prior to adding a new record, but I would like to do it without having to do a SELECT first. Or, how do I open an empty recordset for a table? I am trying to avoid the delay of SELECT searching a large table only to come up empty. Apologies if this doesn't make sense or is ridiculously simple (see line 1). >>>-----> MikeO
-
Not sure how to word this, or maybe my brain just isn't working today: I need to add records to a table. I know how to do this if I SELECT a set of data prior to adding a new record, but I would like to do it without having to do a SELECT first. Or, how do I open an empty recordset for a table? I am trying to avoid the delay of SELECT searching a large table only to come up empty. Apologies if this doesn't make sense or is ridiculously simple (see line 1). >>>-----> MikeO
Ok, brain kicked into gear. SELECT TOP 0 * FROM tablename >>>-----> MikeO
-
Not sure how to word this, or maybe my brain just isn't working today: I need to add records to a table. I know how to do this if I SELECT a set of data prior to adding a new record, but I would like to do it without having to do a SELECT first. Or, how do I open an empty recordset for a table? I am trying to avoid the delay of SELECT searching a large table only to come up empty. Apologies if this doesn't make sense or is ridiculously simple (see line 1). >>>-----> MikeO
select * from tablename where 1=2