Re: [V4Rev]Valentina equivalent of revDataFromQuery
On 6/16/10 3:59 AM, "Kay C Lan" wrote: > Diving into Rev + Valentina, again. > > This time around, as highly recommended by Ruslan (William Humphrey and > others) I've tried to steer clear of Rev's own DB calls and stick > exclusively with Val API calls. At his point all I'm trying to replicate is > revDataFromQuery; ie extract actual data, not a cursor. I did a search of > the Val Wiki and couldn't find anything that seemed right, so searching the > Val and Rev Lists I discovered and email from Chris Sheffield 26Feb08 > (thanks) basically pointing out that in earlier versions of Val there were: > > Cursor_GetRecord and Cursor_GetRecords > > but these had disappeared. Ruslan mentions adding them back, but as I say, I > can't find any reference searching the Val Wiki. Hi Kay, In the sources I see these methods put VCursor_GetRecord( cursorRef, [RecIndex], [fldDelimiter] ) into VAR put VCursor_GetRecords( cursorRef, [FromRec], [MaxRecords], [fldDelimiter], [recDelimiter] ) into VAR So you can try call them using this syntax. 2) API Reference of V4REV is not in WIKI, It is in separate PDF You can find this PDF on this page http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:products:adk:v4re v:v4rev -- 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] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: [V4Rev]Valentina equivalent of revDataFromQuery
On 6/16/10 3:59 AM, "Kay C Lan" wrote: > Diving into Rev + Valentina, again. > > This time around, as highly recommended by Ruslan (William Humphrey and > others) I've tried to steer clear of Rev's own DB calls and stick > exclusively with Val API calls. At his point all I'm trying to replicate is > revDataFromQuery; ie extract actual data, not a cursor. I did a search of > the Val Wiki and couldn't find anything that seemed right, so searching the > Val and Rev Lists I discovered and email from Chris Sheffield 26Feb08 > (thanks) basically pointing out that in earlier versions of Val there were: > > Cursor_GetRecord and Cursor_GetRecords > > but these had disappeared. Ruslan mentions adding them back, but as I say, I > can't find any reference searching the Val Wiki. Checking ... -- 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] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: [V4Rev]Valentina equivalent of revDataFromQuery
Thanks Bob, If it weren't for the fact that I'm a hobbyist and don't make any money from Rev, then purchasing sqlYoga might make cents. But for the want of one method, I might have to nut it out. If Rev has a single call that does it, I'm guessing the Val API can, it just appears the documentation is a little lacking. I see also that Trevor swaps between API and RevDB calls, so if I can figure out why I get 'invalid DB type', I'd be more than happy to follow the master and use the occasional RevDB call, if it saves time. Again I just need help figuring out what's wrong. Here's hoping :-) 2010/6/16 Bob Sneidar > Since runrev Can ONLY access an SQL database via the revdb API, ALL methods > are at some point doing what you need them to. > > I highly recommend sqlYoga as he has a built in function that does exactly > what you are trying to do. > > It takes a bit of getting used to, but once you see that his main objective > is to firewall you off from the actual SQL itself, it makes a lot of sense. > > Bob Sneidar > IT Manager > Calvary Chapel CM > Sent from iPhone > > > On Jun 15, 2010, at 17:59, Kay C Lan wrote: > > If this is not what I'm looking for I'm assuming someone out there has >> already invented the wheel (generic function) that takes any Cursor >> returned >> from VDatabase_SqlSelect, and does a nested repeat through each field of >> each record and returns the content either into a multi-line list or an >> array? Care to share… please :-) >> > ___ > use-revolution mailing list > use-revolution@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: [V4Rev]Valentina equivalent of revDataFromQuery
Since runrev Can ONLY access an SQL database via the revdb API, ALL methods are at some point doing what you need them to. I highly recommend sqlYoga as he has a built in function that does exactly what you are trying to do. It takes a bit of getting used to, but once you see that his main objective is to firewall you off from the actual SQL itself, it makes a lot of sense. Bob Sneidar IT Manager Calvary Chapel CM Sent from iPhone On Jun 15, 2010, at 17:59, Kay C Lan wrote: If this is not what I'm looking for I'm assuming someone out there has already invented the wheel (generic function) that takes any Cursor returned from VDatabase_SqlSelect, and does a nested repeat through each field of each record and returns the content either into a multi-line list or an array? Care to share… please :-) ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
[V4Rev]Valentina equivalent of revDataFromQuery
Diving into Rev + Valentina, again.
This time around, as highly recommended by Ruslan (William Humphrey and
others) I've tried to steer clear of Rev's own DB calls and stick
exclusively with Val API calls. At his point all I'm trying to replicate is
revDataFromQuery; ie extract actual data, not a cursor. I did a search of
the Val Wiki and couldn't find anything that seemed right, so searching the
Val and Rev Lists I discovered and email from Chris Sheffield 26Feb08
(thanks) basically pointing out that in earlier versions of Val there were:
Cursor_GetRecord and Cursor_GetRecords
but these had disappeared. Ruslan mentions adding them back, but as I say, I
can't find any reference searching the Val Wiki.
In desperation I thought I'd just lower my standard and use a Non-API call
just for this task. Then I discovered I can't do any revDB calls.
In a brand new stack I do a simple (based on Rev Dictionary Syntax):
revOpenDatabase("Valentina","",myDbPath,"","","",myMacSN,"")
and I get an error indicating that it's an invalid DB type? By searching the
list I see Trevor is using "Valentina2", same error. In the Test.rev stack
that comes with Val I see it's using "Valentina4" but still the same error.
I also notice that the majority of the tests in the Test stack aren't even
run, but that's beside the point.
So, thanks again to Chris, I did some snooping of externalFunctions of the
"home" stack, I see there are API calls for VCursor_GetRecord,
VCursor_GetRecords and VDatabase_SqlSelectRecords. Unfortunately doing a
search of the Val website for 'sqlselectrecords' has 1 hit for
VConnection_SqlSelectRecords under the NEW for V4REV but gives no detail or
syntax. Again, no hits for 'getrecord'.
Looking inside the Test.rev stack I see this:
put VDatabase_SqlSelectRecords( mDatabase, "SELECT a1 FROM T1 WHERE a1 = 1
or a1 = 2", "kServerSide", "kReadWrite",, 1,3, " ", " ", "", "" ,
"", "") into res
put VCursor_GetRecords( mcurs,1,4344," ", " " ) into res
So does this do what I'm looking for, and if so, what are the parameters
required and what is returned?
If this is not what I'm looking for I'm assuming someone out there has
already invented the wheel (generic function) that takes any Cursor returned
from VDatabase_SqlSelect, and does a nested repeat through each field of
each record and returns the content either into a multi-line list or an
array? Care to share… please :-)
Help appreciated.
Val 4.6, Rev Studio 4.0 Bld 950, OS X 10.6.3, MBPro
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
