Re: column specified twice

I solved my problem.

The No Update column should be the one that contain the same data with the 
parent table. I made it to LinkObject that was my problem. I can now run my 
form without this kind of a problem.

----- Original Message -----
From: "Mehmet Seckiner" <seckiner-jjFNsPSvq+iXDw4h08c5KA@xxxxxxxxxxxxxxxx>
To: rekall-TvUNdCdnGOiN0BpGcQGnph2eb7JE58TQ@xxxxxxxxxxxxxxxx
Subject: [Rekall] column specified twice
Date: Wed, 15 Jun 2005 09:17:24 +0800

> 
> Hi!
> 
> This is a great software. Solves most of my db
> programming needs under Linux. I believe it is much
> more powerful than I think. But unfortunately I have
> no time to go deep inside by learning python
> scripting.
> 
> I designed a Form-Subform classic scenario of the form
> of ORDERS.
> 
> there are three tables: orders, orders_detail and
> products. products and orders_detail are linked by a
> field ProductCode. I could manage to add a link object
> and succesfully see the names of the products instead
> of seeing their code only (they come from the table
> products) and edit them by using this dropdown effect.
> 
> But when I add a row at the bottom of the
> orders_detail block a SQL error occurs: Column
> 'ProductCode' specified twice
> 
> Insert into orders_detail (Qty, ProductCode,
> ProductCode, OrderCode) values (3, 11021, null, 110)
> Column 'ProductCode' specified twice
> 
> I want to see the ProductCode field also in the detail
> block. And this is the reason I get this error. This
> is the reason the SQL statement include this field
> twice.
> 
> Also I tried to use No Update. But if I use No Update
> option, the Link object becomes useless for me. This
> is not a solution.
> 
> What can you recommend me on my problem?
> 
> Thanks to all on providing this software come to life...
> 
> --
> _______________________________________________
> Check out the latest SMS services @ http://www.linuxmail.org
> This allows you to send and receive SMS through your mailbox.
> 
> Powered by Outblaze
> _______________________________________________
> Rekall mailing list
> Rekall-TvUNdCdnGOiN0BpGcQGnph2eb7JE58TQ@xxxxxxxxxxxxxxxx
> http://www.mailman.a-i-s.co.uk/cgi-bin/mailman/listinfo/rekall


-- 
_______________________________________________
Check out the latest SMS services @ http://www.linuxmail.org
This allows you to send and receive SMS through your mailbox.