Auto increment

[ruiascensao]

Hi,
I'm trying to use the below code to auto increment a field. I added the hash variables for nuBuilderPro but it does not work.

Code: Select all

if('#nu_cloned_record#' == '1' or '#RECORD_ID#' == '-1'){     //-- this is a new record

   nuRunQuery("INSERT INTO recepcounter (extra_field) VALUES ('1')");

   $s  = "UPDATE reception SET reception_code = '" . mysql_insert_id() . "' ";
   $s .= "WHERE reception_id = '#nu_new_record#'";

   nuRunQuery($s);

}

Could you please advise?

[admin]

Rui,

Hopefully this helps..

http://wiki.nubuilder.net/index.php/Has ... mber.23.29

Steven

[ruiascensao]

Hi Steven,

Thank you!

How can I use "#invoice_number#" inside "PHP Code"?

[admin]

Rui,

You can use nuNextNumber($t)... (http://wiki.nubuilder.net/index.php/PHP ... .28.24t.29)

Steven

[ruiascensao]

Hi Steven,

Thanks!
Sorry ... I'm just starting with nuBuilder3.
Great product.

Rui

[admin]

Tell all your friends!