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
			
			
									
									
						multiple deletes
Moderators: Moderators, Tech Support
Re: multiple deletes
I don't believe so as (I believe) the DB manager was never intended to do repetitive set of SQL commands in that way.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
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.
						Using PC+ since 1999.