Re: OO4O problem

I got it!!!!!
I must CreateDynaset specifying ORATYPE_ORAMODE option instead of 0H (default Microsoft mode).
...
Every time I move a parameter from MS to Oracle, it works. It is quite incredible.
"Tronak" <jmoreno_at_hag.es> escribió en el mensaje news:pBxn6.8598$F35.315865_at_telenews.teleline.es...
> Hi all,
>
> I am trying to execute the following code:
> Assumming that_
>
> orstAction is a OraDynaset
> dbMain is a OraDatabase properly opened from a OraSession with no
> errors.
>
>
>
> If orstAction Is Nothing Then
> Set orstAction = dbMain.CreateDynaset("SELECT E.ROWID,E.* FROM
> EMBARGO E", 0&)
> Else
> orstAction.Refresh
> End If
>
> With orstAction
> .AddNew
> !<field>=value
> !<field>=value
> .Update
> End With
>
>
> In UPDATE method VB5 returns ORA-00928 Error: missing SELECT keyword.
>
> Does anyone can help me?
>
>
Received on Mon Mar 05 2001 - 12:58:49 CET