Just wondering, but do you check to see if you actually made a connection? What if sqlHandle comes back as a non-valid value?

Steve

>Dear All,
>
>I am trying to delete record from oracle using VFP with sql pass through command
>
>1. sqlHandle=SQLCONNECT('connect1','user1','password1')
> =SQLEXEC(sqlHandle,"DELETE FROM p_resources WHERE pCode=('STZ234')")
> but it always fail because VFP is freeze...why?
>
>2. Can anybody explain what we can and what we can't do in using SQL pass
> through command.
>
>Tia,
>Andreas.