2009 spring conference luis i gomez sqlisam exe provided by mills enterprise n.
Skip this Video
Loading SlideShow in 5 Seconds..
SQLISAM.EXE USING SQL DATA SOURCES in BR PowerPoint Presentation
Download Presentation
SQLISAM.EXE USING SQL DATA SOURCES in BR

Loading in 2 Seconds...

  share
play fullscreen
1 / 13
Download Presentation

SQLISAM.EXE USING SQL DATA SOURCES in BR - PowerPoint PPT Presentation

ranee
105 Views
Download Presentation

SQLISAM.EXE USING SQL DATA SOURCES in BR

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. 2009 Spring Conference Luis I. Gomez SQLISAM.EXE provided by Mills Enterprise SQLISAM.EXEUSING SQL DATA SOURCES in BR

  2. Using SQL Data Sources in BR • ODBC and DSN data sources • SQL - What is it? • Northwind.mdb • Practical application “Custom Request” • SQLISAM.exe – What is it? • CONTEXT.wb – What is it? • Solution using BR and SQLISAM

  3. ODBC and DSN Data Sources • What is it? • (O)pen (D)ata(B)ase (C)onnectivity • Interface provided by MS Windows • Provides connectivity to many database engines • MS Access • SQL Server , Oracle • MySql, Firebird and many others • (D)atabase (S)ource (N)ame • The actual configuration mechanism in MS Windows • User DSN • System DSN

  4. SQL - What is it? • Structured Query Language • Set of commands used to use a database • Examples: • Select CustomerID, CompanyName, Phone, Country, PostalCodefrom Customers • Select CustomerID, Freight, ExtendedPrice, Productname, OrderID, OrderDate, ShippedDatefrom Invoices where CustomerID = 'ALFKI‘ • Most modern languages use SQL commands.

  5. Northwind.mdb • North Wind Traders • Fictitious company • Sample database provided by Microsoft • Available for MS Access and MS SQL

  6. Northwind.mdb • Create a Northwind DSN (Windows XP) • [See Northwindfolder] • Control Panel • Administrative Tools • Data Sources (ODBC) • Select either User or System DSN • Click Add • Select Microsoft Access driver • Enter database details • Data source name = Northwind • Description = North Wind Traders • Click on “Select…” and find Northwind.mdb

  7. Practical Application “Custom Request” • Application in Business Rules! • Northwinddatabase • Select a customer • Select … from Customers • Display customer demographics • Retrieve itemized order details • Select … from Invoices • Display grid containing order details

  8. Practical Application “Custom Request” • Retrieve a list of all customers from “Customers” table. • Select CustomerID, CompanyName, Phone, Country, PostalCodefrom Customers.

  9. Practical Application “Custom Request” • Retrieve a list of orders from “Invoices” query for selected customer (ALFKI). • Select CustomerID, Freight, ExtendedPrice,Productname, OrderID, OrderDate,ShippedDate from Invoices where CustomerID = ‘ALFKI’

  10. SQLISAM.EXE – What is it? • First released BRG fall 2008 • Simple application • Performs SQL query against • Any ODBC source • MS Access databases • Excel tables • Creates a text file describing the results • Creates a BR “Internal Data File” with results • [See SQLISAM\Demofolder]

  11. CONTEXT.wb • FNOPEN_SQL • Library to interface with SQLISAM.exe • FNGETHANDLE • Library to assign next available line number • FNGET_VAR$ • Library to assign local BR variables from SQL field names

  12. Context.wb – FNOPEN_SQL

  13. Solution Using BR and SQLISAM • DEMO.WB