Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Catalog · How the catalog works

Random project

sqldb_odbc_multiresultsets

The demo for lazarus to handle multiple resultsets using sqldb(odbc)

View on GitHub

Anyone may press Interesting, signed in or not. It helps others find this project.

Member rating

No ratings yet.

Sign in to rate this project.

README

The demo for lazarus to handle multiple resultsets using sqldb(odbc).

lazarus 1.6, win7, MSSQL2000

it seems works!

Demo code

pascal
  ds := TExSQLQuery.Create(nil);
  oconn := TExODBCConnection.Create(nil);
  tran := TSQLtransaction.Create(nil);
  oconn.Password:= 'a1234';
  oconn.UserName:= 'test';
  oconn.Driver:= 'SQL Server';
  oconn.Params.Add('SERVER=localhost');
  oconn.Params.Add('DATABASE=master');
  oconn.Transaction := tran;
  ds.Database := oconn;
  ds.SQL.text := sql;
  ds.Open;