Hello Sir, How can I preserve the checkbox in an Interactive Report with Select All option (eg, Report on EMP table). Once selected then need to load the selected rows into a new table (EMP_NEW). Your help and support would be appreciated.
Discy Latest Questions
Hello Vinish Sir, I need your little help if possible. I have 2 tables (1) CONTACT_TYPES table as below: Contact_Type_Id Contact_Type_Description --------------- ------------------------ 1 Alternate Contact Number 2 Email 3 Fax 4 Website 5 Twitter 6 Facebook 7 Linkedin 8 Preferred Contact Number (2) PERSON_CONTACT_DETS table as below: Person_Contact_Det_Id Person_Id Contact_Type_Id --------------------- -------- --------------- 1 11111 ...
Hello Sir, I have a requirement to create a Wizard style form in Apex. It is exactly the same as the Order Processing in Sample Database Application. The change I need is, instead of using APEX_COLLECTION method for the Order Items I need to use Interactive Grid and save the data at the end in the Confirmation page. So process would be something like Customer Details -> Order Items -> Order Summary -> Confirm Order. Customer Details = to enter new customer details (Cust_Id is PK - auto generate on Seq) Order Items = to enter order details (Order_Id is PK, Order_Item_Id is PK - auto generated on Seq) Order Summary = to view/review current order Order Confirm = to confirm the current order and To Save data in Customers and Orders/Orders_Details tables respectively. Would it be possible for you to guide me and provide me the steps ? Your help is greatly appreciated.
Hello Apex Expert, In Apex, I have Master Detail form where Detail part is created using Interactive Grid. This is one go form i.e. entering master and detail record on the same form. I do not have Master Report. So when I click the Save button I want to save the data in Master table as well as in Detail table. I have tried manual PL/SQL Code process but when trying to enter the data in Detail table it raises an error saying "Cannot enter NULL value in Master_Id". I have no idea how can I capture the Master_Id for manual IG Process? Your help would be greatly appreciated. Kind Regards,
Good Afternoon, How to create an Interactive Grid on a table with Checkbox column for Y or N? For example, we have a column in a table called Competed and would like to show this as a Checkbox in IG and would like to save as Y or N in the table. Your help and support would be appreciated. Kind Regards