LS

Is it possible to make an SP, that, if a record (key of two fields) does not
exists then inserts it (and give an output of value 1), but if it does
exists already then outputs the value 0, so you can execute the SP from
pascalcode and based on the output you can show a message. If so, how to
achieve this?

Regards, Harry

Harry,

<< Is it possible to make an SP, that, if a record (key of two fields) does
not exists then inserts it (and give an output of value 1), but if it does
exists already then outputs the value 0, so you can execute the SP from
pascalcode and based on the output you can show a message. If so, how to
achieve this? >>

Sure, but you'll have to use individual parameters for each column value in
the inserted row since EDB doesn't (yet) support row types.

I'm a little tight on time right, otherwise I'd be happy to write up the
procedure for you.

--
Tim Young
Elevate Software
www.elevatesoft.com