Re: Constraints

I wish we could take advantage of RI and stored procedures in Informix. If we were only coding for Informix backends, then there would be no problem and we could take advantage of all the bells and whistles Informix gives us. I have found that by putting the RI rules into our code, it is more difficult to develop, but it allows us an much easier time making our code work on other databases, like SyBase and the "O" db. It is easier to code the RI into the application once, than to have to maintain RI and SP code for each of the databases we support or may be asked to support. If the db even supports SP and RI! ------------------------------------------------------------------------------ Alan Goodman | Data Systems Support Senior Systems Analyst | A Client Technologies Company internet : alan@dssmktg.com | 1228 Shelly Ct. Voice 714-771-0454 Fax 714-771-3028 | Orange, CA 92668 USA ------------------------------------------------------------------------------ From Roland Muller: >Hi Peter, > >I have been doing a database application on Informix 4.1 in 4gl. As >Cheryl mentionned, you have to put the rules for RI into your >application code, if you have no constraints (referential ones in this >case). > >We upgraded to 6.0 and now up to 7.11 with Constraints available. For my >part I didn't hesitate using them. The benefits of constraints and >stored procedures are: > - Less Code in your Client to check RI and values. > - The Client just needs to react on error-events. > - Most of the Rules are now stored ONCE on the server. > >Doesn't that make development easier? If you need examples or have >further question, feel free to write me an e-mail. > >Sincerely, >Roland