I have a date in YYMD format on my table. When I try to comp...

[Manoj Chaurasia]

Tom

What version of SQL Server are you connecting to and what type of connection from WebFOCUS are you using OLE/DB or ODBC

[NYCBabak .]

Does the request work, if you remove this WHERE test and replace it with WHERE READLIMIT EQ 10

Are you using the same userid in 8207 as you were in the 7705

Can you turn on SQL Trace and SET &ECHO=ALL; to see what FOCUS and SQL code is generated

Does the SQL in the trace run in SQL Server mgmt studio

What kind of object is PUBLIC_EVENTCASE

[Tom Evans 2]

This ended up being an issue with the . acx file in the metadata. I recreated the synonym in 8.2.07 and the procedure worked. The error message it threw referencing the date took me down the wrong path. Partly my error though for not checking the metadata.

[Tom Evans 2]

I have a date in YYMD format on my table. When I try to compare it to a parameterized date in 8.2.07 it errors out. This compare worked fine in 7.705. We are upgrading to 8.2.07 and this code no longer works

WHERE ( EVENT_DATE EQ &tbdtyymda10.(|FORMAT=YYMD).tbdtyymda10.QUOTEDSTRING );

WebFOCUS Error Executing body { font-family: Tahoma, Geneva, sans-serif; color: #464C57; margin: 0; text-align: center; } .errorContainer { display: block; flex-direction: column; justify-items: center; justify-content: flex-start; align-items: center; max-width: 600px; margin: auto; } .errorTitle { font-size: 20px; display: block; margin: 30px 20px 0 } .errorMain { font-size: 18px; display: block; margin: 30px 20px 0 } .errorMore { font-size: 14px; text-align: left } .errorMsg { font-size: 14px } .errorList { font-size: 14px } .errorDetail { font-size: 14px; display: block; margin: 0 20px 10px; flex-direction: column; text-align: left } pre { text-align: left; color: #666; font-size: 12px; font-weight: normal; margin: 5px 0 10px } pre b { font-weight: normal; } .showDetail { font-size: 14px; margin-top:10px } a:link, a:visited, a:active { color: #337ab7; text-decoration: none } a:hover { text-decoration: underline } h5 { text-align: left; margin: 10px 0 0; }

(FOC1400) SQLCODE IS -22 (HEX: FFFFFFEA) : [s1000] [TOD][ODBC][GENESIS](pos: 433 'ENT_DATE" = ^DATE(2020-0) : - syntax error L (FOC1405) SQL PREPARE ERROR. (FOC1400) SQLCODE IS 1400 (HEX: 00000578) (FOC1500) : SQLCODE IS -22 (HEX: FFFFFFEA) L (FOC1406) SQL OPEN CURSOR ERROR. : PUBLIC_EVENTCASE