Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Downside of RI in DD

2 posts in Trigger Last posting was on 2005-05-27 20:33:15.0Z
Jack Posted on 2005-05-25 22:50:28.0Z
From: "Jack" <nospam@nospam.com>
Newsgroups: Advantage.Trigger
Subject: Downside of RI in DD
Date: Wed, 25 May 2005 18:50:28 -0400
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 68.237.98.203
Message-ID: <429501f3@solutions.advantagedatabase.com>
X-Trace: 25 May 2005 16:53:39 -0700, 68.237.98.203
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!68.237.98.203
Xref: solutions.advantagedatabase.com Advantage.Trigger:165
Article PK: 1136230

Hi,

We are currently porting an existing project from Clipper to Windows, and
would be very interested to hear some feedback about the disadvantages of
using the referential integrity features of the DD versus handling it in
code.

The project is being done in Delphi, we know a lot about the advantages and
am considering doing it, but we have other options (like BeforePos
OnFieldChange) open.

Thanks


-Jack


Alex Wong (ADS) Posted on 2005-05-27 20:33:15.0Z
From: "Alex Wong \(ADS\)" <alexw@extendsys.com>
Newsgroups: Advantage.Trigger
References: <429501f3@solutions.advantagedatabase.com>
Subject: Re: Downside of RI in DD
Date: Fri, 27 May 2005 14:33:15 -0600
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 198.102.102.73
Message-ID: <429784f2@solutions.advantagedatabase.com>
X-Trace: 27 May 2005 14:37:06 -0700, 198.102.102.73
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.73
Xref: solutions.advantagedatabase.com Advantage.Trigger:166
Article PK: 1136229

Hi Jack,

Since there has been no reply, my guess is there is no disadvantage :)

Seriously, here is my 2 cents.

whether you do it in code (BeforePost/OnFieldChange) or leave it to the
server, you must have the code to handle the error nicely. If it is done by
the server, you code still has to catch the possible error in the Post event
and handle it gracefully.

The big advatnage of having the Advantage Database Server handling it is
that there is virtually no chance for other application or event to mess up
your data. I would say do it in code as well as set it up in the data
dictionary. This way you code should handle the RI correctly, if by chance,
there is a bug in your code or you application crashes unexpectedly, the
server will ensure there is no RI problem.

Alex

"Jack" <nospam@nospam.com> wrote in message
news:429501f3@solutions.advantagedatabase.com...
> Hi,
>
> We are currently porting an existing project from Clipper to Windows, and
> would be very interested to hear some feedback about the disadvantages of
> using the referential integrity features of the DD versus handling it in
> code.
>
> The project is being done in Delphi, we know a lot about the advantages
> and
> am considering doing it, but we have other options (like BeforePos
> OnFieldChange) open.
>
> Thanks
>
>
> -Jack
>
>