Hi REAL team,
One user have point on next issue.
* in function f1 he create
ValentinaTestDB = New VRBDatbase
ValentinaTestDB.DatabaseFile = ValentinaTestDatabaseFile
* in function f2 he open existed database and do SqlSelct.
this function is called by button click.
if ValentinaTestDB.Connect then
ValentinaTestRS = ValentinaTestDB.SQLSelect("SELECT * from Customers")
end if
ValentinaTestDB.close
** FIRST TIME this works fine.
But on SECOND and next calls, ValentinaTestDB.SQLSelect()
return NULL always.
In fact by LOG and debugger I see that REALbasic even do not call
directSQLSelect() method of REALdbEngineDefinition.
** This strange behavior happens after close() call.
I have even totally comment our code of closeDB() method,
I.e. It is empty, and simply is called by RBDB Engine,
and this is already enough to break things:
after db.connect() RBDB engine do not call SqlSelect() method.
It looks like RB think that this db is in closed state.
If change f2() function to kill ValentinaTestDB and each time create a new
one, then it works.
** Aha, and what is interesting that REAL SQL works for f2() code.
This sounds to me only as something NOT DOCUMENTED function call
which must be made during db.open() or something other secret action.
** Anybody from REAL can check your own code and let us know how to resolve
this problem?
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
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>
