Subject Re:[firebird-support] Re: lost of FK ...why?
Author Alberto Pesce
Hi !
How can I set a Forced Write?

The ibase_commit() in that position can cause problems?

$conn = ibase_connect($SERVER, $USERID, $PASSWORD) or die ("Impossibile
connettersi al Data Base");
$action = "INSERT INTO table VALUES('$CODICE',

'$GRUPPO','$CODICE_FORN','$SCONTO_1','$SCONTO_2','$SCONTO_3','$SCONTO_4');";
$I = ibase_query($conn,$action);
if (!ibase_errcode())
$msg = "Inserimento effettuato";
else
$err_msg = "Inserimento non effettuato";

ibase_commit();


Thanks
Alberto

> ----- Original Message -----
> From: "Alberto Pesce" <palberto@...>
> To: "firebird-support" <firebird-support@yahoogroups.com>
> Sent: Thursday, June 16, 2005 9:03 AM
> Subject: Re:[firebird-support] Re: lost of FK ...why?
>
>
> > Well,
> > the foreign key constraint always exist, and data which violate the FK I
> find after a period of work.
> > I don't remember if the Forced Writes are switched on ? I will verfy!
> >
> >
> > Thnaks bye,
> > Alberto
> >
> >
> > > Alberto,
> > >
> > > I have never experienced that sort of problem, so I am only guessing
> > > here at some possible causes.
> > >
> > > Did the foreign key constraint always exist or was it declared after
> > > the table had some (potentially invalid) data already inside it?
> > >
> > > Also, is Forced Writes switched on?
> > >
> > > Adam
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > Visit http://firebird.sourceforge.net and click the Resources item
> > > on the main (top) menu. Try Knowledgebase and FAQ links !
> > >
> > > Also search the knowledgebases at http://www.ibphoenix.com
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> > ____________________________________________________________
> > Navighi a 4 MEGA e i primi 3 mesi sono GRATIS.
> > Scegli Libero Adsl Flat senza limiti su http://www.libero.it
> >
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
>