Alexandria 11.3 - Firedac/OnValidate String Field

[Antonio Gomes 0]

see the demo, onvalidate event, when the dbgrid is full of records.

Alexandria 11.3

OnValidateBug_(1).zip

[programmerdelphi2k 237]

zip with only EXE = virus, ransomware, spyware,...  no no no, show the source please!

[leonard.miranda 0]

Hi, I'm sending the source code.

 

If you compile it in delphi 11.2, the error does'nt occur.

 

 

 

OnValidateBug.zip

Edited March 8, 2023 by leonard.miranda

[programmerdelphi2k 237]

im has only RAD 11.3

 

 

 

Edited March 8, 2023 by programmerdelphi2k

[leonard.miranda 0]

https://quality.embarcadero.com/browse/RSP-40802

[leonard.miranda 0]

Here this error occur.. How can I record my screen like you?

[leonard.miranda 0]

Ops.. Change the Insert by Append 

[programmerdelphi2k 237]

ShareX - open source on Github +200 contributors

 

Microsoft Store: search for "ShareX" tool

or  https://getsharex.com/

[leonard.miranda 0]

The correct version. sorry.

OnValidateBug.zip

[leonard.miranda 0]

[leonard.miranda 0]

If you use bottom arrow on DBGrid to add record, the error occur too

[programmerdelphi2k 237]

ok, the errors appears = field value = empty... but the record is appended with value informed!

 

[leonard.miranda 0]

Yes, but look it

[programmerdelphi2k 237]

the values is already "empty" since "procedure TForm3.FDMemTable1NewRecord(DataSet: TDataSet);" 

[leonard.miranda 0]

Do you agree that we have a incorrect behavior here?

[leonard.miranda 0]

Did you compile it on a previous version? The behavior dont occur.

[programmerdelphi2k 237]

sorry my fault... 

Edited March 8, 2023 by programmerdelphi2k

[leonard.miranda 0]

Sorry again. 

[leonard.miranda 0]

The field can be only S or N.

1 - On NewRecord I change to S.

2 - The value receives 'empty', raising a exception... maybe it's be a better demo..

 

[programmerdelphi2k 237]

in two case above, when "S" you read this:

if FALSE or TRUE then = true

if FALSE AND TRUE then = false

[leonard.miranda 0]

[leonard.miranda 0]

The problem is that this behavior blocks the insertion of data, especially when I try to do it through the DBGrid (Down Arrow)

[leonard.miranda 0]

If this were the standard and correct behavior of events, I think this should be the case regardless of how many records there are in the DataSet. This worked correctly until the last version.

[programmerdelphi2k 237]

I dont know... it's necessary wait Embarcadero ticket...

I never use "Dataset" events like this...  always in DB by default! all biz-rules!!!

[Antonio Gomes 0]

21 minutes ago, programmerdelphi2k said:

I dont know... it's necessary wait Embarcadero ticket...

I never use "Dataset" events like this...  always in DB by default! all biz-rules!!! 

I never use "Dataset" events like this...  always in DB by default! all biz-rules!!! 

 

how is that? Don't use the dataware controls? tdbedit etc ..