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 o
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 a