[Solved] passing extra parameters to stored_procedure

[daniel coppee]

Hello,

I use stored procedures to update/delete the content of a table.
Everything works fine if I only use it on the exact fields in the grid and table but I need to pass an extra parameter (not present in the grid or table...in this case the logged-on username -> used to update a logtable in the same stored procedure).
The stored procedure works fine but cannot be used from the webpage using the modified gridupdate/delete functions (too many parameters...)

Is there a way to make this work. I noticed some related questions on the forum but did not found an answer.

Thanks

Daniel

[Shinu]

Hi,

Go through the following help document link.
Retrieving primary key field values for selected items

Shinu.

[daniel coppee]

Hi Shinu,

Thanks for the reply but I do not see how this can help me except when the answer is offcourse rewriting the whole insert/update procedure

I just need to pass one extra value (e.g. logged-in user) to the (automatic) grid insert/update/delete database calls

Daniel