Welcome! Log In Create A New Profile

Advanced

[WD23] Composite Key

Posted by infos 
Forum List Message List New Topic
infos
[WD23] Composite Key
January 15, 2021 10:01AM
Hello everyone

How to set the syntax for a composite key table correctly, the syntax below does not work 

// CompKey - Composite Key

HReadSeek(CUSTOMER, CompKey, "VALUE1"+"VALUE2")
IF HFound() THEN
    ...
    HModify(CUSTOMER)
ELSE
    ...
    HAdd(CUSTOMER)
END

[infosonline.net]
Reply Quote
PeHoBe
Re: [WD23] Composite Key
January 15, 2021 10:08AM
Hi

hBuildKeyValue is your friend...
RTFM: https://doc.windev.com/en-US/?3044258&name=hconstruitvalcle_fonction

Cheers

Peter H.
Reply Quote
pao
Re: [WD23] Composite Key
January 15, 2021 10:09AM
Sample from the help:
HReadSeek(<File name>, <Name of composite key>,
[<Search value of first element of composite key>,
<Search value of first element of composite key>, ...])

[doc.windev.com]

Regards

Paulo Oliveira
Reply Quote
slxslx
Re: [WD23] Composite Key
January 15, 2021 05:51PM
Hi, 

HReadSeek(CUSTOMER, CompKey, ["VALUE1","VALUE2"])

BR,
Alen
Reply Quote
infos
Re: [WD23] Composite Key
January 15, 2021 06:34PM
Thanks everyone

[infosonline.net]
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: