Rank: Newbie
Posts: 1 
|
Hi please how I can tell the tool, that for same data sets I don't want a new one. The system should update the old one. I use an autonumbers on the MySQL database. his number is then part of other tables. So the program shout seperate this. If on Update is required instead a new record could normaly be findout bey the Index or ID of the dataset. Is there non, the dataset is new, is thre a number, the dataset exists and needs to be updated. I know this, but hoe to tell this the tool ???? Thanks for the help in advance [cool] Bodo Edited by user Tuesday, July 17, 2012 8:30:37 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Posts: 42
|
Originally Posted by: Bodo  Hi
please how I can tell the tool, that for same data sets I don't want a new one. The system should update the old one. I use an autonumbers on the MySQL database. his number is then part of other tables. So the program shout seperate this. If on Update is required instead a new record could normaly be findout bey the Index or ID of the dataset. Is there non, the dataset is new, is thre a number, the dataset exists and needs to be updated.
I know this, but hoe to tell this the tool ????
Thanks for the help in advance [cool]
Bodo Hi Bodo, I think you could do this by using the Custom SQL feature. You will need a column in your Task that is unique, customer_code for example. Code:
IF (SELECT COUNT(*) FROM tbl_name WHERE customer_code ='{XL-merge:Customer_code}' > 0)
THEN UPDATE tbl_name SET ..your values.. WHERE customer_code = '{XL-merge:Customer_code}'
ELSE
INSERT INTO tbl_name ..your values..
END IF
If you post your table details we may be able to help some more...
|
|
|
|
|
|
Rank: Administration
Posts: 42
|
Hi Bodo,
It is interesting you are using MySQL.
We will be supporting MySQL stored procedures in the next major release.
The logic decision to insert or update could then be placed within a stored procedure.
Regards
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.