Cursor Loop Problem
ngacDec 10 2008 — edited Dec 12 2008Hi i currently have in place a cursor to loop and populate things in my form.
like so (sql not important at min)
CURSOR PopulateWithData IS
select * from tables;
BEGIN
OPEN PopulateWithData;
FETCH PopulateWithData INTO vName, vDate, nNetValue, nGrossValue;
while (PopulateWithData%FOUND) LOOP
What i want to do though is allow user to changee sql for cursor so i want this cursor to work from a column in a database
any idea how i can acheive this?
i created a funtion to hold sql and then tried
CURSOR PopulateGraphWithData IS
fun_get_code(1);
but this doesnt work as it expects a select statement.