more SQL problems

[Trevor DeVore]

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