David, How is it going?
I have done that .. been moving stuff around just to see what might correct the problem. According to a note from IBM .. the binding really only connects position with var name. Actual data doesn't take effect until the execute. Seemed odd to me <G>. But will try it again .. can't hurt Tuesday, March 29, 2005, 12:12:54 AM, you wrote: HDS> I noticed the difference between this example and the previous is that your HDS> "nbr" and "tdate" varaibles were set being null string values just before HDS> the SQLBindParameter. Yet this example (with no parameter markers) is force HDS> feeding the values and it is working. This suggests that you are passing HDS> empty strings/values - perhaps? Just speculating here! HDS> I suggest to you change populate the variables prior to the bind and see HDS> what happens. I've experienced similar issues with SQLBindParameter and HDS> SQLExecDirect in older BCI releases. HDS> -----Original Message----- HDS> From: [EMAIL PROTECTED] HDS> [mailto:[EMAIL PROTECTED] On Behalf Of David Tod Sigafoos HDS> Sent: Tuesday, 29 March 2005 2:49 AM HDS> To: Ray Wurlod HDS> Cc: [email protected] HDS> Subject: Re[2]: [U2] BCI and Dates to SqlServer HDS> Ray, HDS> sorry to do this again but i forgot to mention .. HDS> if i change the 'prepare' section as noted here .. it does work well. HDS> Now I can modify the read, write shells to force the conversion .. HDS> but now am really interested in why i am not getting it right to HDS> begin with <g> HDS> *if (SQLBindParameter(sqlStmtEnv, 2, SQL.B.INTDATE, SQL.DATE, 30, 0, date) < HDS> SQL.SUCCESS) then stop 'date' HDS> if (SQLBindParameter(sqlStmtEnv, 2, SQL.B.BASIC, SQL.DATE, 30, 0, date) < HDS> SQL.SUCCESS) then stop 'date' HDS> nbr = 1 HDS> tdate = 13598 HDS> tdate = oconv(tdate,'D4-') HDS> date = field(tdate,'-',3) :'-': field(tdate,'-',1) :'-': field(tdate,'-',2) HDS> sqlStatement = 'insert into testDate values (' : nbr : ',' : squote(date) : HDS> ')' HDS> *sqlStatement = 'insert into testDate values (?,?)' HDS> IF (SQLPrepare(sqlStmtEnv, sqlStatement) < SQL.SUCCESS) then stop 'prepare' HDS> *nbr = 1 HDS> *tdate = 13598 HDS> *tdate = oconv(tdate,'D4-') HDS> *date = field(tdate,'-',3) :'-': field(tdate,'-',1) :'-': field(tdate,'-',2) HDS> ------- HDS> u2-users mailing list HDS> [email protected] HDS> To unsubscribe please visit http://listserver.u2ug.org/ HDS> __________ NOD32 1.1039 (20050328) Information __________ HDS> This message was checked by NOD32 antivirus system. HDS> http://www.nod32.com -- DSig ````` David Tod Sigafoos ( O O ) _______oOOo__( )__oOOo_______ Cannot open file "C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION DATA\BATMAIL\COOKIES.TXT" ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
