Ray,
if you get a chance could you please look at the sample code I sent.
I can not find any errors in it and yet the dates do not work.
According to the manual ..
If you use SQL.B.INTDATE, the SQL Client Interface assumes the program
variable holds a date in UniVerse internal date format and uses the
DATEFORM conversion string to convert the internal date to an external
format as required by the data source.
As you can see from the sample code I sent last week I am using
SQL.B.INTDATE with SQL.DATE which should force the internal date to
the correct format. My test code sets 'date = 13598' which should be
converted to 24Mar05.
I have tried to mix and match this .. but still have no success.
Any help will be appreciated.
thanks
Thursday, March 24, 2005, 1:52:39 PM, you wrote:
RW> BCI mimics the ODBC API, so dates are expected to be in ODBC format
(YYYY-MM-DD).
RW> Using the constant SQL.B.DATE in SQLBindParameter() or
RW> SQLBindColumn() causes an implicit conversion to occur, so that
RW> you get internal format out of a SELECT, and must supply internal
RW> format in bound variables to an INSERT or UPDATE.
--
DSig `````
David Tod Sigafoos ( O O )
_______oOOo__( )__oOOo_______
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
