 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Tom van der Vlugt
Guest
|
 Posted: Fri Sep 29, 2006 2:23 am Post subject: Using 3rd party with Turbo Explorer isn't difficult |
 |
|
Hi,
Despite that you can't install 3rd party component for design-
time, you can create them at runtime. You may think it's
difficult, but it isn't. There's one special condition for this:
The (online) documentation should be darn good, otherwise you'll
miss the needed information how to setup the pieces at runtime.
I'm evaluating the following libraries:
Advantage 8.1 Database
Url: http://devzone.advantagedatabase.com/dz/content.aspx?key=20&Release=10
Local database server is free to use
Remarks: for an embedded database it has great SQL capabilities,
but you cannot use transactions. Don't use the ODBC mode using
BDE, since it gives Access Violations upon succesfully
completed SQL queries using the Execute method of TDatabase. I
didn't test ODBC using dbGo, but since it's a very fresh version
there **might** be some bugs left behind, but I'm not so sure
about it, since the native component succeeded completely even
upon a correct SQL query. Maybe the deprecated BDE might be the
culprit.
NexusDB 2.04
Url: http://news.nexusdb.com/showpage.asp?Id=122
Embedded database server is free to use
Remarks: for an embedded database it has great SQL capabilities,
and you can use transactions. It's a lot work to set up, but I
will create helper objects to facilitate in using NexusDB.
KaDAO for Access 97 or Access 2000 databases
Url: http://kadao.dir.bg/
Freeware with source
Remarks: Use this compo if you are more familiar with DAO than
OleDB.
Pascal Script 3.0
Url: http://www.remobjects.com/page.asp?id={9A30A672-62C8-4131-BA89-EEBBE7E302E6}
Freeware with source
Remarks: I've tested MSScript.ocx from Microsoft, but this one
is much simpler and the need of ActiveX components are no
further necessary with Pascal Script, and Pascal Script is the
SAME syntax as Delphi in it fullest colors! I've abandoned the
ActiveX version.
I'm just in the beginning of my journey, but if my successes get
significant, I'll share my results with you
With regards from
Tom van der Vlugt |
|
| Back to top |
|
 |
Tom van der Vlugt
Guest
|
| Posted: Sat Sep 30, 2006 12:52 am Post subject: Re: Using 3rd party with Turbo Explorer isn't difficult |
|
|
"Liz" <liz_wants_no_spam (AT) xcalibur (DOT) nospam.co.uk> wrote:
that doesn't differ very much compared to the paid version.
This is my snippet, but it's far from complete. Just this is
the very basic of an empty form:
================= begin snippet ==============================
unit TVFrmTestNexus;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, nxdb, nxllComponent, nxsdServerEngine,
nxsrServerEngine, nxseAutoComponent, nxsrSqlEngineBase, nxsqlEngine;
type
TfrmTestNexus = class(TForm)
procedure FormCreate(Sender: TObject);
procedure FormDestroy(Sender: TObject);
strict private
{ Private declarations }
//Start - to separate helper component
mServerEngine: TnxServerEngine;
mSession: TnxSession;
mPOS: TnxDatabase; //Expose this as a read-only property
mSQLEngine: TnxSqlEngine;
mAllEngines: TnxseAllEngines;
//End - to separate helper component
mSQL: Tnxquery;
strict protected
{ Protected declarations }
public
{ Public declarations }
end;
var
frmTestNexus: TfrmTestNexus;
implementation
{$R *.dfm}
procedure TfrmTestNexus.FormCreate(Sender: TObject);
begin
//Create NexusDB database
mServerEngine := TnxServerEngine.Create(self);
mSession := Tnxsession.Create(self);
mSQLEngine := TnxSqlEngine.Create(self);
mPOS := TnxDatabase.Create(self);
mAllEngines := TnxseAllEngines.Create(self);
mSQL := TnxQuery.Create(self);
with mServerEngine do
begin
SqlEngine := mSqlEngine;
Options := [];
TableExtension := 'nx1';
end;
with mSession do
begin
ServerEngine := mServerEngine
end;
with mPOS do
begin
Session := mSession;
AliasPath := 'D:\Databases\NexusDB\kassaatje' //Expose this as a R/W property
end;
with mSqlEngine do
begin
ActiveDesigntime := True
end;
with mSQL do
begin
Database := mPOS;
Sql.Clear;
SQL.Add('select * from test');
ActiveRuntime := True;
end;
end;
procedure TfrmTestNexus.FormDestroy(Sender: TObject);
begin
mSQL.ActiveRuntime := false;
mPOS.Close;
mSession.Close;
mPOS.Destroy;
mSQLEngine.Close;
mSession.Close;
mServerEngine.Close;
end;
end.
================= end of snippet =============================
Tom |
|
| Back to top |
|
|
Tom van der Vlugt
Guest
|
| Posted: Sat Sep 30, 2006 10:09 pm Post subject: Re: Using 3rd party with Turbo Explorer isn't difficult |
|
|
I've dropped a TDataSource and a TDbGrid object on my form and
I've done the following:
DESIGN TIME (TDataSource and TDbGrid are stock controls)
Gegevens: TDataSource
UitgevoerdeData: TDbGrid
Datasource=Gegevens
RUNTIME
After the snippet
////////////////////////////////////////////////
with mSQL do
begin
Database := mPOS;
Sql.Clear;
SQL.Add('select * from test');
ActiveRuntime := True;
end;
////////////////////////////////////////////////
I've inserted just one line:
Gegevens.DataSet := mSQL;
Voila, my small test-table is up and running. This is the proof
that the newest Explorer Edition is superior above the former
Personal Editions, since the required database programming
facilities are present! This is a very good move of Borland! |
|
| Back to top |
|
|
Tom van der Vlugt
Guest
|
| Posted: Tue Oct 03, 2006 8:12 am Post subject: Re: Using 3rd party with Turbo Explorer isn't difficult |
|
|
Franz-Leo Chomse <franz-leo.chomse (AT) samac (DOT) de> wrote:
| Quote: | SqlTriggerMonitor: TnxSqlTriggerMonitor;
StoredProc : TnxStoredProc;
|
Franz,
Can you also state the files I need for the Uses clause? I
miss both types in the documentation for what unit to use.
The NexusDB documentation is regarding 'uses' files not yet
complete, since I see now and then 'To do' or 'Yet to be
documentented'. Outside these few missing links the docs are
good.
Tom |
|
| Back to top |
|
|
Tom van der Vlugt
Guest
|
| Posted: Wed Oct 04, 2006 5:26 pm Post subject: Re: Using 3rd party with Turbo Explorer isn't difficult |
|
|
Franz-Leo Chomse <franz-leo.chomse (AT) samac (DOT) de> wrote:
Franz-Leo,
Thank you for the uses file-name. A look in the home directory
of the NexusDB software there are a number of .int (interface)
source files. Your feedback and the information in these files
provides me with enough information to use NexusDB to its
fullest contents. It's a great database engine. Turbo Delphi
in combination with NexusDB has beaten MS VS.NET with SQL 2005
Explorer! I'm very happy with this piece of software.
With regards from
Tom van der Vlugt |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
