bb.donnay-software.com

This is the solution how to create filter/WHERE expression with a date value in PgSql. I implemented that in my PowerSql library and it works excellent. cDate = "'" + DTOS(dDate) + "'" For example, if the date value is 31.03.2024, in German format, do this: SET FILTER TO datefld >= '20240331' DBSETF...

You can't build filters that are more complex than simple expressions like "name = 'Miller'". That means: filters are f*cking useless with the PGDBE. If you search the Alaska Knowledge Base for "PGDBE", you will find a lot of open PDRs concerning filters, and I don't believe they will ever get clos...

It seems that Tom finally figured out that filters should not be used in PgSql, as he said they are "f*cking useless". I told him the same before, but he claimed that they work excellent. ;) Tom, it is be better to use this code for searching, since it works much faster than to do manual SKIP for ea...

Hello everyone, I have developed several add-on libraries for Xbase++ programming, for different fields of application. They have a generic name Power libraries. You can find more information about them on the site: https://www.sd-softdesign.com. You can download documentation, DEMO programs and TES...

Tom, Yes, its a fine option in eXpress++ and I implemented a similar one in my PowerWin. But, its only a help to select a value into a get field when you press a popup button, and not a direct get select as XbpListBox. To return to the beginning, the initial request was to change font and colors of ...

I don't agree with you. You cannot compare XbpListBox with XbpBrowse and XbpQuickBrowse. You cannot use XbpBrowse and XbpQuickBrowse as GET elements. XbpBrowse don't have :dataLink property, and in XbpQuickBrowse :dataLink property and :getData() method have different purposes. They also don't have ...

Hi, This is not the way to change font and colors in a XbpListBox, with the XBP_PP_* parameters. You can do that with the XbpListBox owner-draw option, setting :drawMode = XBP_DRAW_OWNER, and using :drawItem() and :measureItem() methods. To create a CSS sheet for a XbpListBox, use XbpListBox:visualS...

Hi Viktor, Since you want to compare 35 out of 36 fields for equality, my Excel code can be modified not to compare each column values as it is now, but to compare values of entire rows, or values of a range of columns. So, there will be only one compare statement per each row, and no need to sum va...

Hi, Yes, "." have to be replaced with ":", its Xbase++ syntax. Yes, duplicates can be in different places of the table, not only the following records. So, first you have to sort range with Sort method. Here is an example for the first 2 columns. ActiveSheet:Range("A1:C1000"):Sort(ActiveSheet:Range(...

Hi, Its obvious that Xbase++ AutomationObject don't convert Xbase++ array to VB array in the right way. You can use the following manual algorithm for deleting duplicate rows on the first 2 columns, without RemoveDuplicates method. It will do the job as well. FOR I = 1 TO oRange:Rows:Count IF I = oR...