Page 1 of 1

VPME 9.1 FIX: Data Sources functionality not working

PostPosted: Sun Jun 13, 2010 5:35 pm
by JessicaLawson
VPME 9.1 FIX: Data Sources functionality not working properly

Applies to: VPM Enterprise 9.1 through 9.1.12

Symptoms: The data entered on the Data Sources form for a Data Source is not used. This problem
doesn't affect views and cursoradapters that access SQL Server data since the default Data Source
values work properly for SQL Server.

Resolution: Make the following change to the InitializeProperties method of the VPMDataHandler class
in VPMDataHandler.vcx.

Change:

IF NOT This.IsEOF()
DIMENSION This.aDDDS[RECCOUNT(),FCOUNT()]
COPY TO ARRAY This.aDDDS
ENDIF

To:

slnRows = 0
SCAN
slnRows = slnRows+1
DIMENSION This.aDDDS[slnRows,9]
This.aDDDS[slnRows,1] = cPK
This.aDDDS[slnRows,2] = ALLTRIM(cName)
This.aDDDS[slnRows,3] = ALLTRIM(mBypassWildcard)
This.aDDDS[slnRows,4] = ALLTRIM(mBypass_cMax)
This.aDDDS[slnRows,5] = ALLTRIM(mBypass_cMin)
This.aDDDS[slnRows,6] = ALLTRIM(mBypass_dMax)
This.aDDDS[slnRows,7] = ALLTRIM(mBypass_dMin)
This.aDDDS[slnRows,8] = ALLTRIM(mBypass_nMax)
This.aDDDS[slnRows,9] = ALLTRIM(mBypass_nMin)
ENDSCAN