PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV 2024 → Insert or udate
Insert or udate
Started by marcov, Apr., 17 2024 10:50 AM - 2 replies
#1
Registered member
55 messages
Posted on April, 17 2024 - 10:50 AM
hi,
I have a procedure with 3 insert on duplicate key update queries, I would like to know in the second query whether a row has been inserted or just updating, is it possible?
thanks
#2
Registered member
80 messages
Posted on April, 21 2024 - 1:04 PM
HRecordDate (Function) should be your friend.

--
Ben Dell
Riebens Computers Pty Ltd
Southern Africa PcSoft Distributor
www.windevsa.co.za
PcSoft Sales, Support and Training
#3
Registered member
55 messages
Posted on April, 22 2024 - 10:09 AM
hi,

in relation I would like to understand if the last query made an insert or an update
→ Go back to WINDEV 2024