FiveTech Software tech support forums

... principles of relational-database programming. Another principle is to store each piece of data, only once. In the real-world, you are going find duplicate names--people, cities, items, etc. And you MUST be able to have more than one customer, city, or item with the same name(s). A unique numeric ...

... right ? oElementi:= TDatabase():Open( , cDir+"Elementi", "DBFCDX", .T. ) oElementi:setorder(1) oElementi:gotop() //sample for duplicate oElemento:=Editsetup(oElementi,3,oElemento) Function Editsetup(oDbf,nMode,oRec)    IF nMode==1  //add    ...

thanks

on tdatabase to inser ta a record I use

oElemento:=oElementi:record(.t.)

and to modify

oElemento:=oElementi:record()

How I can make to have a duplicate record to modify ?

Thanks for the observation. My client reported teh problem but I was able to duplicate it on my system. Also it works in some instances and not others.

We both are using Office 365, so Excel versions are the same, but different locations.

It is a duplicate ( copy without the text ) to show the difference F5 Añadir is missing. is added as PROMPT :!: REDEFINE BTNBMP oBtn1 ID 500 OF oDlg ; RESOURCE " TI_ANADIR " ACTION oDlg:End() REDEFINE BTNBMP oBtn2 ID ...

It is not a duplicate of viewtopic.php?f=3&t=37673 ?

Doing some fast testing, I can duplicate the behavior, I'm doing my test based on the idea of some kind of format being pasted to the get together with the text.... on different versions of FWH up to 12.04, and tested on an application compliled ...

... oserver:query("insert into ac (acid,currency) select '"+acid1+"',currency from currency limit 1 on duplicate key update descrip=descrip"),; if(MYSQL_AFFECTED_ROWS(oserver:nSocket)>0,(obrow2:otreeitem:add(acid1),obrow2:refresh()),)) MENUITEM ...

or including maybe the existing function BUILDFONT( aFont )

You can, If you like to duplicate the existing functionality.

... from the last of the same table +1 without using sysdbf.file and autoincremental class sample: at init IF nMode == 1 .or. nMode == 3 // add new or duplicate oCust: gobottom () CCLI: = StrZero (Val (oCust: NumCli) +1.4) else cCli: = oRec: numcli // modify endif dialog @ 12, 5 SAY "Code:" ...

... be a fraction of a second later ), gets the next number. With this being done thousands of times a day by my clients, we never have an issue with duplicate account numbers so I know it is safe. All of this discussion is about customer ID numbers, and unfortunately I still do not understand why ...

... from the last of the same table +1 without using sysdbf.file and autoincremental class sample: at init IF nMode == 1 .or. nMode == 3 // add new or duplicate oCust: gobottom () CCLI: = StrZero (Val (oCust: NumCli) +1.4) else cCli: = oRec: numcli // modify endif dialog @ 12, 5 SAY "Code:" ...

... for all the archives and to have different types of lengths for example 4-digit customers, 10-digit orders Nages on the test I add a new Method to duplicate a record ( seem run ok) I have implemented your requirements. This is the program to test. #include "fivewin.ch"REQUEST DBFCDXstatic ...