Open View with Numeric PK Issue

The place for peer-to-peer support for developing client-server applications with VPME 9.1.

Open View with Numeric PK Issue

Postby wftdata » Wed Jan 10, 2018 11:54 pm

Hi,

I am going crazy wondering why this Open View doesn't work in my Find Form I created. The PK is Numeric. I defined the filters correctly using nFileNo >= ?PKValue_nMin AND nFileNo <= ?PKValue_nMax in the DD. I only get one record, the _nMax Value! It works fine when using the default SQL Find Form.

DIMENSION slaFilterVariables[2,2]
slaFilterVariables[1,1] = 'PKValue_nMin'
slaFilterVariables[1,2] = ThisForm.txt_FileNo1.Value
slaFilterVariables[2,1] = 'PKValue_nMax'
slaFilterVariables[2,2] = ThisForm.txt_FileNo2.Value
ThisForm.oVPMDataHandler.OpenView('Statmain_lv','FOREC_V',@slaFilterVariables)

Anyone have any ideas why this is happening?

*** I seemed to fix this issue.....used FINDnFileNo and it worked. What I noticed is that when I list the FIND Fields on my form, it doesn't filter out the blank entries as the SQL Find Form does! It Doesn't use the Data Sources ByPass.

Does anyone know why???

Thanks.
wftdata
 
Posts: 92
Joined: Thu Jun 23, 2011 8:42 pm
Location: East Moriches, NY 11940

Return to VPM Enterprise 9.1 - Client Server

Who is online

Users browsing this forum: No registered users and 1 guest

cron