![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Mon, May 21 2007 5:20 AM | Permanent Link |
"Harry de Boer" | 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 |
Thu, May 24 2007 8:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |