FiveTech Software tech support forums

... we can use METHODS InsertSQL(), ReplaceSQL(). Insert() method is very efficient and can handle multiple row inserts as well as update on duplicates. Even experts should find these methods very useful. TRANSACTION SUPPORT // ADO CompatibilityMETHOD BeginTrans          INLINE ::BeginTransaction()METHOD ...

... were NOT guaranteed to be unique. As I understand it, they just have a very low probability of collision. Isn't that why you have to check for duplicates before you use them? And I don't really understand what the advantage of a GUID is over a sequential number? I'm sure there is one, I just ...

... key and it works only rarely. I try typing into prg and it either doesn't type anything or it types 1 character and then the next letter I type it duplicates the previous letter and duplicates letter I just pressed. This is on more than 1 phone. That makes it very hard to change any code on phone. ...

I am having major problems building anything with the build 2 update, whether i try to use it with 2013 or 2015 RC. Lots of duplicates and various issues, all similar to what we dealt with previously when moving to 2013, I have neither the time nor the will to work through them right ...

Mr Leandro Reason for getting duplicates: Your SQL Statement: SELECT A.*,B.*,C.* FROM TABLA_MOVIMIENTO A LEFT JOIN TABLA_CLIENTES B ON A.id_cliente=B.id_cliente  LEFT JOIN TABLA_EMPRESAS C ON A.id_empresa=C.id_empresa WHERE A.tipocliente='C'  ...

... adjacent duplicate characters. I took Elvira's statement to mean that he want to remove all spaces, but I admit it is not clear. Removing adjacent duplicates is a different task.

... functions of CT are highly optimized functions. Full syntax: CHARONE( [cDelete], cString ) Ex: CharOne( " *-", cStrings ) removes all duplicates of ' ', '*', '-' in one single call. Where I can find this function?

... functions of CT are highly optimized functions. Full syntax: CHARONE( [cDelete], cString ) Ex: CharOne( " *-", cStrings ) removes all duplicates of ' ', '*', '-' in one single call.

Colin,

Smart indenting already implemented

James,

On preferences dialogbox new "Duplicates on functions panel" checkbox to remove duplicates

https://bitbucket.org/fivetech/fivewin-contributions/downloads/fivedit.zip

André,

thanks!

For other contributors, please use this order:

{ ENGLISH, SPANISH, FRENCH, GERMAN, PORTUGUESE, ITALIAN },;

Duplicates are not intented but they will not break our app (this is good from FWH strings API), anyhow lets remove them

... that just adds new records to the customer file. Then run two or more copies of this program across the LAN for a few minutes, then check for duplicates. James Thanks James. In my pc with 2 copies of my program runs ok, not duplicated but the case occurs in my customer with windows xp and ...

Wanderson,

May I also suggest writing a small sample program that just adds new records to the customer file. Then run two or more copies of this program across the LAN for a few minutes, then check for duplicates.

James

... had a corrupted file cause a problem with this method. GO BOTTOM did not actually go to the bottom but to the middle and I ended up with lots of duplicates. I have been using a separate file with just one last used ID field (as Wanderson is doing) for many years without any problems. James

... (your sample code does not show the field CODIGO)? I have found that you cannot use the database to keep track of the last used ID as you will get duplicates due to index problems (corruption, not the current index, etc). I use a separate database to keep track of the last used ID. James Hi Jame, ...

... (your sample code does not show the field CODIGO)? I have found that you cannot use the database to keep track of the last used ID as you will get duplicates due to index problems (corruption, not the current index, etc). I use a separate database to keep track of the last used ID. James