Incorrect response from revNumberOfRecords ???
Frank Engel
fde101 at fjrhome.net
Wed Nov 10 14:39:34 EST 2004
I am using RevDB to execute queries on a PostgreSQL database. One of
the queries (in a variable called qt) results in a result set such that
revNumberOfRecords returns 0 in one of my programs. This is highly
undesirable, since the same exact query run against the same database
with another Rev stack results in revNumberOfRecords returning 1.
Any clues? Fairly straight SQL; no currval, or anything else to throw
off the query as being session-specific or anything...
Oh, and it works correctly in psql, too.
BTW, changing the code to attempt access to a column by number anyway
(using revDatabaseColumnNumbered(q, 1)) results in an "invalid column
number" error.
This behavior is fairly consistent within this one stack, but I can't
figure out why.
-----------------------------------------------------------
Frank D. Engel, Jr. <fde101 at fjrhome.net>
$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com
More information about the use-livecode
mailing list