Jump to content

Shavkat PANDA

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

Technical Information

  • Delphi-Version
    Delphi 10.4 Sydney

Recent Profile Visitors

145 profile views
  1. Shavkat PANDA

    Styled menus / popup menus don't look nice

    highlighted menu items look pretty without styles: but with style applied the menu looks childish (left, bottom and right margins are all different!): how to fix that, folks? thanks
  2. Shavkat PANDA

    TFDMemTable.CopyDataSet multiplicates some records

    good. should I add the issue into the quality portal?
  3. Shavkat PANDA

    TFDMemTable.CopyDataSet multiplicates some records

    1) 10.4.1 2) the problem is not in the FDMemTable.CopyDataSet method after copying I use LocalSQL to query the memory table two queries shown below produce different datasets in LocalSQL: a) this query returns the correct set select * from ProductsInMemory where DivCod in (:Stok, :Shop, :Prim) and LocCod like :SearchCod and (:SearchSeasons='' or instr(' ' || trim(:SearchSeasons) || ' ',' ' || trim(Season) || ' ')>0 ) and BrandName like :SearchBrand and Article like :SearchArticle and (:SearchSizes='' or instr(' ' || :SearchSizes || ' ',' ' || trim(Size) || ' ')>0) and Description like :SearchDescr and Color like :SearchColor and Disc1 like :SearchDiscPerc and (:Check_M=1 and (MorF in (1,3)) or :Check_F=1 and (MorF in (2,3)) or :Check_B=1 and MorF=4 or :Check_G=1 and MorF=5 or :Check_D=1 and MorF>5) and (:SearchPriceFrom=0 and :SearchPriceTo=0 or :SearchPriceFrom<=SomPrice and SomPrice<=:SearchPriceTo or :SearchPriceFrom<=SalesPrice and SalesPrice<=:SearchPriceTo) and BarCode like :SearchBarCode and (OriginalArticle || OriginalArticle2 || OriginalArticle3 like :SearchOriginalArticle) b) this one returns multiplied records: select * from ProductsInMemory where DivCod in (:Stok, :Shop, :Prim) and LocCod like :SearchCod and (:SearchSeasons='' or instr(' ' || trim(:SearchSeasons) || ' ',' ' || trim(Season) || ' ')>0 ) and BrandName like :SearchBrand and Article like :SearchArticle and (:SearchSizes='' or instr(' ' || :SearchSizes || ' ',' ' || trim(Size) || ' ')>0) and Description like :SearchDescr and Color like :SearchColor and Disc1 like :SearchDiscPerc and (:Check_M=1 and (MorF in (1,3)) or :Check_F=1 and (MorF in (2,3)) or :Check_B=1 and MorF=4 or :Check_G=1 and MorF=5 or :Check_D=1 and MorF>5) and (:SearchPriceFrom=0 and :SearchPriceTo=0 or :SearchPriceFrom<=SomPrice and SomPrice<=:SearchPriceTo or :SearchPriceFrom<=SalesPrice and SalesPrice<=:SearchPriceTo) and BarCode like :SearchBarCode and (OriginalArticle like :SearchOriginalArticle or OriginalArticle2 like :SearchOriginalArticle or OriginalArticle3 like :SearchOriginalArticle) the difference between the two is in the last line: <and (OriginalArticle || OriginalArticle2 || OriginalArticle3 like :SearchOriginalArticle)> vs. <and (OriginalArticle like :SearchOriginalArticle or OriginalArticle2 like :SearchOriginalArticle or OriginalArticle3 like :SearchOriginalArticle)> both queries return identical sets if I SELECT FROM the original MSSQL table (for MSSQL we replace '||' by '+' of course)
  4. Shavkat PANDA

    TFDMemTable.CopyDataSet multiplicates some records

    gosh, did you understand what I wrote?
  5. Shavkat PANDA

    TFDMemTable.CopyDataSet multiplicates some records

    sorry, but your both posts are irrelevant
  6. Shavkat PANDA

    TFDMemTable.CopyDataSet multiplicates some records

    your both posts are irrelevant
  7. Shavkat PANDA

    TFDMemTable.CopyDataSet multiplicates some records

    found the source of the problem, it's a LocalSQL. the queries (let :Param_B = '%%') select * from Table_1 where Field_0 like :Param_A and (Field_1 like :Param_B or Field_2 like :Param_B or Field_3 like :Param_B) and select * from Table_1 where Field_0 like :Param_A and (Field_1 + Field_2 + Field_3 like :Param_B) return identical datasets if Table_1 is a table from MSSQL DB, but if Table_1 is an FDMemTable - the first query triplicates dataset records (in LocalSQL query '+' must be replaced by '||') is this an SQLite bug?
  8. hi, did anybody have this issue: 1) FDquery1 to some MSSQL table 2) view dataset of FDquery1 thru DBGrid - 3 distinct records (same result in SSMS) 3) FDMemTable1.CopyDataSet(FDquery1,[coStructure, coRestart, coAppend]) 4) view dataset of FDMemTable1 thru DBGrid - 9 records (3 original records copied 3 times) what could be a problem?
  9. Shavkat PANDA

    Embarcadero Toaster - Notification Window Caption in Win10

    I've got 10.4.1 Enterprise as I said, it only happens once within each Windows session. next notification is okay
  10. When called for the first time (since OS started) the Notification Caption looks like this (see pic). All other times it's just like expected (program name). How to fix that?
×