Ray,
sorry to do this again but i forgot to mention ..
if i change the 'prepare' section as noted here .. it does work well.
Now I can modify the read, write shells to force the conversion ..
but now am really interested in why i am not getting it right to
begin with <g>
*if (SQLBindParameter(sqlStmtEnv, 2, SQL.B.INTDATE, SQL.DATE, 30, 0, date) <
SQL.SUCCESS) then stop 'date'
if (SQLBindParameter(sqlStmtEnv, 2, SQL.B.BASIC, SQL.DATE, 30, 0, date) <
SQL.SUCCESS) then stop 'date'
nbr = 1
tdate = 13598
tdate = oconv(tdate,'D4-')
date = field(tdate,'-',3) :'-': field(tdate,'-',1) :'-': field(tdate,'-',2)
sqlStatement = 'insert into testDate values (' : nbr : ',' : squote(date) : ')'
*sqlStatement = 'insert into testDate values (?,?)'
IF (SQLPrepare(sqlStmtEnv, sqlStatement) < SQL.SUCCESS) then stop 'prepare'
*nbr = 1
*tdate = 13598
*tdate = oconv(tdate,'D4-')
*date = field(tdate,'-',3) :'-': field(tdate,'-',1) :'-': field(tdate,'-',2)
Thanks again ..
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/
