Search found 86 matches

by SlavkoDam
Mon Mar 11, 2024 2:10 am
Forum: Xbase++ 2.0
Topic: Listbox colours
Replies: 8
Views: 1021

Re: Listbox colours

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 ...
by SlavkoDam
Mon Mar 11, 2024 12:57 am
Forum: Xbase++ 2.0
Topic: Listbox colours
Replies: 8
Views: 1021

Re: Listbox colours

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...
by SlavkoDam
Wed Feb 28, 2024 6:14 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 1513

Re: Excel remove duplicates

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...
by SlavkoDam
Tue Feb 27, 2024 4:49 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 1513

Re: Excel remove duplicates

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(...
by SlavkoDam
Tue Feb 27, 2024 3:59 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 1513

Re: Excel remove duplicates

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...
by SlavkoDam
Sun Feb 25, 2024 4:34 am
Forum: eXpress++ Support
Topic: DCBROWSECOL ... HIDE
Replies: 8
Views: 1661

Re: DCBROWSECOL ... HIDE

Hi Cris,

I am interested did you try my code and does it work well?
by SlavkoDam
Sun Feb 25, 2024 4:27 am
Forum: eXpress++ Support
Topic: Excel remove duplicates
Replies: 16
Views: 1513

Re: Excel remove duplicates

Hi, As you know, you cannot use syntax you tried from Internet, because its VB syntax and not Xbase++ syntax. For Xbase++ syntax you have to read Xbase++ AutomationObject() class documentation. I send you attached MS VBA documentation for Excel 2010, and a program to install to open that file type. ...
by SlavkoDam
Tue Feb 13, 2024 2:43 am
Forum: eXpress++ Support
Topic: DCBROWSECOL ... HIDE
Replies: 8
Views: 1661

Re: DCBROWSECOL ... HIDE

Hi, This is a code from my library PowerWin for hide/show a browse column. You can use it for free. It is simple, elegant, efficient and makes no flickers on the screen. To understand the code, you should read the XbpBrowse() source code in SOURCE\RUNTIME\DUI. This is the right way how to do that ta...
by SlavkoDam
Mon Feb 05, 2024 12:52 am
Forum: eXpress++ Support
Topic: ARTIFICIAL INTELLIGENCE (AI)
Replies: 9
Views: 1678

Re: ARTIFICIAL INTELLIGENCE (AI)

Hi, An example of AI project developed in Xbase++ is the AIDOS system created by professor Eugene Lutsenko. Its purpose is Cognitive Analytics/Analysis, which applies human like intelligence to certain tasks. In its work, Cognitive Analytics combines Artificial Intelligence and Data Analytics. By de...
by SlavkoDam
Wed Dec 20, 2023 12:04 am
Forum: CXP / Web Development
Topic: PowerWeb app example - Article Codebook with 1.000.000 Recs (Part 6)
Replies: 10
Views: 5858

Re: PowerWeb app example - Article Codebook with 1.000.000 Recs (Part 6)

Hi, I created a new version of the Article Codebook application. In the previous version I used SET FILTER for searching, because Slobodan used that method in his desktop version of the program. In the new version I used ISAM and SET RELATION. Now, the results are retrieved much faster and their is ...