VPME 9.1 FIX: Candidate Key

The place where ProMatrix posts coding tips and fixes. Read only.

VPME 9.1 FIX: Candidate Key

Postby JessicaLawson » Sun Jun 13, 2010 5:18 pm

VPME 9.1 FIX: Candidate key is not saved properly for cursoradapter

Applies to: VPM Enterprise 9.1

Symptoms: When a candidate key is defined for a cursoradapter in the Data Builder, the definition is
not saved properly.

Resolution: Make the following change to the code in the Controls_To_Record method of the
CursorAdapter_Edit class in VPMDD.vcx.

Change:

REPLACE ddck_v.cPK WITH GenerateGUID(48),;
ddck_v.cFK_DDTV WITH ddtv_v.cPK,;
ddck_v.cFK_DDTV_View WITH SUBSTR(slcData,101,16),;
ddck_v.cDescription WITH LEFT(slcData,100),;
ddck_v.cViewVariable WITH SUBSTR(slcData,117,20),;
ddck_v.mExpression WITH SUBSTR(slcData,137)

To:

REPLACE ddck_v.cPK WITH GenerateGUID(48),;
ddck_v.cFK_DDTV WITH ddtv_v.cPK,;
ddck_v.cFK_DDTV_View WITH ThisForm.aCKViews[VAL(SUBSTR(slcData,101,4)),2],;
ddck_v.cDescription WITH LEFT(slcData,100),;
ddck_v.cViewVariable WITH SUBSTR(slcData,105,20),;
ddck_v.mExpression WITH SUBSTR(slcData,125)
JessicaLawson
 
Posts: 79
Joined: Sun Jun 13, 2010 1:23 pm

Return to ProMatrix Library

Who is online

Users browsing this forum: No registered users and 1 guest

cron