HELP: SQLMENU 5.0 menu import missing items

From: SIMBL <simbl_at_singnet.com.sg>
Date: 10 Jul 1998 10:13:32 GMT
Message-ID: <01bdabeb$d9c9fec0$a07015a5@pc160>

Can someone please help?

I am using Oracle7.3 with NLS format DD-MM-YYYY, however SQLMENU50 can only use DD-MMM-YY format. Thus, when I export my menu from Oracle 7.1 database with NLS Date DD-MMM-YY and import it into the new environment Oracle 7.3 with DD-MM-YYYY NLS format, I cannot get all the menu I currently have.

I amended the date format so that it can be imported, however it seems that the all sql commands in the menu cannot be imported. Those menu items are missing.
In the new environment, the menu cannot be saved either.

Should I amend the sql statements for menu exported and then import it but how does SQLMENU50 handle sql statements with NLS format DD-MM-YYYY?

Thanks for helping .....

Regards,
Shinteia Received on Fri Jul 10 1998 - 05:13:32 CDT