Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

2 Neutral

Technical Information

  • Delphi-Version
    Delphi 10.3 Rio
  1. microtronx

    Report components: good, bad, ugly

    We can recommend ReportBuilder from Digital-Metaphors. We're using it since 20 years now. We have total dynamic reports including "creating your query components for current report" in "onBeforePrint" so we have >40 dynamic report pipelines which can be used within the reportbuilder itself to query the database + a lot more. You get very good support + bugfixes if they were reconstructable within 24 hours.
  2. microtronx

    Convert SQL from i.e. ADS to SQL2003

    If someone is searching for such a component: Alexander from delphihtmlcomponents.com has created a wonderful extension for his SQL Components to do this for us with ElevateDB syntax. Thanks a lot.
  3. microtronx

    Convert SQL from i.e. ADS to SQL2003

    Hi folks, any tips for VCL components doing a automatisch SQL convert from advantagedatabase to other sql standards? Most important are converting where-joins to sql-joins.
  4. microtronx

    Context sensitive code completion and syntax checking

    Wow! Alexander, is this available at the moment for customers?
  5. microtronx

    Rapid generics

    I'm using System.Generics.Collections so far and was only interested in comparing my component with rapid.generics. My "small" benchmark does not say anything in detail but it shows, that the Rapid is doing create and free faster. Before this can be used the source should be checked for threadsafe etc ... Our component stores a lot of information in a "tDictionary<string, __Record>;" where the __Record is defined as __Record = record public isObject, doFreeObject:boolean; vname:string; vname_original:string; vname_2, vname_3, vname_4:string; vwert:variant; vdescription:string; vcomponent:tobject; vdtstamp:tdatetime; end; Important to see was only the speed-difference on my machine, and it is a noticeable difference with Rapid.Generics so the programmer is doing something right in my opinion.
  6. microtronx

    Rapid generics

    Hi Stefan, here's the code: procedure TForm1.Button1Click(Sender: TObject); var vstart:tdatetime; vtest, i:longint; vtc:c__TriggerConstants; begin vtc:=c__tp(); // create my Generics-Collection-Component try Randomize; vstart:=now; for i:=0 to 1000000 do vtc.add('my'+inttostr(i), Random(10000000), ''); memo1.Lines.add('> fill '+formatdatetime('hh:nn:ss:zzz', now-vstart)); vstart:=now; for i:=0 to 100000 do vtest:=vtc.getvalue('my'+inttostr(i), -1); memo1.Lines.add('> get sort '+formatdatetime('hh:nn:ss:zzz', now-vstart)); vstart:=now; for i:=0 to 100000 do vtest:=vtc.getvalue('my'+inttostr(random(100000)), -1); memo1.Lines.add('> get random '+formatdatetime('hh:nn:ss:zzz', now-vstart)); vstart:=now; finally freeandnil(vtc); memo1.Lines.add('> free '+formatdatetime('hh:nn:ss:zzz', now-vstart)); end; end; And yes, i create 1.000.000 elements and later read only 100.000 .. 😉 The code was compiled two times with switching directives: {$ifNdef mxHtScripter_RapidGenerics} System.Generics.Collections, {$else} Rapid.Generics, {$endif}
  7. microtronx

    Rapid generics

    I have tested my component for Generics-Collection with Tokyo 10.2.3 and Rio 10.3.1 with same results: Adding 100.000 data / read in order 0 to 100.000 / read 100.000 times random / free Tokyo: 1417ms / 59ms / 67ms / 234ms Tokyo with Rapid-Generics: 705ms / 49ms / 69ms / 26ms Rio: 1415ms / 59ms / 65ms / 230ms Rio with Rapid-Generics: 671ms / 51ms / 69ms / 26ms So the results between Tokyo and Rio are the same! But Rapid Generics is faster with adding (increment) and freeing (.clear)
  8. microtronx

    Delphi Rio and tRegEx.Replace Problem

    I've tried it today but with normal copy&paste of text the false offset in tMatch is not there, it is working. Only getting the text from tmyquery.fieldbyname('myclobfield').asstring forces the false offset in tRegEx. I think it has something todo with the encoding of the text from am CLOB (UNI) field in ElevateDB. Possible that we've searched for problem in tRegEx but it is in combination with ElevateDB. We're searching further. If we get a hit we'll post it here...
  9. microtronx

    Delphi Rio and tRegEx.Replace Problem

    But that code works perfect with 10.2.3. In my_RegExReplace i do result:=match.value and only if i have to replace something special i change result to whatever i need, this is ok, AFAIK.
  10. microtronx

    Delphi Rio and tRegEx.Replace Problem

    Hi pyscripter, don't have time and ressources at the moment to create a demo from our code. We have switched back to Tokyo 10.2.3 and everything works again. If i have time next week, i will create a demo showing the problem in Rio. It seems that tRegEx is not working same as in tokyo!
  11. Hi All, does someone have also problems with Delphi Rio and tRegEx.Replace, it is the same as in following Rsp: https://quality.embarcadero.com/browse/RSP-19902 I have installed all available patches and missing files for Rio but this problem still exists. Possible my Error and i don't see it? Same source works perfect with Delphi Tokyo 10.2.3: function my_RegExReplace(const Match: TMatch): string; var vbasic, vfunktion, vwert:string; vp1, vp2, vp3:string; i:integer; begin result:=match.value; if match.value='' then exit; vfunktion:=copy(match.value,1,pos('(',match.value)-1); vwert:=copy(match.value, pos('(', match.value)+1, length(match.value)); vwert:=copy(vwert,1,length(vwert)-1); if ansisametext(vfunktion, '.ResponseInfo.redirect') then result:='.ResponseInfo.redirect['+vwert+']'; end; function my_RegEx_run_Replace(vScript, vBasicList, vBasicSuffix:string):string; var vlist:tarray<string>; i:integer; vname:string; begin result:=vScript; try vlist:=vbasiclist.split([',']); for i:=0 to length(vlist)-1 do begin vname:=trim(vlist[i]); if vname<>'' then begin if pos(lowercase(vname), lowercase(vScript))>0 then begin vScript:=tRegEx.Replace(vScript, vname+vBasicSuffix, my_RegExReplace, [roIgnoreCase, roMultiLine]); end; end; end; result:=vScript; finally setlength(vlist,0); end; end; function my_replace(vsearch:string):string; begin // try something like this: vsearch :='xxx xxxxxx.Responseinfo.redirect(blablup); xxxxx'; result:=my_RegEx_run_Replace(vsearch, '.S,.I,.O,.ResponseInfo.redirect', '((([^\(\)][,\-*\/])(([^\(\)]))[,*\-\/]*)+)'); end;