Data Link (Join Fields?)

Permanently deleted user

04 Januari 2012 06:35

Hi all,

I'm a bit puzzled what fields are used for a data link?  I wasn't ask to specify the join fields. 

Can anyone shed some light on this for me?  Where and how are the join fields determined?

I was able to "TEST" successfully for data connection and the data link was successful as well.

ken

 

0

• 

  Permanently deleted user

  04 Januari 2012 07:37

  The join field is specified by the SELECT statement used. For example, in our Charlotte demo site there is a 1:M datalink configured by this statement:

  SELECT PROJECT, STATE_ID, PROJ_ADD AS [Project Address], PROJ_CTY AS [City], PROJ_ZIP AS [Zip Code], START_DATE, END_DATE FROM PROJECTS WHERE PROJ_ZIP = ?

  In this case the ? is a parameter that is set to be equal to the ZIP field in the Zip Codes layer. So the join field in the database is 'PROJ_ZIP', which corresponds to 'ZIP' in the spatial data, ie: WHERE PROJ_ZIP = ZIP.

  0
• 

  Permanently deleted user

  04 Januari 2012 08:08

  Thx I get it.

   

   

   

  0

Du måste logga in om du vill lämna en kommentar.