How many rows affected by SQL?

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by peterlin Wed, 04 Oct 2000 00:00

#960

Author: peterlin
Date: Wed, 04 Oct 2000 00:00

4 lines
632 bytes

Hi,
When I use TQuery to delete or update record,
how can I know how many rows affected by the SQL? (just like SQL explore )
thx!

Re: How many rows affected by SQL?

#782

Author: Mark Cashman (TeamB)
Date: Wed, 04 Oct 2000 00:00

11 lines
953 bytes

Hi!

Only by doing a SELECT COUNT(*) with the same tables and other clauses
as the delete / update, prior to the delete / update.

------
Mark Cashman, TeamB C++ Builder
http://www.temporaldoorway.com/programming/index.htm
C++ Builder, JBuilder programming information
Home of The C++ Builder Programmer's Webring - Join us!
------

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads