Re: ADOX - Create new query in Access Database
- From: "Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx>
- Date: Wed, 14 Jun 2006 22:03:40 +0400
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
.
- Follow-Ups:
- Re: ADOX - Create new query in Access Database
- From: Giuseppe Porzio
- Re: ADOX - Create new query in Access Database
- References:
- ADOX - Create new query in Access Database
- From: Giuseppe Porzio
- ADOX - Create new query in Access Database
- Prev by Date: ADOX - Create new query in Access Database
- Next by Date: data type of field value
- Previous by thread: ADOX - Create new query in Access Database
- Next by thread: Re: ADOX - Create new query in Access Database
- Index(es):
Relevant Pages
|
