Hello,As a fresh SQL user, I'm having trouble implementing a certain functionality in IFSAPP 10. I'm trying to add a PL/SQL block to the user menu (On customer order lines) that will add a record in a table I've created. Currently, I'm using a simple code that works by adding a record with the appropriate key, but I'm struggling to allow the user to input additional data such as comments or planned date. I've also written a version of the code that requires entering all the data manually. Unfortunately, I can't seem to integrate them. In the reports I've created, I use '&' to allow for manual input of values. While running report user gets pop-up window with required fields. However, this method doesn't seem to work here.DECLARE now_ DATE := TRUNC(SYSDATE);-- planned_ DATE := TRUNC(&Data_wykonania); user_id_ VARCHAR2(30) := NULL; note_ VARCHAR2(32000) := '&Additional_Data'; -- Prompt user for additional
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
