Re: ADOX - Create new query in Access Database
- From: "Giuseppe Porzio" <giuseppe.porzio@xxxxxxx>
- Date: Thu, 15 Jun 2006 09:15:22 +0200
Hi,
.....Thanks for all your help .....
.....
.....
Function TfrmStampeCrystalManager.VerificaViews: boolean;
var Datasource: string;
dbName: string;
sPath, sFileName: string;
RecordsAffected: integer;
begin
Screen.Cursor := crHourGlass;
with TADOCommand.Create( Nil ) do begin
dbName := sPathStampe + '\WorkReports.mdb';
DataSource := 'Provider=Microsoft.Jet.OLEDB.4.0' +
';Data Source=' + dbName +
';Persist Security Info=False';
ConnectionString := Datasource;
//...Crea nuova query v_Prova
CommandText := 'CREATE VIEW v_Prova AS SELECT * FROM DatiPrv';
Execute (RecordsAffected, EmptyParam);
Free;
end;
Screen.Cursor := crDefault;
end;
Giuseppe (Italy)
giuseppe.porzio@xxxxxxxxxx
"Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx> ha scritto nel
messaggio news:44904f7b$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Execute this command from TADOConnection.Execute():
CREATE VIEW v_Prova AS SELECT * FROM DatiPrv
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Giuseppe Porzio" <giuseppe.porzio@xxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:44902444@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello!
This is my question. I'm working with Delphi 6, ADO, MS Access 2000
Database.
I want create a new view (query) in Access database with ADOX library.
This
is my code:
...
dbName := sPathStampe + '\WorkReports.mdb';
DataSource := 'Provider=Microsoft.Jet.OLEDB.4.0' +
';Data Source=' + dbName +
';Persist Security Info=False';
Cat := CoCatalog.Create;
Cat.Set_ActiveConnection ( Datasource );
sSql := 'Select * from DatiPrv';
Cat.Views.Append ('v_Prova', sSql );
....
Compilator return error on sSql parameter of Append method (IDSpatch)
thaks
Giuseppe
Italy
.
- References:
- ADOX - Create new query in Access Database
- From: Giuseppe Porzio
- Re: ADOX - Create new query in Access Database
- From: Viatcheslav V. Vassiliev
- ADOX - Create new query in Access Database
- Prev by Date: Saving JPEG images to images field in SQL2000 with ADODataSet
- Next by Date: Re: Saving JPEG images to images field in SQL2000 with ADODataSet
- Previous by thread: Re: ADOX - Create new query in Access Database
- Next by thread: Re: ADOX - Create new query in Access Database
- Index(es):
Relevant Pages
|
