Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Tom Evans 2

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...