drifter
5th July 2004, 16:23
hi all
is there a way to bypass errors wen doing dynamic sql fetching. Session breaks up because one table doesn't exist but the table is in tools tables. Is it possible to intercept this message and continue without the program breaking up?
just to add that I am trying to intercept an error that a table does not exist when fetching with dynamic sql. it is weird that sql.parse function goes ok, no error. but when I do a fetch then it breaks saying error 506 table does not exist.
thanks
d.
is there a way to bypass errors wen doing dynamic sql fetching. Session breaks up because one table doesn't exist but the table is in tools tables. Is it possible to intercept this message and continue without the program breaking up?
just to add that I am trying to intercept an error that a table does not exist when fetching with dynamic sql. it is weird that sql.parse function goes ok, no error. but when I do a fetch then it breaks saying error 506 table does not exist.
thanks
d.