How do I convert datasets?
From: Ai (Larry.Brooks_at_CheckAssist.com)
Date: 01/22/04
- Next message: Dennis: "Re: Re: Re: Login form is not responsive when connecting to the DB"
- Previous message: Thomas Seban: "Re: How to make distinct like this"
- Next in thread: Mike Collier: "Re: How do I convert datasets?"
- Reply: Mike Collier: "Re: How do I convert datasets?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 22 Jan 2004 09:03:24 -0600
We are converting an application from a 2-tier to a 3-tier implementation.
The business logic needs to reside in a COM+ middle tier. I need to access
the busines logic from desktop applications as well as legacy ASP pages. How
can I convert an ApolloTable to an ADO Recordset? Following is working code
for SQL Server:
function TcoAdmin.GetSQLData(const cn, sql: WideString): OleVariant;
var
qry : TAdoQuery;
rs : _Recordset;
begin
try
qry := TAdoQuery.Create(nil);
qry.ConnectionString := cn;
qry.SQL.Clear;
qry.SQL.Add(sql);
qry.Open;
rs := qry.Recordset._xClone;
Result := rs;
qry.Close;
finally
if Assigned(qry) then qry.Free;
end;
end;
- Next message: Dennis: "Re: Re: Re: Login form is not responsive when connecting to the DB"
- Previous message: Thomas Seban: "Re: How to make distinct like this"
- Next in thread: Mike Collier: "Re: How do I convert datasets?"
- Reply: Mike Collier: "Re: How do I convert datasets?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
