Page 1 of 1

Add form problem

Posted: Fri Feb 15, 2013 9:04 am
by fuzzyq
Hi,
I'm new here.

I create browse form and i inner join two tables on this form.
When i create object text and add this object to my form and try add some record program give me error:

Code: Select all

An error has occurred while running this query.

SQL

SELECT * FROM `model` WHERE `model.id` = '-1'
and this is my browse html:

Code: Select all

select * from model
inner join marka on marka.id = model.marka_id
plz help me.

Regards!

ps. sorry for my bad english.

Re: Add form problem

Posted: Sun Feb 17, 2013 2:30 am
by admin
fuzzq,

Make the primary key of the Form id not model.id.

Steven

Re: Add form problem

Posted: Fri Mar 01, 2013 12:05 pm
by painatal
i've had the same problem. did you solve it?

Re: Add form problem

Posted: Wed Mar 06, 2013 12:28 am
by admin
painatal,

This is the answer
Make the primary key of the Form id not model.id.
Because nuBuilder puts 2 ` around the primary key.

Steven