Matt Lemon
|
| Posted: 07/23/2003, 7:39 AM |
|
Hi,
I'm trying to use a SQL 7 Stored Procedure to do some checks on records before it either puts the data into the DB or returns a message. If I set the 'Data Source Type' to Procedure and then select the procedure from the list, I get all of the parameters listed for me but when I click 'Test' it complains about needing various defaults which are not appropriate in my case.
Can anyone explain how they have used SP's with CCS 2 ?
Thanks,
Matt
|
|
|
 |
Tom
|
| Posted: 07/26/2003, 4:37 PM |
|
I've used oracle sp with CCS 2 successfully. Note that at this time CCS IDE cannot handle returned values from SP when you are using the custom insert/update/delete. They will only accept input values.
Your sp probably has some input parameters. When you select procedure, do a get parameters and then assign you form controls to those parameters.
Hope that helps.
|
|
|
|
|
