View Single Post

  #1 (permalink)  
Old 07-16-2003
Vincent BENNER's Avatar
Vincent BENNER Vincent BENNER is offline
Member
Yellow Belt
 
Join Date: Sep 2002
Posts: 44
I've got a problem when linking a dataset !

Hello,

I've created DataSet based on a requery witch is the following :
Num_FDT (primary key), ADRESS, ZIPCODE, CITY

When I display any of the matching pushpins, name of the
pushpin is the STREET !

Code:
    Dim objDS As MapPoint.DataSet
    Dim strXNC As String
    With Me.ctrlMP.ActiveMap.DataSets
        strcnx = gBDD_LOCAL & "!" & "ReqSQL"
        Set objDS = .LinkData(strcnx, "NUM_FDT", , geoCountryFrance, , geoImportAccessQuery)
        objDS.Symbol = 26
        arArray = Array(objDS.Fields(1), objDS.Fields(2), objDS.Fields(3), objDS.Fields(4))
        objDS.SetFieldsVisibleInBalloon arArray
    End With
How to set the primary key in the pushpin's name ?

It's very important because I've to use the .Find method...

King regards,

Vincent BENNER
Reply With Quote