Idea of SQL integration
- From: "Frenk" <Frenk3@xxxxxxxxx>
- Date: Sat, 15 Jul 2006 15:12:45 +0200
After almost full-time DB programming, I was thinking about how to integrate
RDBMS & Delphi. I am wondering why isn't possible to solve this issues like
compiler directive e.g. ASM. We all know that there is no general solution
for multiple DB vendors (sas for multiple CPU-s too).
Isn't just a great idea like this:
function _countCustomers( sCustID :string) : integer;
begin
Result := 0;
if sCustID = '' then
Exit;
TSQL:_Conn{ -- directive for MS SQL ( _Conn is link for
connection)
declare @sCustType varchar(20) -- internal variables are
declared as standard {@VarName}
select @sCustType = CustType from Customers where CustID =
stID -- external variables from are declared in delphi style {:VarName}
set :Result = (select count(*) from Customers where CustType =
@sCustType
}
end
Extension to this would be debugger integration. (I know that this is
possible to solve using standard comand objects, etc, but I am sick of
declaring and creating them all the time
What do you think?
Frenk
.
- Follow-Ups:
- Re: Idea of SQL integration
- From: indy
- Re: Idea of SQL integration
- From: Shawn B.
- Re: Idea of SQL integration
- From: Jarle Stabell
- Re: Idea of SQL integration
- From: John Herbster
- Re: Idea of SQL integration
- From: Ralf Mimoun
- Re: Idea of SQL integration
- From: Martyn Ayers
- Re: Idea of SQL integration
- From: Yannis
- Re: Idea of SQL integration
- From: John Kaster (Borland/DevCo)
- Re: Idea of SQL integration
- From: William Egge
- Re: Idea of SQL integration
- Prev by Date: Re: Just an idea for a feature request
- Next by Date: Re: Tried Out Delphi 2006
- Previous by thread: Tried Out Delphi 2006
- Next by thread: Re: Idea of SQL integration
- Index(es):
Relevant Pages
|
|
