Re: Visual Basic/informix using ODBC

Oniel (ren1995@harriet.rencorp.com) wrote: : I have built a SQL string which has dates in it. : The dates are defined as string * 8 in VB editor : and accepted thru the Masked Edit box control : from the user. : They are in MM/DD/YYYY format or MM/DD/YY format : when included in the SQL string. : When I submit this query thru Createdynaset(SQLstring, 64) : the server(7.1) returns a error which says invalid month in date. : I think some how may be it does no get the DBDATE variable. : But it also does not seem to work with the default format : which is mm/dd/yyyy. : Could somebody help me please. : Thanks. Our experience was that you had to put it in YYYY-MM-DD. Apparently later versions of the ODBC drivers resolve this problem. cheers Scott.