Hi.

Im trying to insert data into a database using xforms in my process. I Use the Derby database installed with Intalio.

I dont have any problem when i use a database operation like a query, such as:

"select * from people where firstname = ?"

But what i want to do is insert data into that database with operations like:

INSERT INTO app.people(username, firstname, lastname, email, phone) values ('examples\\msmith', 'Mark', 'Smith', ' ', '1234567');

The program returns this error:

"The output of the database operation "inserting" is not defined."

So, is it possible to insert data or make another operations without outputs like deleting, modifiing... directly from my process by another way ?

Yes, it is. Did you modify the query from a SELECT statement ? Somehow the software must think this is still a SELECT.

Try creating a new query, paste the query in there, see what that gives.

Thanks,

Antoine

Yes, i modified the query from a select statement because when you create a new database connector it always is opened with the statement:

select * from <tablename>

I delete it and i write a INSERT operation, it works fine because i execute the sentence with an operation defined in the right button of the mouse.

But when i save it and i watch the Problems tab in designer, it returns the problem that the output is not defined.

So i dont know if i am doing something wrong or it is impossible to make operations without any output.

Thanks

That should be possible. 5.2.1 addresses that bug by introducing a new DB connector. 5.2.1 should be out soon.

Thanks,

Antoine

Thanks so much.

I will wait for 5.2.1 and meanwhile i will try to find another solution.

Thanks

Himar

At the end, i managed after doing the same 100 times, that software forget that it was a SELECT as you told me, and i could make an insert operation.

Anyway connector doesnt always work perfectly. Sometimes output parameters dissapear from mapper without any reason. I hope that in 5.2.1 it will be better.

Thanks Antoine.