Problems to insert with REFERENS in database
| From: | binhara | Date: | Mon, 25 Aug 2003 19:07:21 +0000 |
| Subject: | Problems to insert with REFERENS in database | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-7403@lists.php.net to get a copy of this message | ||
Hello All. .
I work with the DBDataObject..
but i have a problems with referens in database
for example..
I have 2 table (objects) like:
---------------------
| Cliente |
---------------------
| CodCliente serial |
| name varchar(40) |
| email varchar(40) |
----------------------
-------------------------------------
| Login |
-------------------------------------
| CodCliente referencs cliente(codcliente)
| Login varchar (20)
| pass varchar (20)
--------------------------------------
When a make insert in table login ..
it dont put a codcliente from cliente table
in codcliente field of table login.
It generate a new cod from sequence.. CodCliente in
if i use ignore_sequence_keys = ALL
then i can insert a recorde in table cliente..
That's Happen .. ??