NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Gordon Holfelder on September 07, 2010, 10:18:38 AM

Title: Open files embed point in browse
Post by: Gordon Holfelder on September 07, 2010, 10:18:38 AM

Hi All-

I have a procedure using the NetWebBrowse template. It appears that the Open/CloseFiles routines are never called (there are calls to Open/CloseFilesB routines.

This makes it difficult to activate/deactivate SQL tracing...

This relates to the problem I was trying to determine. When I make a date field the "Default" and "Descending" I get an error "90" unable to convert 0z to a datestamp. If I removed the indicated options, the browse works fine. I'm using the ODBC drivers to connect to a Sybase database.

So I'm looking for help on the above error.

Thanks in advance!
Gordon - PR29

BTW, I'll try PR31

Title: Re: Open files embed point in browse
Post by: Gordon Holfelder on September 07, 2010, 10:54:21 AM

So here is the SQL log:

09B4H(3) 12:51:17.053 Preparing Statement 06EC1C0H : SELECT PRtsh.PRTIMEID,PRtsh.LISTID,PRtsh.PRPERIODID,PRtsh.BANKACTIVITYID,PRtsh.ISVOID,PRtsh.EARNINGAMOUNT,PRtsh.TAXAMOUNT,PRtsh.DEDUCTIONAMOUNT,PRtsh.NetAmount,PRtsp.PRPERIODID,PRtsp.TYPEID,PRtsp.PERIODSTATUS,PRtsp.ENDDATE,PRtsp.CHECKDATE,APbac.BANKACTIVITYID,APbac.CREATEID,APbac.CREATEDATE,APbac.CREATETIME,APbac.CHANGEID,APbac.CHANGEDATE,APbac.CHANGETIME,APbac.BANKID,APbac.LISTID,APbac.PAYID,APbac.VOIDACTIVITYID,APbac.CMACTIVITYID,APbac.ALLOCATIONACTIVITYID,APbac.IMPORTBATCHID,APbac.TYPEID,APbac."ORDER",APbac.ACTIVITYDATE,APbac.RECONCILEGROUP,APbac.ACTIVITYTYPE,APbac."Reference",APbac.RECONCILED,APbac.MARKED,APbac.VOIDED,APbac.PRINTED,APbac.EFT,APbac.POSITIVEPAY,APbac.AUTOMATIC,APbac.PAYMENTORDEBIT,APbac.COIN,APbac.CASH,APbac.CHECKS,APbac.DEPOSITORCREDIT,APbac.AMOUNT FROM  {oj PRtsh PRtsh LEFT OUTER JOIN PRtsp PRtsp ON PRtsh.PRPERIODID=PRtsp.PRPERIODID LEFT OUTER JOIN APbac APbac ON PRtsh.BANKACTIVITYID=APbac.BANKACTIVITYID }  WHERE ( PRtsh."ListID"=20 AND PRtsh."BankActivityID" IS NOT NULL AND APbac."VoidActivityID" IS NULL AND  PRtsp.CHECKDATE <= '0z' )  ORDER BY PRtsp.CHECKDATE DESC, PRtsh.PRTIMEID
09B4H(3) 12:51:17.054 Error Occurred: 07006 [Sybase][ODBC Driver][Adaptive Server Anywhere]Cannot convert 0z to a timestamp

Thanks,
Gordon