VPME 6.0b, VPMP 6.0b, VPMS 6.0b FIX: integer expression

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

VPME 6.0b, VPMP 6.0b, VPMS 6.0b FIX: integer expression

Postby JessicaLawson » Sun Jun 13, 2010 3:17 pm

Subject: VPME 6.0b, VPMP 6.0b, VPMS 6.0b FIX: Displaying a descriptive expression for an integer FK not working

Applies to: VPM Enterprise 6.0b, VPM Professional 6.0b, VPM Standard 6.0b

Symptoms: When displaying a descriptive expression in a textbox for an
integer FK field, the correct description from the lookup view is not
displayed. Displaying a descriptive expression for a FK is described in the
Setting Up a Field for Picklist Help Using a Textbox_ Control section of the
Building Data: Picklist Help chapter of the User's Guide.

Resolution: To fix this problem, make the following modifications in the
Refresh method of the Textbox_ class in the VPMCtrls class library.

1. Change:

_SCREEN.oApp.SetViewVariables(.F.,.T.,;
CURSORGETPROP('SourceType') = 2,CURSORGETPROP('SQL'))

To:

_SCREEN.oApp.SetViewVariables(.F.,.T.,;
CURSORGETPROP('SourceType') = 2,CURSORGETPROP('SQL'),;
slLookupValue)

2. Remove the line:

PKValue = slLookupValue
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 4 guests

cron