Stef Merlijn
asked on
Create View in SQL Server from within Delphi
Hi,
How can I create a View in SQL Server from within Delphi?
The connections is done via TADOConnection.
Thanks, Stef
How can I create a View in SQL Server from within Delphi?
The connections is done via TADOConnection.
Thanks, Stef
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
TAdoConnection has a Execute method
var AdoConnection1: TAdoConnection;
AdoConnection1Execute('CRE ATE VIEW AS SELECT * FROM TABLE', cmdText, [eoExecuteNoRecords]);
var AdoConnection1: TAdoConnection;
AdoConnection1Execute('CRE
ASKER
Thank you!
of course, given the login you use to connect has the right permissions.