Search the Community
Showing results for tags 'IsNull'.
-
Hi, I have an error detected using UniDbGrid (TUniDbGrid) related to an Interbase table. Also I am using Delphi 10.2 Tokyo with Unigui version 10.0.1472. In a column where Integer type values are loaded (the same happens with Float type fields), if I insert the value 0 (zero) when validating the previous record of its insertion in the table, the IsNull function returns the value True. The exact validation done in the BeforePost event of the table is as follows: If TableName.FieldByName ('AmountFrom'). IsNull then ShowMessage ("You must enter an amount greater than or equal to 0") The problem is that if I charge amount = 0 the, when doing the previous validation I get the message that I must enter an amount because of the IsNull function returns TRUE. If 0.01 is reported (or any value other than 0) the IsNull function returns FALSE. I did the same test using DbGrid (TDbGrid) and the "IsNull" function worked correctly returning TRUE if nothing was actually entered in the column and FALSE if 0 (zero) was loaded so the problem is not at the database level. In this case I am not using querys but I use the TIBCTable and TIBCDataSource components of Devart. Thanks in advance
-
Hi: I have the following problem when trying to validate the data of a record in an Interbase table. At the time of the Post, valid if one of the fields you are entering is Null or less than 0 (zero). I evaluate if it is null using the IsNull function, the problem that if you enter 0 (zero) in the registry the IsNull function returns False when it should be True. I've already tried using the Permanent Field format or using the FielbByName function and the result is the same. It is important to add that the 0 can be a valid value, not the Null value. I am working with Delphi Tokyo and Unigui version 1.10.0.1471. Any idea how to fix this?. Thanks in advance for your help