revNumberOfRecords function for avoiding no record found errors

[Frank D. Engel, Jr.]

-----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." <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
>
>
>
> _______________________________________________
> 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)

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