multiple deletes

Got a question or comment about PowerChurch that doesn't belong anywhere else? Why not post it here!?

Moderators: Moderators, Tech Support

Post Reply
dps1943
Posts: 1
Joined: Sun Jun 19, 2011 1:13 am

multiple deletes

Post by dps1943 »

Is is possible to do a group of commands at one time in DB manager? For example, if I copy/paste the text below to the command line, only the first line executes. Is there a way to get all four (or more) to execute?

delete from sk.dbf where mail_no=8 and pers_no=5
delete from sk.dbf where mail_no=25 and pers_no=3
delete from sk.dbf where mail_no=41 and pers_no=3
delete from sk.dbf where mail_no=53 and pers_no=1

NeilZ
Posts: 10466
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: multiple deletes

Post by NeilZ »

dps1943 wrote:Is is possible to do a group of commands at one time in DB manager? For example, if I copy/paste the text below to the command line, only the first line executes. Is there a way to get all four (or more) to execute?

delete from sk.dbf where mail_no=8 and pers_no=5
delete from sk.dbf where mail_no=25 and pers_no=3
delete from sk.dbf where mail_no=41 and pers_no=3
delete from sk.dbf where mail_no=53 and pers_no=1
I don't believe so as (I believe) the DB manager was never intended to do repetitive set of SQL commands in that way.

Standard Disclaimer
I am a user, not a Powerchurch developer. I am a programmer who used SQL in his everyday work, and am quite familiar with it. The programmers at Powerchurch do not recommend use of the DB manager by users outside of guidance by Powerchurch technicians as doing so bypasses the referential data integrity checks of the Powerchurch software.
Neil Zampella

Using PC+ since 1999.

Post Reply