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.  <[EMAIL PROTECTED]>

$ 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

_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to