insert/update/select in one query, but don't show the record count

insert/update/select in one query, but don't show the record count

Post by T.S.Ne » Fri, 14 Jun 2002 18:47:08

there is insert/update/select in one query, which runs at backend. but
while i take it in recordset it do not show the recordcount as well as

........... multiple statement in one query, must have some other
technique to take result in result set...............

T.S. Negi


1. Insert query results don't show until I reopen the database

Hello, all !

I 've got the following problem. I use DAO classes and I have an insert
query ( a query that insert records in the table,based on values,user
enters). When I call Execute on this query, values are succesfully added to
the table, but if I right after that open that table and begin to retrieve
it's records, one by one, I realize,that the newly added record is not
there. If I close the database and open it again,the record is there.
What should I call besides CDaoQueryDef's Execute to make records visible
right after inserting?



2. 'Freezing' a database

3. Update Trigger - Updates don't show up in pane view

4. export error

5. Updating or Inserting a record in one query

6. changing sa password on SQL 6.5 - how ?

7. Parallel SQL and Access back ends record counts don't match

8. Finding records in one table that don't have a match in another

9. SP1 for sql 7.0 don't solve the UPDATE() Bugs in Insert Triggers

10. need a query to return records which don't exist

11. Record count from different queries in one common way

12. forming ratios of count()'s with one query