-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

if revNumberOfRecords(q) > 0 then
  revMoveToFirstRecord q
  put revDatabaseColumnNamed(q, "City") into field "myCity"
  put revDatabaseColumnNamed(q, "State") into field "myState"
  put revDatabaseColumnNamed(q, "Zip") into field "myZip"
else
  answer "no record"
end if


On Dec 30, 2004, at 10:58 AM, Bill wrote:

Can you show an example?


On 12/30/04 11:24 AM, "Frank D. Engel, Jr." <[EMAIL PROTECTED]> wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can also use the revNumberOfRecords function to this end.

On Dec 29, 2004, at 1:59 PM, Trevor DeVore wrote:


On Dec 29, 2004, at 10:02 AM, docmann wrote:

You folks are fantastic! It works exactly as intended now. :)

Geesh, I still don't know how I got so far off track in attempting
this <shaking and pounding head on desk vigorously> and clearly need
to revisit the documentation. :(


On a side note, I intentionally entered data that I knew did not
exist, just to see what would happen and got a "revdberr,invalid
column number" message. Is there a proper way to test and/or trap
these types of errors when a record doesn't exist?

Again, thank you very VERY much!

Try this:

if revCurrentRecordIsLast(q) = false then
revMoveToFirstRecord q
put revDatabaseColumnNamed(q, "City") into field "myCity"
put revDatabaseColumnNamed(q, "State") into field "myState"
put revDatabaseColumnNamed(q, "Zip") into field "myZip"
else
answer "no record"
end if


-- Trevor DeVore Blue Mango Multimedia [EMAIL PROTECTED]

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


- -----------------------------------------------------------
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.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB1B2s7aqtWrR9cZoRAgr5AJ9KXCrLyQblp4TrjSAWqo0caLpZuACfQ+t3
4y6Q1fH8smVqqrnoJrfQgNE=
=wo6c
-----END PGP SIGNATURE-----



___________________________________________________________
$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



| | | )_) )_) )_) )___))___))___)\ )____)____)_____)\\ _____|____|____|____\\\__ -------\ /--------- http://www.bluewatermaritime.com ^^^^^ ^^^^^^^^^^^^^^^^^^^^^ ^^^^ ^^^^ ^^^ ^^ ^^^^ ^^^

24 hour cell: (787) 378-6190
fax: (787) 809-8426

Blue Water Maritime
P.O. Box 91
Puerto Real, PR 00740



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


- -----------------------------------------------------------
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.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)


iD8DBQFB1Cbx7aqtWrR9cZoRAk/mAJ9WMpSX8uSaZZjF5t3Y/ZHDlZEKCgCeNWlb
Lb0aLdGCF20T4ysaYXqD4C0=
=TVtN
-----END PGP SIGNATURE-----



___________________________________________________________
$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