DK - SQL ADO/DBX Database Joining
	FAQ Feed

Q10270 -  How can I apply data in an external SQL database through the UID to present a Selection of objects. Simply select the shape by the UID. ... (Modified: 2007-01-30)

Q10255 -  Can I select a shape based on a query to the external database? Yes. Select a query in the external database and apply the join. The coverage will be limited to the shapes matching the query. ... (Modified: 2003-11-21)

Q10256 -  I have the same field names in my coverage and in my external database. How to distinguish between the two when setting up queries? When applying a query in your external database, use "SELECT field AS newname . to change the name. Otherwise, the field name in the layer always has priority. ... (Modified: 2003-11-21)

Q10269 -  Can I connect the Interbase 6.1 that I use with the TatukGIS? Yes. You can use ADO or DBX technology. ADO: Prepare and Open a Recordset sorted by the same paramter as the shapes in your layer. 1) Assign to Layer.JoinParimary a reference field name from the layer 2) Assign to Layer.JoinForeign an ide ... (Modified: 2003-11-21)

Q10257 -  I am setting up a project involving a city street map and a joined, external database. Which attribute information does it make better sense to record into the shape file, and which is better placed in the external database? Any vector attribute information that will influence the appearance of a ... (Modified: 2003-11-21)

Q10258 -  My ADO Join seems not to work. What can be wrong? Please review the following check-list. - Joining to the shape file to an external database requires a one-one relation. - Identifiers in a coverage must be unique, integer, and never empty. - It is recommended that a coverage be sorted by an identif ... (Modified: 2003-11-21)

Q10259 -  How can I construct an ADOJoin to an external attribute table and then programatically set up the renderer to render the shapes in a layer based on a value in a field in this table? Could you send me sample code to show me how? Sure: sqlDC : CreateOleObject(ADODB.Connection' sqlRS : CreateOleObject( ... (Modified: 2003-11-21)

Q10261 -  What is your level of db support? The reason I ask is: Your performance is so awesome that iterating through my ADO recordset (where I grab lats and longs) is now becoming a performance bottleneck. Does your db support somehow help with this issue? Do you know of anyway of getting around this by som ... (Modified: 2003-11-21)

Q10377 -  I want to show the user of my DK based application a selection list drawn up only from existing values in a database. How can this be done? There is no direct way to do this. If you are using SQL database, you can query for DISTINCT field values. If you are using a file based layer, you can use a ... (Modified: 2003-11-21)

Q10418 -  How can I open multiple ADO layers? How can I build a new ADO layer in code? I am developing an application using the DK-ActiveX with VB.NET. The only examples I can find for loading ADO layers is using the GIS.Open method and this will not allow more than one ADO layer to be opened at one time. I ... (Modified: 2003-11-21)

Q10599 -  How can I list all names of fields from a joined dataset? if Assigned( oLayer.JoinDB ) then begin for i:0 to oLayer.JoinDB.FieldCount-1 do begin name : oLayer.JoinDB.Fields[i]DisplayName ; . end ; end ; if Assigned( oLayer.JoinADO ) then begin for i:0 to oLayer.JoinADO.Fields.Count-1 do begin name ... (Modified: 2005-01-07)

Q10600 -  When joining a non-spatial relational database table to a spatial shape file using a 1-2-1 relationship and displaying the records of the joined shapes, how can I specify conditions on the records that are displayed? For example: (where Table1.area = 2.2 and Table1.location = 'New Zealand' This can ... (Modified: 2005-01-14)

Q10601 -  How can I use the DK to display the locations of coordinates stored in an Access database on a projected base map? Please refer to the DK ‘Join and Chart’ sample for guidance. If the coordinates are not in the same coordinate system as the map, you can reproject the coordinates, on-the-fly, to the ... (Modified: 2005-01-14)