revNumberOfRecords function for avoiding no record found errors

[Bill]

Can you show an example?


On 12/30/04 11:24 AM, "Frank D. Engel, Jr." <fde101 at fjrhome.net> 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
>> trevor at mangomultimedia.com
>> 
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
>> 
> - -----------------------------------------------------------
> 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.
> $
> -----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
> use-revolution at lists.runrev.com
> 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