bb.donnay-software.com

Hi SlavkoDam, example : * close DBF if is open close TEMPVLA SELECT 24 use &nazovdbf24 ALIAS TEMPVLA EXCLUSIVE zap // here crashes pack // here also crashes set default to &cestatemp index on KN_CLV TAG CLV // doplnené 4.4.2017 aby bola zhoda ako pri bytoch index on KN_CLV*10000+KN_PCS TAG CVL // in...

Hi, it has nothing to do with eXpress++, rather Xbase++, but maybe somebody know about this. one of my clients complained that the program crashes when creating a statement. I found out that it happens when opening a DBF Visual Foxpro database and the command ZAP, or even PACK, the program completel...

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

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...

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...

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...

Ok, understand, thanks.

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...

SlavkoDam :
thank you very much, I will try it.
Viktor

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 :...