Hi Roger,
Because I am using DBFCDX, I am interesting about it. Will be this on next update subscription (price ?) ? Or how can I examine it on future ?
Viktor
Search found 627 matches
- Wed Apr 10, 2024 6:31 am
- Forum: Did you Know?
- Topic: A web service for your data
- Replies: 14
- Views: 9739
- Mon Mar 04, 2024 3:18 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
Yes, i think about use HASH, but now works fine also with Var2Bin without problems. First I sort DBF to other temporary DBF, then in cycle delete sign duplicates, then delete it, and final i append to new database. When I use PACK, program often crashed, because I use append, with this eliminate del...
- Wed Feb 28, 2024 1:42 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
Hi Chris, At the beginning I have a DBF (Visual Foxpro structure) and later I generate XLSX from it I originally wanted to solve it through Excel, but I don't know because of the problem. I need to delete records that have the same 35 out of 36 fields. I wanted to avoid working with arrays because I...
- Tue Feb 27, 2024 8:09 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
My plan to sort records in DBF via INDEX UNIQUE failed because my index key is longer than 240 characters, I also tried Sort, it takes it, but again I would have to deal with comparing a lot of values (35 fields). I haven't tried the activeX SORT method yet because I'm very curious as to why RemoveD...
- Tue Feb 27, 2024 5:17 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
Ok, understand, thanks.
- Tue Feb 27, 2024 4:22 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
looks this not work as I want. duplicates can be in different places of the table, not only the following records. then if this can work, must first sort records. also work your example with "." and not only with ":" ? I modify this as here : FOR I = 1 TO oRange:Rows:Count IF I = oRange:Rows:Count E...
- Tue Feb 27, 2024 4:07 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
SlavkoDam :
thank you very much, I will try it.
Viktor
thank you very much, I will try it.
Viktor
- Tue Feb 27, 2024 3:03 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
Hi Jimmy, This syntax is not correct for Xbase++ ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes I tryed ActiveSheet.Range("A1:C100"):RemoveDuplicates(Columns:=Array(1,2), Header:=xlYes) but Xbase return Error Automation/6500 The parameter is incorrect. 0 Operation :...
- Mon Feb 26, 2024 2:39 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
everything looks to RemoveDuplicates(param1,param2) not accept param1 as Array, but only number of one column.
I do not understand why, or how syntax need use to process
I do not understand why, or how syntax need use to process
- Mon Feb 26, 2024 1:46 am
- Forum: eXpress++ Support
- Topic: Excel remove duplicates
- Replies: 16
- Views: 4693
Re: Excel remove duplicates
Hi, thanks for info, I tryed several versions of syntax but when I call RemoveDuplicates, get Error Automation/6500. Description : Invalid index, 0Error in array index Operation ? RemoveDuplicates for example : oUsedRange := oSheet:usedrange oUsedRange:RemoveDuplicates( {1, 2}, xlGuess ) oUsedRange:...