V4REV Copy Cursor to New Table
Marek Niesiobedzki
nm at studionm.pl
Sun Jun 10 02:36:41 CDT 2012
In the Valentina Viki is described method Valentina.CopyCursorToNewTable() with example:
' Let db1 is a remote database under some Valentina Server.
VCursor curs = db1.SqlSelect(
"SELECT * FROM tblPerson WHERE fldAge = 25 and fldIsMarried = false",
kClientSide, kReadOnly )
' Create RAM based TMP database on client side:
VDatabase pLocalRamDB = new VDatabase( kRAM )
pLocalRamDb.Create( "DummyNameForRamDB" )
VTable pTblNotMarried25 = Valentina.CopyCursorToNewTable( curs, pLocalRamDB, "tblNotMarried25" )
' We can destroy cursor now, if it will not be used anymore.
curs = nil
How to use it in V4REV? Is it possible to use it in SQL way?
Marek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120610/c96acf6b/attachment.html>
More information about the Valentina
mailing list