• From: Perugia (Italy)
  • Registered: 2019-01-29
  • Posts: 337

Re: Insert text into a report depending on your choice

sparrow wrote:

An error can occur if the Quantita field of the frmInserimentoArticolo form is incorrectly specified
or not specified (empty) when colorizing a table.
Several solutions:
set default value
do validation of the entered value in the Edit field,
modify the calculated field to return 0 instead of empty.


p.s. Fabio in this case, commenting one line will not help in finding the error. You need to comment out 957 - 960.
These lines contain the condition check.

Exactly. I commented out the lines you said and the error doesn't come out.

www.fabiobernini.it
www.reteinformatica.biz

reteinformatica's Website

  • Registered: 2014-11-13
  • Posts: 371

Re: Insert text into a report depending on your choice

O visto che lo fa se non inserisci le quantità nel articolo, giustamente lo script non può fare i calcoli

Domebil

domebil's Website

28 Reply by domebil (edited by domebil 2023-08-21 18:55:18)

  • Registered: 2014-11-13
  • Posts: 371

Re: Insert text into a report depending on your choice

ora o dato di default lo 0 in maniera che lo scipt non si blocchi più

Post's attachments

Attachment icon GestArticoli-2.rar 951.27 kb, 66 downloads since 2023-08-21 

Domebil

domebil's Website

  • From: Perugia (Italy)
  • Registered: 2019-01-29
  • Posts: 337

Re: Insert text into a report depending on your choice

Grande Domenico! Infatti per fare la prova avevo inserito solo descrizione e prezzo.
Complimenti per il sito, molto carino anche quello.
Grazie!

www.fabiobernini.it
www.reteinformatica.biz

reteinformatica's Website

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 895

Re: Insert text into a report depending on your choice

Form frmscontrinidetail:
Edit1 and Edit9.

Form frmInserimentoArticolo:
edAliquotaivavendita.

The NumbersOnly property is not set. This allows you to enter a period, comma, or any character if you type carelessly.

31 Reply by reteinformatica (edited by reteinformatica 2023-08-21 20:59:05)

  • From: Perugia (Italy)
  • Registered: 2019-01-29
  • Posts: 337

Re: Insert text into a report depending on your choice

Thanks sparrow for this clarification. Tell me if I'm wrong, in the forms you mentioned wouldn't it be better to also set all the other editboxes with the numberonly property?

www.fabiobernini.it
www.reteinformatica.biz

reteinformatica's Website

32 Reply by sparrow (edited by sparrow 2023-08-22 06:38:03)

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 895

Re: Insert text into a report depending on your choice

No.
The numberonly setting is important for fields where you can enter price, quantity, number (without letters), size ... .
If you set this property for text fields you will not be able to enter color, characteristics, description...
The numberonly property also controls the correct input of a delimiter between integer and decimal places.
Typically, numberonly fields should be set to a default value. But not NULL ! Or, a property, a required field, is set
for such a field, with validation of the entered value.

33 Reply by reteinformatica (edited by reteinformatica 2023-08-22 09:22:33)

  • From: Perugia (Italy)
  • Registered: 2019-01-29
  • Posts: 337

Re: Insert text into a report depending on your choice

Hi sparrows,
I meant all textboxes where only numbers should be entered. for example "edIvaAcquisto" of "frmInserimentoArticolo" which in any case is read-only, there should be only numbers but you didn't include it in your suggestion.

www.fabiobernini.it
www.reteinformatica.biz

reteinformatica's Website

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 895

Re: Insert text into a report depending on your choice

Read-only, so didn't specify.

  • From: Perugia (Italy)
  • Registered: 2019-01-29
  • Posts: 337

Re: Insert text into a report depending on your choice

Ok, it's clear. Thank to all.

www.fabiobernini.it
www.reteinformatica.biz

reteinformatica's Website