gussifinknottle
Programmer
I have a script that drops a number of tables (after searching the system tables for their existence).
Depending on a select criteria (e.g. for a particular client, whose nameis specified), I may recreate and populate the above dropped tables.
IF (SELECT client_name = 'abc')
BEGIN
CREATE <table_customer>
INSERT INTO <table_customer> VALUES
END
However if the select criteria is not met
I get a system message stating
Could not find table table_customer. Will try to resolve this table name later.
How can I avoid getting this message?
Depending on a select criteria (e.g. for a particular client, whose nameis specified), I may recreate and populate the above dropped tables.
IF (SELECT client_name = 'abc')
BEGIN
CREATE <table_customer>
INSERT INTO <table_customer> VALUES
END
However if the select criteria is not met
I get a system message stating
Could not find table table_customer. Will try to resolve this table name later.
How can I avoid getting this message?