Re: Idea of SQL integration

Frenk,

What do you think?

Actually, I'd prefer a different kind of integration.

Suppose I'm setting up a view, say, and I type its definition
somewhere, on a scrathpad. Then, for development purposes, I'd like
to be able to transport its definition back and forth between Sql
Server and my Delphi project seamlessly, without a lot of messing
about. So, I'd like to be able to transport some executed Sql in a
Query Analyzer window to a Delphi string constant declaration (I wrote
a little utility to do that bit) and vice versa, i.e. take a Delphi
declared string constant (assume it's mutline and has nice #13#10s at
the end of each line to keep it tidy) and have it parsed back into
QA-executable text, that sort of thing ...

E.g. in a three-tier context, I'd like to get a list of the fields in
some Sql Server object without going through the rigmarole of defining
a provider, pointin a ClientDataSet at it and retrieving the fields.

Cheers, Martyn
.

Relevant Pages