Database - Revision history

ANK: /* dBase */

2021-12-07T08:27:50Z

dBase

← Older revision		Revision as of 10:27, 7 December 2021
Line 76:		Line 76:


	[[File:Hint.jpg\|hint]] If you do not have installed the '''Borland Database Engine''' (BDE), only filenames with less than 8 characters are allowed (Example: 'test5678.dbf'). Click the '''[[Map#Map_Information\|Map Information]]''' command in the '''[[Map]]''' menu to see, if the '''Borland Database Engine''' is installed or not. It can be downloaded ~~from the internet for free~~.		[[File:Hint.jpg\|hint]] If you do not have installed the '''Borland Database Engine''' (BDE), only filenames with less than 8 characters are allowed (Example: 'test5678.dbf'). Click the '''[[Map#Map_Information\|Map Information]]''' command in the '''[[Map]]''' menu to see, if the '''Borland Database Engine''' is installed or not. It can be downloaded [http://www.ocad.com/download/bde.exe here].

	===Remove===		===Remove===

ANK: /* Database Compatibility */

2020-04-01T11:49:23Z

Database Compatibility

← Older revision		Revision as of 13:49, 1 April 2020
Line 408:		Line 408:

	==Database Compatibility==		==Database Compatibility==
	OCAD checks the compatibility of the dataset. OCAD ~~2019~~ exists in a 32 bit and 64 bit version.		OCAD checks the compatibility of the dataset. OCAD exists in a 32 bit and 64 bit version.

	===Mircosoft Excel/Access===		===Mircosoft Excel/Access===

ANK: /* Database Box File:Space.PNGThis function is available in OCAD Mapping Solution.|link=https://www.ocad.com/en/products/ocad-for-cartography */

2019-08-20T08:08:58Z

Database Box File:Space.PNGThis function is available in OCAD Mapping Solution.|link=https://www.ocad.com/en/products/ocad-for-cartography

← Older revision		Revision as of 10:08, 20 August 2019
Line 163:		Line 163:

	To link an object:		To link an object:
	# Select the object which you want to link to a record.		# Select the object which you want to link to a record. (Note: To select an object, it must not be protected or hidden.)
	# Click the '''Link''' button in the '''Database Box'''.		# Click the '''Link''' button in the '''Database Box'''.
	# The '''Link Object''' dialog appears.		# The '''Link Object''' dialog appears.

ANK: /* Create Objects from Database Records File:Space.PNGThis function is available in OCAD Mapping Solution.|link=https://www.ocad.com/en/products/ocad-for-cartography */

2019-04-12T07:03:30Z

Create Objects from Database Records File:Space.PNGThis function is available in OCAD Mapping Solution.|link=https://www.ocad.com/en/products/ocad-for-cartography

← Older revision		Revision as of 09:03, 12 April 2019
Line 252:		Line 252:
	#: [[File:CreateObjectsFromTable.PNG]]		#: [[File:CreateObjectsFromTable.PNG]]
	# Select the dataset which contains the information the object is to be created with.		# Select the dataset which contains the information the object is to be created with.
	# Select the field for the '''Easting''' and '''Northing''' which determines the position of the new object.<br> If the dataset is a line text object with two points (P1,P2), P1 has the coordinates of the Easting and Northing fields. The length of the line text is added to the P2 easting coordinate.		# Select the field for the '''Easting''' and '''Northing''' which determines the position of the new object.<br>
	# Choose between '''m''' and '''km''' as a unit of measure.		If the dataset is a line text object with two points (P1,P2), P1 has the coordinates of the Easting and Northing fields. The length of the line text is added to the P2 easting coordinate.
			# Choose between '''m''', '''km''' and '''deg''' as a unit of measure.
	# If a text symbol was selected in the beginning, you have to select a text field. The content of the text field is used as the text of the OCAD object.		# If a text symbol was selected in the beginning, you have to select a text field. The content of the text field is used as the text of the OCAD object.
	# Enter a condition. This condition must be an '''SQL statement''': FIELDNAME OPERATOR VALUE (Examples: SIZE > 500, City='Baar'). If this field is empty, all records in the table get an object on the map.		# Enter a condition. This condition must be an '''SQL statement''': FIELDNAME OPERATOR VALUE (Examples: SIZE > 500, City='Baar'). If this field is empty, all records in the table get an object on the map.

ANK at 08:54, 31 January 2019

2019-01-31T08:54:23Z

← Older revision		Revision as of 10:54, 31 January 2019
Line 416:		Line 416:
	----		----
	Back to [[Main Page]]		Back to [[Main Page]]

	~~Previous Chapter: [[GPS]]~~

	~~Next Chapter: [[Thematic Map]]~~

ANK at 08:30, 31 January 2019

2019-01-31T08:30:11Z

← Older revision		Revision as of 10:30, 31 January 2019
Line 407:		Line 407:

	==Database Compatibility==		==Database Compatibility==
	OCAD checks the compatibility of the dataset. OCAD ~~2018~~ exists in a 32 bit and 64 bit version.		OCAD checks the compatibility of the dataset. OCAD 2019 exists in a 32 bit and 64 bit version.

	===Mircosoft Excel/Access===		===Mircosoft Excel/Access===

KLH: /* Relink */

2018-07-04T05:51:13Z

Relink

← Older revision		Revision as of 07:51, 4 July 2018
Line 100:		Line 100:
	===Relink===		===Relink===
	This function allows you to change the directory of your datasets.<br>		This function allows you to change the directory of your datasets.<br>
	[[File:Relink.PNG]]		[[File:Relink.PNG]]<br>
			* All dataset pathes from the '''Old directory''' are relinked to the '''New directory'''.
			* Dataset pathes that are different from the '''Old directory''' are ''not'' changed.

	===View and edit table===		===View and edit table===

ANK at 13:49, 7 March 2018

2018-03-07T13:49:33Z

Show changes

ANK: /* Select Linked Objects File:Space.PNGThis function is available in OCAD 12 Professional.|link=https://www.ocad.com/en/products/ocad-for-cartography */

2017-11-30T13:32:20Z

Select Linked Objects File:Space.PNGThis function is available in OCAD 12 Professional.|link=https://www.ocad.com/en/products/ocad-for-cartography

← Older revision		Revision as of 15:32, 30 November 2017
Line 328:		Line 328:

	==Select Linked Objects [[File:Space.PNG]][[File:Pro40px.PNG\|This function is available in OCAD 12 Professional.\|link=https://www.ocad.com/en/products/ocad-for-cartography]]==		==Select Linked Objects [[File:Space.PNG]][[File:Pro40px.PNG\|This function is available in OCAD 12 Professional.\|link=https://www.ocad.com/en/products/ocad-for-cartography]]==
	===Select Objects with Database Record Links===		===Select Objects with Good Database Record Links===
	Choose this function in the '''Database''' menu to select all objects with a link to an existing record.		Choose this function in the '''Database''' menu to select all objects with a link to an existing record.

	===Select Objects with Broken Database Record Links===		===Select Objects with Broken Database Record Links===
	Choose this function in the '''Database''' menu to select all objects which are linked to a record but the record was not found.		Choose this function in the '''Database''' menu to select all objects which are linked to a record but the record was not found.

GRS: /* Set Object Direction from Database Records File:Space.PNGThis function is available in OCAD 12 Professional.|link=https://www.ocad.com/en/products/ocad-for-cartography */

2016-10-18T13:19:01Z

Set Object Direction from Database Records File:Space.PNGThis function is available in OCAD 12 Professional.|link=https://www.ocad.com/en/products/ocad-for-cartography

← Older revision		Revision as of 15:19, 18 October 2016
Line 302:		Line 302:
	With this function the object direction can be defined by an angle (in degrees) from a field of the database.		With this function the object direction can be defined by an angle (in degrees) from a field of the database.

	Choose the '''Define Object Directions from Database Records''' command from the '''Database''' menu. A dialog appears. Choose a '''Dataset''' in the dropdown list or check the '''All''' option to take all datasets into consideration. The define the '''Angle field'''. Click the '''OK''' button when finished.		Choose the '''Define Object Directions from Database Records''' command from the '''Database''' menu. A dialog appears. Choose a '''Dataset''' in the dropdown list or check the '''All''' option to take all datasets into consideration. The define the '''Angle field'''.

			'''Mathematical function:''' Optionally you can define a mathematical function. To convert Radians to Degrees enter ''*180/3.14159''.

			Click the '''OK''' button when finished.

	The following things are rotated according to the angle field:		The following things are rotated according to the angle field: