Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 1 of 1 total |
CustomFunction returning empty string |
Thu, Dec 2 2021 9:04 AM | Permanent Link |
Guilherme Martins Quorum Consultoria Ltda | I have a custom function that sometimes is returning a empty string and I can´t match the result.
Here is the code to reproduce the problem: begin Engine.Functions.CreateFunction(ftString,'ReturnEmpty'); end; procedure MyForm.CustomFunction(Sender: TObject; const FunctionName: String; FunctionParams: TDBISAMParams; var Result: Variant); begin if (AnsiCompareText(FunctionName,'ReturnEmpty')=0) then Result:=''; end; select * from table where ReturnEmpty() = '' >>> returns no records select * from table where ReturnEmpty() is null >>> returns no records select * from table where length(ReturnEmpty())=0 >>> returns ALL records Can anybody help me? Thanks a lot, Guilherme Martins |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |