PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV Mobile 2024 → How Do I Create Composite Keys in Code?
How Do I Create Composite Keys in Code?
Started by Droogans, Aug., 18 2011 6:56 PM - 1 reply
#1
Registered member
25 messages
Posted on August, 18 2011 - 6:56 PM
I want to GENERATE a composite key in code as I search through my files in code.

I'm not BUILDING the contents of a composite key, that's simple. I want a brand new one, on the fly, based on two values in the same table that I select. In essence, I want to HReadSeek() on two values without making a composite key in the HFSQL analysis. That way, I can modify the members of a composite key willy-nilly, without creating 2^n additional fields in my tables. That would be ridiculous.

Is this possible? Thanks!

//Syntax: HCreateUK(TableName, NewComposKeyName, Field1, Field2 [, FieldN...])

HReadSeek(TableName, NewComposKeyName, ["FirstName", "LastName"])

//WinDev...What's in store in Ver17?
#2
Posted on August, 18 2011 - 7:42 PM
Hi Droogans

no it's not

Best regards

--
Fabrice Harari
International WinDev, WebDev, WinDev Mobile consulting
http://www.fabriceharari.com

On 18/08/2011 12:05, Droogans wrote:
I want to GENERATE a composite key in code as I search through my files in code.

I'm not BUILDING the contents of a composite key, that's simple. I want a brand new one, on the fly, based on two values in the same table that I select. In essence, I want to HReadSeek() on two values without making a composite key in the HFSQL analysis. That way, I can modify the members of a composite key willy-nilly, without creating 2^n additional fields in my tables. That would be ridiculous.

Is this possible? Thanks!

//Syntax: HCreateUK(TableName, NewComposKeyName, Field1, Field2 [, FieldN...])

HReadSeek(TableName, NewComposKeyName, ["FirstName", "LastName"])

//WinDev...What's in store in Ver17?

→ Go back to WINDEV Mobile 2024