Re: column specified twice

On Wednesday 15 June 2005 02:17, Mehmet Seckiner wrote:
> 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.

Go to the properties for the code field. find "no update" and check it. This 
setting is normally used to prevent Rekall from saving it to the database, 
but it should have the right affect here.

>
> 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...

-- 
Regards
Mike

http://www.rekallrevealed.org
*THE* GPL/Open Source database front end for Linux and Windows.