>When I issue a sqlexec() with a select statement like:
>
>select * from Contact1
>
>It brings over all of the fields and all of the records, even the records marked for deletion. Is there any way to prevent the deleted records from being brought over?
>
>DJ :o)
Select * from mytable where this=that and not deleted()....
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright