Thread View: borland.public.cppbuilder.database.ado
4 messages
4 total messages
Started by Partaud
Sun, 02 Oct 2005 07:58
TADO and DBASE?for new(in ADO)
Author: Partaud
Date: Sun, 02 Oct 2005 07:58
Date: Sun, 02 Oct 2005 07:58
10 lines
1360 bytes
1360 bytes
Hello I would connect at running time a DBase table "mytable.db" which is in "mydirectory".I have read the help but at running time I don't understnd what I must do I have tried but...nothing. It isbecause I would open it with "prolog" but it accept only ADO bases. Could you send a sample of code please to me? I have look for it in help fils but nothing Excuse my English Thank you in advance Patrick
Re: TADO and DBASE?for new(in ADO)
Author: Viatcheslav V. Vassiliev
Date: Mon, 03 Oct 2005 16:39
Date: Mon, 03 Oct 2005 16:39
33 lines
1956 bytes
1956 bytes
Connection string is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\dir;Extended properties=dBase 5.0 Query is select * from mytable Assuming file is mytable.dbf. Jet provider uses BDE. //------------------------------------------ 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) "Partaud" <patartaud@wanadoo.fr> �������/�������� � �������� ���������: news:433f952a@newsgroups.borland.com... > Hello > I would connect at running time a DBase table "mytable.db" which is in > "mydirectory".I have read the help but at running time I don't understnd > what I must do I have tried but...nothing. > It isbecause I would open it with "prolog" but it accept only ADO bases. > Could you send a sample of code please to me? > I have look for it in help fils but nothing > Excuse my English > Thank you in advance > Patrick >
Re: TADO and DBASE?for new(in ADO)
Author: Partaud
Date: Mon, 03 Oct 2005 20:47
Date: Mon, 03 Oct 2005 20:47
43 lines
2432 bytes
2432 bytes
Thank you I go to try it but I don't know if I have DBase 4 or 5.And this is when I put a ADO component on my form, I suppose. It is the ^property o the component? I thank you again Patrick "Viatcheslav V. Vassiliev" <support@oledbdirect.com> a �crit dans le message de news: 43415e28@newsgroups.borland.com... > Connection string is: > > Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\dir;Extended > properties=dBase 5.0 > > Query is > > select * from mytable > > Assuming file is mytable.dbf. Jet provider uses BDE. > > //------------------------------------------ > 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) > > > "Partaud" <patartaud@wanadoo.fr> �������/�������� � �������� ���������: > news:433f952a@newsgroups.borland.com... >> Hello >> I would connect at running time a DBase table "mytable.db" which is in >> "mydirectory".I have read the help but at running time I don't understnd >> what I must do I have tried but...nothing. >> It isbecause I would open it with "prolog" but it accept only ADO bases. >> Could you send a sample of code please to me? >> I have look for it in help fils but nothing >> Excuse my English >> Thank you in advance >> Patrick >> > >
Re: TADO and DBASE?for new(in ADO)
Author: Viatcheslav V. Vassiliev
Date: Tue, 04 Oct 2005 07:45
Date: Tue, 04 Oct 2005 07:45
62 lines
3406 bytes
3406 bytes
Place TADOConnection component, and set its ConnectionString property. Then place TADODataSet component, set Connection property to ADOConnection1, and CommandText to sql query. Add TDataSource and set its DataSet property to ADODataSet1. Add TDBGrid and set its DataSource property to DataSource1. Finally set ADOConnection1->Connected to true and ADODataSet1->Active to true. //------------------------------------------ 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) "Partaud" <patartaud@wanadoo.fr> �������/�������� � �������� ���������: news:43419af8$1@newsgroups.borland.com... > Thank you > I go to try it but I don't know if I have DBase 4 or 5.And this is when I > put a ADO component on my form, I suppose. > It is the ^property o the component? > I thank you again > Patrick > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> a �crit dans le > message de news: 43415e28@newsgroups.borland.com... >> Connection string is: >> >> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\dir;Extended >> properties=dBase 5.0 >> >> Query is >> >> select * from mytable >> >> Assuming file is mytable.dbf. Jet provider uses BDE. >> >> //------------------------------------------ >> 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) >> >> >> "Partaud" <patartaud@wanadoo.fr> �������/�������� � �������� ���������: >> news:433f952a@newsgroups.borland.com... >>> Hello >>> I would connect at running time a DBase table "mytable.db" which is in >>> "mydirectory".I have read the help but at running time I don't understnd >>> what I must do I have tried but...nothing. >>> It isbecause I would open it with "prolog" but it accept only ADO bases. >>> Could you send a sample of code please to me? >>> I have look for it in help fils but nothing >>> Excuse my English >>> Thank you in advance >>> Patrick >>> >> >> > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads