EOF should work:
One_large_string=""

DO WHILE NOT EOF()
    One_large_string=One_large_string+firstemail.FirstEmail
....

Messagebox will not display the entire content of One_large_string if it is large enough.


>And how do I test for end of cursor? I want to grab all of the contents from a certain field in all of the records and append them to one large string.
>
>Here is what I have so far:
>
>LOCAL strBCC
>
>STORE SQLSTRINGCONNECT(;
>'DBQ=H:\Access\email.mdb;'+;
>'DefaultDir=H:\Access;'+;
>'Driver={Microsoft Access Driver (*.mdb)}');
>TO gnConnHandle
>= sqlexec(gnConnHandle,"SELECT FirstEmail from tblemail WHERE SendFirst = True","firstemail")
>
>SELECT firstemail
>GO TOP
>
>DO WHILE NOT EOF
>Messagebox(firstemail.FirstEmail)
>NEXT
>ENDDO
>
>
>I was pretty sure it wasn't going to like the EOF with the cursor... What can I replace that with?