on 11-10-2006 1:46 PM
Using a JDBC system to an Oracle DB I am writing SQL to do inserts. This works fine by writing the insert statement in the "SQL_STATEMENT" field found by clicking on the line between the input form and the inpurt port of the data service (db table):
"insert into felles.vc_test (name, sg, user_id) values ('" &@NAME& "', " &@SG& ", '" &@USER_ID& "')"
Now I also want the user to see that the insert was successful. I am thinking either to give the user a pop up message showing the data that was inserted, or to automatically update an output table triggered by the submit action on the insert form.
Dragging an output table from the data service's output port does not work by default. I get an "application error !Null".
How do I do this?
Henning
Hi
I have the same problem but I only need to do an update statement. The updates goes to the db (Oracle) just fine. At this point I could even live without the confirmation but I can't seem to stop the Null message.
Anyone have any ideas?
Thanks
Mark Chadwick
CSA Group
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The easiest way I can think of to do this is use a stored procedure that has output messaging. Then if you connect via Portal JDBC instead of BI JDBC, you can access stored procedures for this. It'll be a lot easier handling it this way rather than trying to handle this with SQL Editor in VC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.