Subject | Re: Re:[firebird-support] Re: lost of FK ...why? |
---|---|
Author | Alberto Pesce |
Post date | 2005-06-16T14:29:01Z |
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
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
>
>
>
>
>
>