Until today I had been using V4RB version 1.9.6. I could keep more than one
cursor open at the same time.
This morning I loaded V4RB.rbx (no version number given, but I think it is
1.10.x; the original folder's namewas:Valentina_RB_5.zip, and the plugin itself
was created on 2004 Dec), and after replacing ValentinaUtilities and updating
some SQLselect (adding when necessary the new parameters) I tested my app.
While mostly everything seems to work all right (adding, deleting, finding
records etc), I found that I cant anymore create a new cursor while another
cursor is open. For instance:
Suppose I'm working with mainCur (mainCur is a property of the window, called
with: mainCur = myDatabase.SQLselect(mySQL, kV_Server, kV_ReadWrite,
kV_Random)), adding/modifing records. I now want to print some records with
this code in the action event of a pushButton:
dim printCur as Vcursor
printCur = myDatabase.SQLselect("select vField1,vField2,vfield3 from myData
order by vField1,vfield2,vField3")
if printCur <> nil then
//do something
else
msgBox "printCur is nil"
end if
What I see is that printCur is always nil.
To have it to work I have first to nil mainCur, as in:
dim printCur as Vcursor
updateRecs
mainCur = nil
myDatabase.Flush
printCur = myDatabase.SQLselect("select vField1,vField2,vfield3 from myData
order by vField1,vfield2,vField3")
if printCur <> nil then
//do something, and at the end of the job, open again mainCur
else
msgBox "printCur is nil"
end if
I dont know I to manage this situation in order to be able to keep the previous
Cursor 'alive', and not to be bound to nil it and then open it again when the
print-process has come to an end.
RB 5.5.5 Mac OS 10.4
RB 5.5.5 Mac OS 9.2
Any suggestion welcome, thanks,
--
Carlo
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
