Hi Mark,
Thank you for your reply. Our application is developed by an out-source, they customized the EGL. the text box, label, Exception, etc, are all rewriten, but no document released. the sqlreord too. Eventually I fixed it.
Function VHCL02CQ_GETMODIFIED ()
XDCOMMON.USQLREC = "VHCL02C@BRT_MODIFIED";
try
//open VHCL02CQ_GETMODIFIED_RSI01
get VHCL02C@BRT_MODIFIED
with #sql{
select MODIFIED
from MRSVEH.MRS_VEH_FIELDHIST T1
where T1.CAR_NO = :CAR_NO and to_char(T1.CHANGEDATE, 'yyyy-mm-dd hh24:mi:ss')< :DATETIMEINSRV and rownum=1
order by CHANGEDATE desc
}
into MODIFIED;
//for VHCL02C@BRT_MODIFIED;
end
end
Sincerely,
Eric
------------------------------
Eric Zuo
------------------------------
Original Message:
Sent: Fri March 22, 2024 08:07 AM
From: Mark Hall
Subject: Cannot Access a new database table
Hi Eric,
Good afternoon, I would advise to create a support ticket wherever possible where it involves application errors so that my support team can investigate fully, join you in a web session etc.
However I took a quick look at your code and I do not see the CHANGEDATE column defined within your record entry ie:
Record VHCL02C@BRT_MODIFIED type sqlRecord
{ tableNames = [ [ "MRS_VEH_FIELDHIST", "T1" ] ] }
3 CAR_NO char(4) { column = "T1.CAR_NO", isSQLNullable = yes };
3 MODIFIED char(1) { column = "T1.MODIFIED", isSQLNullable = yes };
3 DATETIMEINSRV char(19) { column = "DATETIMEINSRV", isSQLNullable = yes };
end
You can manually add it or use our SQL Retrieve option which will automatically add your columns to the table definition ie
Record VHCL02C@BRT_MODIFIED type sqlRecord
{ tableNames = [ [ "MRS_VEH_FIELDHIST", "T1" ] ] }
Right click -> SQL Record -> Retrieve SQL
end
Hopefully that helps you resolve your error, if not once again I recommend creating a ticket where I would be happy to join you in a web session to walk through it.
Thanks and Regards
Mark
Mark Hall
HCL Technologies
RBD L2 Support
------------------------------
Mark Hall
Original Message:
Sent: Thu March 21, 2024 07:24 PM
From: Eric Zuo
Subject: Cannot Access a new database table
Hello Experts,
I have DBA created a new Oracle table MRS_VEH_FIELDHIST (see attachment new_table_MRS_VEH_FIELDHIST.png). it is the first new table since this application is in service.
but this table is not accessible in the EGL program. the error is in the attachment Tomcat_output_Error.docx,
EGL0504E OPEN: ORA-00942: table or view does not exist
[sqlstate:42000][sqlcode:942]
The schema mrsveh is the default schema. The EGL program is in VHCL02C.docx, please check the function at line Function VHCL02CQ_GETMODIFIED (),
in this file I have sysLib.writeStdout statements to track the process. it is the only way to debug. application is developed by a contractor, the debug is not available.
Could you help teach me why the new table is not accessible? Is there a file hard copied the data tables to be used? but I search, cannot find it.
Thanks in advance,
Eric
------------------------------
Eric Zuo
------------------------------