nubuuilder does not save new records

[calida82]

i am using nubuilder i dont like alphanumeric primary keys so i created the tables manually with phpmyadmin but i have a problem.
when I want to add a new record even if I don't fill in all the fields the record is not saved. why does this happen?
when I save the popup record saved appears but this does not happen. Why?
i also want some fields to autofill with this function in custom code

Code: Select all

function nuBeforeSave(){
    nuSetValue('mar_tipo','VETTURA'));
}

but that doesn't seem to work either

[nc07]

Hi Calida82,
With regards to the record not saving, are you using auto increment and is the primary key set in mysql. can you show the the table structure?
Do you see any result in the debug.Kindly provide further information so we can assist you better.

To set Default value, You can do something like below.

Code: Select all

 if (nuFormType() == 'edit' ){
    $('#field_id').val(defaultvalue).change();
  
     nuHasNotBeenEdited();
    }

Nilesh

[calida82]

I think I understand why. in my of the fields are all set to not null so if I don't fill in the field the error is generated because I try to insert a null field in the db which does not accept null. For the moment I solved it like this. in the onchange event of the only required field I wrote this

Code: Select all

if (nuIsNewRecord()){
   nuSetValue('cli_citta','');
   nuSetValue('cli_indirizzo','');
   nuSetValue('cli_telefono','');
   nuSetValue('cli_email','');
}

questo sembra risolvere il problema

[kev1n]

because I try to insert a null field in the db which does not accept null.

Wouldn't it be a viable option to set NULL as the default for the columns?

[calida82]

the fields in database are set to not null