more SQL problems

[Frank D. Engel, Jr.]

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