|
|
|
|
Re: How to execute Query 2 if Query 1 doesnt reterive anything [message #484905 is a reply to message #484863] |
Fri, 03 December 2010 12:44 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
manikanth wrote on Fri, 03 December 2010 12:59
if query 1 count = 0 then
execute query 2
end if
Once again: if queries aren't linked, query 2 will be executed regardless of whether query 1 fetches anything or nothing.
Your IF-THEN-ELSE misses "else": what do you want to do "if query 1 count <> 0"?
|
|
|