tigreeuropeo
IS-IT--Management
I'm using dynasets in VB with OO4O.
I have no problems using them, but I don't know how to 'destroy' a dynaset and create it again.
This is the situation:
....
do
artNumber = NextArtToProcess() ' some function ---
SQLsent = "select art, qty from stock " & _
" where art = " & artNumber & " for update"
oracledb.createdynaset(SQLsent, 0&)
....do some processing ....
oracledb.committrans
loop until NoMoreArticles()
On the second loop I execute "odb.createdynaset(..)" there's an error.
I need to destroy the dynaset so I can create it again on the next loop.
Would you help me?.
Thanks in advance.
I have no problems using them, but I don't know how to 'destroy' a dynaset and create it again.
This is the situation:
....
do
artNumber = NextArtToProcess() ' some function ---
SQLsent = "select art, qty from stock " & _
" where art = " & artNumber & " for update"
oracledb.createdynaset(SQLsent, 0&)
....do some processing ....
oracledb.committrans
loop until NoMoreArticles()
On the second loop I execute "odb.createdynaset(..)" there's an error.
I need to destroy the dynaset so I can create it again on the next loop.
Would you help me?.
Thanks in advance.