more SQL problems
Trevor DeVore
lists at mangomultimedia.com
Wed Dec 29 13:59:20 EST 2004
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
More information about the use-livecode
mailing list