Manu

Does it work if you submit it as a NATIVE command:

{NATIVE SELECT ... }

NATIVE passes the command directly throught to the UV SQL processor
(bypasses ODBC processing). Generally quicker and can give access to more
options. The braces are a required part of the syntax. 

Brian 

> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of Manu 
> Fernandes
> Sent: 18 June 2006 15:35
> To: [email protected]
> Subject: Re: Re:[U2] [UV][uvodbc]where date_field <= (subqueries)
> 
> not functional with odbc,
> 
> manu
> ----- Original Message -----
> From: "Ray Wurlod" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Saturday, June 17, 2006 11:22 PM
> Subject: Re:[U2] [UV][uvodbc]where date_field <= (subqueries)
> 
> 
> > UniVerse SQL has constants CURRENT_DATE and CURRENT_TIME; 
> you ought to 
> > have used CURRENT_DATE rather than DATE().
> > -------
> > u2-users mailing list
> > [email protected]
> > To unsubscribe please visit http://listserver.u2ug.org/ 
> -------
> u2-users mailing list
> [email protected]
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to