Re: Visual-Basic Pass thru SQL

In article <29824609wnr_at_bhcnt.demon.co.uk>, <peter_at_bhcnt.demon.co.uk> writes:
> I hope this is the right place to ask this.
>
> My colleague is trying to send an SQL statement through to Oracle (v6)
> from his VB application to update a row.
>
> This returns an error.
>
> It appears that if the SQL is returning some type of output it is ok
> (ie any 'select' statements), but fails if nothing is returned.
>
> We are not sure if this is a to do with his Oracle account or his VB
> application.
>
> Has anyone any ideas ?
>
> BTW, If this is in the wrong group please point me in the right
 direction.
>
> Thanks in Advance.
>

        It would be easier to tell you the problem if you could post the SQL statement being used in the VB app. If it's a select statement then it should look similar to the following.

dim ds as dynaset
dim db as database
'your connect to the database goes here

DS = DB.CreateDynaset(sql$,64)

If you do this (use 64 to use DB_SQLPassthrough) the dynaset is read only but the retrieve is much faster. Received on Mon Aug 08 1994 - 22:22:36 CEST