SQL - Revision history

GomezL at 15:48, 23 May 2025

2025-05-23T15:48:50Z

@@ Line 2: / Line 2: @@
 ====CONFIG DATABASE db-ref ODBC-MANAGER====
-CONFIG [[DATABASE]] db-ref ODBC-MANAGER will invoke the ODBC Manager to define or identify a file DSN. Once this is done you can issue the command [[STATUS]] DATABASE –P to see the connect string that the ODBC Manager used to make the connection. Thereafter you can use that connect string to establish the connection to the database as follows:
+CONFIG [[DATABASE]] db-ref ODBC-MANAGER will invoke the ODBC Manager to define or identify a file DSN. Once this is done you can issue the command [[STATUS]] DATABASE –P to see the connect string that the ODBC Manager used to make the connection. Thereafter you can use that connection string to establish the connection to the database as follows:
   CONFIG DATABASE db-ref  CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)}DBQ=C:\inetpub\wwwroot\BegASP\Chapter.14\Contact.mdb"
@@ Line 157: / Line 157: @@
 ===Other===
 For more information about '''SQL''' or '''Structured Query Language''' see [[Wikipedia:SQL]].
 <noinclude>

Mikhail.zheleznov: Added example for SQL SELECT and INSERT statements processed by BR READ and WRITE statements

2017-04-25T15:47:47Z

Added example for SQL SELECT and INSERT statements processed by BR READ and WRITE statements

@@ Line 56: / Line 56: @@
 #Once SQL has been populated by an IOlist, it may be reused with the same values by issuing a WRITE with no IOlist.
 #READ IOlist variable associations are positional with each READ accessing one row of values.
 ===SQL Date Format Functions===

GomezL: /* SQL Date Format Functions */

2017-01-16T19:40:10Z

SQL Date Format Functions

← Older revision		Revision as of 19:40, 16 January 2017
Line 61:		Line 61:
	A$=SQL_DATE$(BR-date-string,"format-mask") ! format date for storage		A$=SQL_DATE$(BR-date-string,"format-mask") ! format date for storage
	B$=BR_DATE$(SQL-date-string,"format-mask") ! unpack DB date value		B$=BR_DATE$(SQL-date-string,"format-mask") ! unpack DB date value

			* Note: SQL DATETIME fields are "Packed for Storage", but "DATE" fields are returned as a CCYY-MM-DD string in a SQL Query. DATE returns "BLANK" for "Empty or Null Date"

	===SQL Table Interrogation===		===SQL Table Interrogation===

Laura: /* OPEN statements */

2015-10-05T20:52:10Z

OPEN statements

← Older revision		Revision as of 20:52, 5 October 2015
Line 46:		Line 46:
	OPEN #20: "DATABASE= db-ref, Name= filename" , SQL, OUTIN		OPEN #20: "DATABASE= db-ref, Name= filename" , SQL, OUTIN
	Where filename refers to a DISPLAY file containing a SQL statement that gets executed when a WRITE statement is processed.		Where filename refers to a DISPLAY file containing a SQL statement that gets executed when a WRITE statement is processed.

			Example:
			OPEN #20: "DATABASE=MyData",SQL "SELECT FILENO,BALANCE from MASTER WHERE FILENO=?",OUTIN

	====Sequence of Operations====		====Sequence of Operations====

Laura: /* CONFIG DATABASE db-ref ODBC-MANAGER */

2015-10-05T20:42:35Z

CONFIG DATABASE db-ref ODBC-MANAGER

← Older revision		Revision as of 20:42, 5 October 2015
Line 2:		Line 2:

	====CONFIG DATABASE db-ref ODBC-MANAGER====		====CONFIG DATABASE db-ref ODBC-MANAGER====
	CONFIG DATABASE db-ref ODBC-MANAGER will invoke the ODBC Manager to define or identify a file DSN. Once this is done you can issue the command [[STATUS]] DATABASE –P to see the connect string that the ODBC Manager used to make the connection. Thereafter you can use that connect string to establish the connection to the database as follows:		CONFIG [[DATABASE]] db-ref ODBC-MANAGER will invoke the ODBC Manager to define or identify a file DSN. Once this is done you can issue the command [[STATUS]] DATABASE –P to see the connect string that the ODBC Manager used to make the connection. Thereafter you can use that connect string to establish the connection to the database as follows:

	CONFIG DATABASE db-ref CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)}DBQ=C:\inetpub\wwwroot\BegASP\Chapter.14\Contact.mdb"		CONFIG DATABASE db-ref CONNECTSTRING="Driver={Microsoft Access Driver (*.mdb)}DBQ=C:\inetpub\wwwroot\BegASP\Chapter.14\Contact.mdb"

GomezL: /* CONFIG DATABASE db-ref ODBC-MANAGER */

2015-07-15T15:22:31Z

CONFIG DATABASE db-ref ODBC-MANAGER

@@ Line 20: / Line 20: @@
 ''''CONFIG DATABASE CLEAR   { db-ref | ALL }'''
 This will close the specified database or all open databases.
 ====OPEN statements====

Laura: /* SQL Table Interrogation */

2014-09-19T19:11:19Z

SQL Table Interrogation

← Older revision		Revision as of 19:11, 19 September 2014
Line 42:		Line 42:
	===SQL Table Interrogation===		===SQL Table Interrogation===

	[[ENV$(STATUS)]] has been extended to interrogate database connections and ODBC data sources. A program called ENVDB.BRS (listed below) has been written to demonstrate how this extension works and to show how to setup linkage to a database or ODBC data source. Run the program as is to bring up the Microsoft ODBC manager. Then select a data source and look at the output from the program. This will also show you how to get and use connect strings. In this example lines 1900 and 2000 accomplish the same open as line 1800 in my environment.		'''ENV$(STATUS)''' has been extended to interrogate database connections and ODBC data sources. A program called ENVDB.BRS (listed below) has been written to demonstrate how this extension works and to show how to setup linkage to a database or ODBC data source. Run the program as is to bring up the Microsoft ODBC manager. Then select a data source and look at the output from the program. This will also show you how to get and use connect strings. In this example lines 1900 and 2000 accomplish the same open as line 1800 in my environment.

	Try it on your Windows workstation. As long as you have one or more ODBC drivers supported you can use it without having to install a database. You can even use it to interrogate Excel files because Microsoft provides an ODBC driver for that.		Try it on your Windows workstation. As long as you have one or more ODBC drivers supported you can use it without having to install a database. You can even use it to interrogate Excel files because Microsoft provides an ODBC driver for that.

Laura at 19:10, 19 September 2014

2014-09-19T19:10:33Z

@@ Line 1: / Line 1: @@
-For information about '''SQL''' or '''Structured Query Language''' see [[Wikipedia:SQL]].
+SQL manages data via a relational data management system. As of 4.3, BR includes several special ways of working together with SQL.
 [[Category:Terminology]]
 [[Category:SQL]]

Laura: Created page with "For information about '''SQL''' or '''Structured Query Language''' see Wikipedia:SQL. Category:Terminology Category:Needs Help Category:SQL"

2013-07-15T20:36:39Z

Created page with "For information about '''SQL''' or '''Structured Query Language''' see Wikipedia:SQL. Category:Terminology Category:Needs Help Category:SQL"

New page

For information about '''SQL''' or '''Structured Query Language''' see [[Wikipedia:SQL]].

[[Category:Terminology]]
[[Category:Needs Help]]
[[Category:SQL]]