Page 1 of 1
multiple deletes
Posted: Sun Jun 19, 2011 1:20 am
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
Re: multiple deletes
Posted: Sun Jun 19, 2011 3:00 pm
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.