hi
how can I insert a record in the database for each checkbox Flegg?
Help!!!
Bye
Re: Checkbox
Database,Field: TinyInt
SC,Field:
DataType: Checkbox
Edition Lookup:
Method: manual
type: single value
label ‘’ ->blank
value: 1 (just need a value for true, not false)
columns: 1
Regards,
Scott.
Re: Checkbox
Crap, I read this too fast… I thought you want to know how to add a checkbox and update the field… it’s FRIDAY!
To answer your real question, I would say that you need to use JS and have an event perform the insert? Or could you detail your question a bit to explain what you need?
Regards,
Scott.
Re: Checkbox
think I will have to enter an event js. you have some sample code?
I have three checkbox and would like to insert a record for each FLEG.
Re: Checkbox
any idea?
Re: Checkbox
Perhaps you can try this
Select check field
Ajax Events: Add New Event
fieldname/onclick/fieldname as param), Create Event
add your code to insert record if field is check:
sc_exec_sql(‘insert into …’)
Regards,
Scott.