-
Christian Breu
- as Valentina DB Server
- Wednesday, March 27 2019, 11:08 PM
- Subscribe via email
[How] is it possible to just update existing records while using vCursor.importText()?
Comment
There are no comments made yet.
Christian Breu
Accepted Answer
Sergey Pashkov
Accepted Answer
Christian Breu
Accepted Answer
Sergey Pashkov
Accepted Answer
Christian Breu
Accepted Answer
Christian Breu
Accepted Answer
Hello Sergey
Have to reactivate this thread...
Trying to use Merge but it does not work as I am expecting.
The sample from Wiki does not work – using dot-notation for fields is throwing errors!?
Found a sample from Ruslan that works but it is too simple.
this works without throwing an error:
this is throwing an error:
this works without throwing an error:
**********************************************************
I want to do anything like this:
and a second one to delete:
What did I misunderstand?
How to make it work?
Best regards.
Chris
Have to reactivate this thread...
Trying to use Merge but it does not work as I am expecting.
The sample from Wiki does not work – using dot-notation for fields is throwing errors!?
Found a sample from Ruslan that works but it is too simple.
this works without throwing an error:
MERGE main as mtarget
USING imp as isource ON (isource.artikelnummer = mtarget.artikelnummer)
WHEN MATCHED THEN
UPDATE SET name = isource.name
this is throwing an error:
MERGE main as mtarget
USING imp as isource ON (isource.artikelnummer = mtarget.artikelnummer AND isource.barcode = mtarget.barcode)
WHEN MATCHED THEN
UPDATE SET name = isource.name
this works without throwing an error:
MERGE main as mtarget
USING imp as isource ON (isource.artikelnummer = mtarget.artikelnummer AND isource.barcode <> mtarget.barcode)
WHEN MATCHED THEN
UPDATE SET name = isource.name
**********************************************************
I want to do anything like this:
MERGE main as mtarget
USING imp as isource ON (isource.artikelnummer = mtarget.artikelnummer AND isource.barcode = mtarget.barcode)
WHEN NOT MATCHED BY TARGET THEN
INSERT(artikelnummer, barcode, name) VALUES(isource.artikelnummer, isource.barcode, isource.name)
WHEN MATCHED THEN
UPDATE SET mtarget.name = isource.name
and a second one to delete:
MERGE main as mtarget
USING imp as isource
ON (isource.artikelnummer = mtarget.artikelnummer and isource.barcode = mtarget.barcode AND remove = 1)
WHEN MATCHED THEN
DELETE
What did I misunderstand?
How to make it work?
Best regards.
Chris
Christian Breu
Accepted Answer
Sergey Pashkov
Accepted Answer
Christian Breu
Accepted Answer
Hi Sergey
A full implementation of Merge, to work as expected, would be great – save my day...
...and a reason for my customer to update to the latest version of VServer.
Thank you for support.
Best regards.
Chris
A full implementation of Merge, to work as expected, would be great – save my day...
...and a reason for my customer to update to the latest version of VServer.
Thank you for support.
Best regards.
Chris
Christian Breu
Accepted Answer
Sergey Pashkov
Accepted Answer
Christian Breu
Accepted Answer
Christian Breu
Accepted Answer
François Van Lerberghe
Accepted Answer
Ruslan Zasukhin
Accepted Answer
Christian Breu
Accepted Answer
Ruslan Zasukhin
Accepted Answer
Christian Breu
Accepted Answer
Christian Breu
Accepted Answer
Ivan Smahin
Accepted Answer
- Page :
- 1
- 2
There are no replies made for this post yet.
However, you are not allowed to reply to this post.
However, you are not allowed to reply to this post.