Re[2]: [U2] BCI and Dates to SqlServer
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 (-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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[2]: [U2] BCI and Dates to SqlServer
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
(-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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] BCI and Dates to SqlServer
David,
I'm on the road (as usual), doing non-UniVerse stuff. The earliest I will get
to take a look at this is next weekend. Since you have a workaround, I guess
the urgency's gone. Have you contacted IBM support? (And what version of SQL
Server are you using?)
Regards,
Ray
- Original Message -
From: David Tod Sigafoos [EMAIL PROTECTED]
To: Ray Wurlod [EMAIL PROTECTED]
Subject: Re[2]: [U2] BCI and Dates to SqlServer
Date: Mon, 28 Mar 2005 08:49:27 -0800
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 (-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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: Re[2]: [U2] BCI and Dates to SqlServer
Can you re-send the sample code? I seem to have deleted it already. Thanks, Ray --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: Printronix - The Strife Is O'er
Regardsing the problem with connecting a legacy Printronix P300 printer to an HP JetDirect print server and HP-Ux... Printronix (paid) tech support had a few config ideas. Among the advanced JetDirect properties, it was setting the print mode to Centronics and handshaking to nACK. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XSL dialect
Hi All, I know U2 uses the Apache Xerces parser for XML, but from the docs I read at www.apache.org, this does not seem to include an XSL parser. Does anyone know which libraries U2 (UV 10.1) uses to process XSL when using the XDOMTransform function? thanks, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
