Adding records using form based on stored procedure?

[ZRexRider]

Hi,

Is it possible to base a form on a stored procedure that has 2 or three
joins and be able to add records back to the database?

I have a fairly straight forward SELECT in a stored procedure that when
run in MS-Access ADP does not offer a "New" row in the results grid but
if I cut and past the same code into a View it does.

If I remove the joins from the SP then it looks like it's going to let
me add. Should I give up?

I'm not using the view because I am passing 2 parameters and I also
want to do some IF/THEN logic. I just want to be able to add new
records as well.

Thanks

 

[Douglas J. Steele]

Most stored procedures return recordsets that are read-only.

 

[aaron.kempf]

i think that if you set the 'unique table' property you shouldn't have
a problem.

try to take away the join and do everything on lookups (combo boxes)

-aaron

 

[aaron.kempf]

ps what is your if then statement? you sure you can't use the same
logic in a view?
share it with us; usually a combo of nullif, isnull, coalesce lets us
do if then in a view.. or case when then at least

fiddle with it; keep up the good work

and give us your friggin sql statements!