Unknown column 'no' in 'field list'

Applications Forms
#1

Hi all,
My test run failed but I’m almost there.

What do you think that implies? Because what it should be doing is taking the value from the radio buttons whatever the user selects and putting that as the value variable into the table on the database. The table name is called ‘distributor’ so I don’t know why it’s doing that. The database type of it is set of values (‘yes’, ‘no’). It does shows the value to the records that have it defined …but when i try to add a new record and define this field’s value…it shows the error "Error inserting:
Unknown column ‘no’ in ‘field list’ "

What should i do?? I thought editing the code directly…but i can’t seem to find it

Thanks for the time,

#2

Re: Unknown column ‘no’ in ‘field list’

Hello mirela,

Is “no” a column or simply a value you are trying to set on a given field? Please contact our support so we can run diagnose what might be causing this issue.

regards,
Bernhard Bernsmann

#3

Re: Unknown column ‘no’ in ‘field list’

Hello
first, thanks for replying

…‘no’ is a value. The name of the field is ‘Distributor’ and it takes only two values, ‘yes’ or ‘no’. I have created a form in Scriptcase and this field is set as a radio button, where users choose either the record is a distributor (‘yes’) or just a client (‘no’). This happens for both actions, ‘add’ and ‘update’ records.

I hope you can help me…

Regards

#4

Re: Unknown column ‘no’ in ‘field list’

Hello mirela,

I believe the problem is how you defined those values on your form. Please contact our support regarding this issue.

regards,
Bernhard Bersnmann

#5

Re: Unknown column ‘no’ in ‘field list’

Hi,
I have strictly used the scriptcase form options. In the database this field is set as one of the databases normal type, the ‘set’ type. And it has two acceptable values: ‘yes’/‘no’. I even try to set it as a ‘select’ , because i thought it may be a problem of ‘radio button’ but i still get the same error… The main problem is that a can’t make any changes in the database, but if the value is set…the form does recognize it. It just can’t change it or add new!

I hope i explained clearly.

I emailed your support, still no answer…

Mirela

#6

Re: Unknown column ‘no’ in ‘field list’

hey, it’s me again

i changed the DB value (Insert)/(update) in Form settings->edit fields, to: calculated from database. It doesn’t show the error anymore but it still doesn’t make the edit in database. I can add new records now but they take the default value set for the ‘Distributor’ field, after that i can only change it directly from the database.

Keep on trying…

#7

Re: Unknown column ‘no’ in ‘field list’

Hello,

Instead of emailing us open a ticket or request a live chat.

regards,
Bernhard Bernsmann