MySQL - Revision history

Thomas Linder Puls: connect string

2016-10-27T20:31:43Z

connect string

← Older revision		Revision as of 22:31, 27 October 2016
Line 84:		Line 84:
	test():-		test():-
	Connection = odbcConnection::new(256),		Connection = odbcConnection::new(256),
	ConStr = @"DSN=myodbc;"		ConStr = @"DSN=myodbc;UID=root;PW=scott;",
	@"UID=root;"
	@"PW=scott;",
	if X = Connection:driverConnect(This:getVpiWindow(), ConStr, odbc_native::sql_driver_noprompt) then		if X = Connection:driverConnect(This:getVpiWindow(), ConStr, odbc_native::sql_driver_noprompt) then
	% OR USE		% OR USE

2016-10-27T20:30:55Z

Using MySQL in a Visual Prolog project: age is int, driver

← Older revision		Revision as of 22:30, 27 October 2016
Line 19:		Line 19:

	Go to ''Control Panel - Performance and Maintenance - Administrative Tools - Data Sources (ODBC)''		Go to ''Control Panel - Performance and Maintenance - Administrative Tools - Data Sources (ODBC)''
	Under the dialog tab ''User DSN'', press ADD, select the ''MySQL ODBC Driver'' ~~(probably version 3.51)~~.		Under the dialog tab ''User DSN'', press ADD, select the ''MySQL ODBC X.Y Unicode Driver''.

	In the dialog, enter the following:		In the dialog, enter the following:

2016-10-27T20:29:34Z

Using MySQL in a Visual Prolog project: age is int

← Older revision		Revision as of 22:29, 27 October 2016
Line 93:		Line 93:
	Stmt = odbcStatement::new(Connection),		Stmt = odbcStatement::new(Connection),
	try		try
	Stmt:execDirect("INSERT INTO person VALUES ('harrypotter','4')"),		Stmt:execDirect("INSERT INTO person VALUES ('harrypotter',4)"),
	look(Stmt)		look(Stmt)
	finally		finally

2008-10-29T20:54:16Z

Categorized

← Older revision		Revision as of 22:54, 29 October 2008
Line 119:		Line 119:

	Notice that it is very important to "free" <vp>odbcStatements</vp>; failing to do this will sooner or later result in program breakdown. Therefore the "free" is placed inside a try-finally construction, so that it is also freed in case of exceptions.		Notice that it is very important to "free" <vp>odbcStatements</vp>; failing to do this will sooner or later result in program breakdown. Therefore the "free" is placed inside a try-finally construction, so that it is also freed in case of exceptions.

			[[Category:ODBC]]

2008-09-26T14:01:44Z

spelling

← Older revision		Revision as of 16:01, 26 September 2008
Line 118:		Line 118:
	Stmt:closeCursor().</vip>		Stmt:closeCursor().</vip>

	Notice that it is very important to "free" <vp>odbcStatements</vp>, failing to do this will sooner or later result in program breakdown. Therefore the "free" is placed inside a try-finally construction, so that ~~the~~ it is also ~~free'ed~~ in case of exceptions.		Notice that it is very important to "free" <vp>odbcStatements</vp>; failing to do this will sooner or later result in program breakdown. Therefore the "free" is placed inside a try-finally construction, so that it is also freed in case of exceptions.

2008-09-26T13:40:55Z

Using MySQL in a Visual Prolog project: Importance of odbcStatement::free

← Older revision		Revision as of 15:40, 26 September 2008
Line 117:		Line 117:
	end foreach,		end foreach,
	Stmt:closeCursor().</vip>		Stmt:closeCursor().</vip>

			Notice that it is very important to "free" <vp>odbcStatements</vp>, failing to do this will sooner or later result in program breakdown. Therefore the "free" is placed inside a try-finally construction, so that the it is also free'ed in case of exceptions.

2008-09-26T13:31:07Z

Example of using MySQL in a project: Section title

← Older revision		Revision as of 15:31, 26 September 2008
Line 73:		Line 73:
	*Enter "quit".		*Enter "quit".

	=== ~~Example of using~~ MySQL in a project ===		=== Using MySQL in a Visual Prolog project ===

	Create a new VIP GUI project, and cut and paste the following code into taskwindow.pro, and (e.g.) call predicate test:() from File-New.		Create a new VIP GUI project, and cut and paste the following code into taskwindow.pro, and (e.g.) call predicate test:() from File-New.

2008-09-26T13:30:10Z

Test the database with the Command Line Client: Title

← Older revision		Revision as of 15:30, 26 September 2008
Line 46:		Line 46:
	Press the TEST button - it should connect.		Press the TEST button - it should connect.

	=== ~~Test the~~ database with the Command Line Client ===		=== Create a database with the Command Line Client ===

	From the ''Start-All Programs-MySQL'' menu, start the command line client.		From the ''Start-All Programs-MySQL'' menu, start the command line client.

2008-09-26T13:29:20Z

Test the database with the Command Line Client: formatting

← Older revision		Revision as of 15:29, 26 September 2008
Line 48:		Line 48:
	=== Test the database with the Command Line Client ===		=== Test the database with the Command Line Client ===

	From the ''Start-All Programs-MySQL'' menu, start the command line client. ~~Enter the password at the prompt. The prompt should now be: '''mysql>'''~~		From the ''Start-All Programs-MySQL'' menu, start the command line client.

	*Enter "show databases;" (without the quotes, but with the semi-colon), and database "fred" should be listed.		* Enter the password at the prompt. The prompt should now be: '''mysql>'''
	*Enter "use fred"		* Enter "show databases;" (without the quotes, but with the semi-colon), and database "fred" should be listed.
			* Enter "use fred"

	Now create a table called "person" in "fred":		Now create a table called "person" in "fred":

	*Enter "create table person (name varchar(20), age integer);"		* Enter "create table person (name varchar(20), age integer);"
	*Enter "show tables;" (remember the semi-colons)		* Enter "show tables;" (remember the semi-colons)

	Enter some data into the table:		Enter some data into the table:

	*Enter "insert into person values('fred','87');"		* Enter "insert into person values('fred','87');"

	And then check the data is there:		And then check the data is there:

	Enter "select from person;"		* Enter "select * from person;"

	and the data should be listed.		and the data should be listed.

2008-09-26T13:28:04Z

Create an ODBC Datasource: Use table

← Older revision		Revision as of 15:28, 26 September 2008
Line 23:		Line 23:
	In the dialog, enter the following:		In the dialog, enter the following:

	*'''Data Source Name''': myodbc		{\|{{prettytable}}
	*'''Description''': a test		\|-
	*'''Server''': localhost		\| '''Data Source Name'''
	*'''User''': root		\| myodbc
	*'''Password''': scott (the password you entered for the server in step 2 above)		\|-
	*'''Database''': fred		\|'''Description'''
			\| a test
			\|-
			\| '''Server'''
			\| localhost
			\|-
			\| '''User'''
			\| root
			\|-
			\| '''Password'''
			\| scott (the password you entered for the server in step 2 above)
			\|-
			\| '''Database'''
			\| fred
			\|}

	Press the TEST button - it should connect.		Press the TEST button - it should connect.