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