Fetch Row with more than 2 values for primary key
515667Aug 21 2006 — edited Aug 21 2006Hi
I am developing a application and I need to know if something is possible. My application is to simply update a table that has 4 values that make up the primary key (value1, value2, value3, value4).
My first page of the application is a simple report with an edit button that links to page 2 which is a form to be able to update the table row selected.
When I select a row to edit I want to pass all four values to page 2 (which is not the problem). When page 2 loads I want to fetch that row that I am trying to edit. Apex has a fetch row process but only allows you to enter two values (primary key and second key) from which it tries to fetch the row you selected. If I fetch the row with just two keys then a get an error saying that it has come back with mroe than one row. I need to fetch the row with all four values since it makes up my primary key. Is there a way to do this in apex?
Thanks