KOL object for connecting to SQLite database

← →
Boguslaw (2003-02-25 02:12) [0]

Hello
I"m just working on my KOL www page.Still under construction but You can find there simple approach to connecting KOL to SQLite database

http://members.fortunecity.com/boguslaw/KOLSQLite.zip

No visual objects (sorry), just simple TKOLSLDataSource,TKOLSLSession,TKOLSLQuery.
This is just a proposition. How we should implement standarized database access in KOL?

Sorry for English here, but this is devel list and English list is almost dead.

Boguslaw

← →
SerB (2003-02-25 11:16) [1]

Hi! I"m can"t install KOLSQLite under version KOL&MCK 1.68 (1.69). I"ve error code "different version MCK".

← →
Boguslaw (2003-02-25 16:36) [2]

Strange...I will test.

← →
Boguslaw (2003-02-25 16:37) [3]

What Delphi version You used ?

← →
Boguslaw (2003-02-25 21:48) [4]

Attached package is for Delphi 5 . If You have another version then create own package ,add there KOLSQLiteDb.pas and mckKOLSQLiteDb and install.

← →
SerB (2003-02-26 05:57) [5]

2Boguslaw.
It"s my gluck :)
I"m install package in $KOl_dir$\KOLSQLite\...
After installation in $KOL_dir$\ it"s worked...
But in sample with yor DB and Table (?) ...
only BD information like "Library SQLite version:2.8.0 encoding ISO 8859" in KOLLabel and blank list... in KOLMemo :)

← →
Boguslaw (2003-02-26 11:32) [6]

OK,my mistake. test.db database is missing I will fix this today.

← →
SerB (2003-02-26 13:47) [7]

Thank"s.
How your idea about visual DB-aware component"s (like MCK_Table,MCK_DBNavigator, MCKDB_Edit e.t.c.- full mirror classes for DB VCL)?

← →
Boguslaw (2003-02-26 16:46) [8]

KOLSQLite.zip updated! Don"t forget to run xHelpGen to get help!
It is only starting proposal - compatible with KOlOleDb but should be changed in future to add visual controls (I think about supporting SQLite and Firebird - it is sufficient for all database work) I must now study IBObject,Delphi database components,Turbo Power Morpheus pack and other (and of course suggestions) to decide how it implement.But now also I working on small database -contact information system (written in KOL using SQLite) and by the way also try to create HLP creator for KOL.Give me a few days (maybe a week),please.I will know much more then now.

← →
Boguslaw (2003-02-27 00:59) [9]

Hello,
I"m just testing TKOLSQLiteDb objects in real small database applications and seems that a few bugs will be corrected that way.Look for a new release soon....

← →
SerB (2003-02-27 09:22) [10]

2 Boguslaw
Hi!
Sorry my dummy head...

I"m replace older arhive KOLSQLite.zip with new version (without bug"s, then install success. But in compilation your sample from there arhive and my project with my data i"ve only Runtime Error 216 at e.t.c. (Delphi 5, KOL&MCK 1.69, SQLite 2.8.0)...
Why?

← →
Boguslaw (2003-02-28 13:09) [11]

There is a problem in auto generated *_inc files for forms: sometimes NewSLDataSource function is placed after NewSLSession and NewSLQuery which is a bug.
Good order are :
NewSLDataSource
NewSLSession
NewSLQuery

which is self explaning if You study docs (TSLDataSource is a container of pointers to sqlite functions)

2Vladimir Kladov
How to make sure that in MCK objects are created in good order ?

← →
alex_s (2003-02-28 20:12) [12]

> Good order are :
> NewSLDataSource
> NewSLSession
> NewSLQuery
>
> How to make sure that in MCK objects are created in good
> order ?

I can say how it is made in mckKOLTable

{TKOLDataSource, TKOLSession, TKOLQuery all are
the mirror components}

function TKOLDataSource.TypeName;
begin
Result := "TKOLDataSource";
end;

function TKOLDataSource.CompareFirst;
begin
Result := False;
if c = "" then Result := True;
end;

function TKOLSession.TypeName;
begin
Result := "TKOLSession";
end;

function TKOLSession.CompareFirst;
begin
Result := False;
if c = "" then Result := True;
if c = "TKOLDataSource" then Result := True;
end;

function TKOLQuery.TypeName;
begin
Result := "TKOLQuery";
end;

function TKOLQuery.CompareFirst;
begin
Result := False;
if c = "" then Result := True;
if c = "TKOLDataSource" then Result := True;
if c = "TKOLSession" then Result := True;
end;

← →
Boguslaw (2003-03-01 00:09) [13]

Thank You Alex ;-) That remind me why is better to have one source properly parsed and displayed in editor then write KOL object and MCK mirror,but such IDE not exists for KOL... ;-(

← →
SerB (2003-03-11 11:09) [14]

2Boguslaw
Now all right... but only order creations of Source-session-query edited!
How your VCL-DB-like components for KOL&MCK?

← →
Boguslaw (2003-03-11 16:55) [15]

Well...no time for now.... ;-( And also the first thing I would process will be hlp generator for KOL (only simple functioning interface, all other should be done with a little help of KOl friends)
Boguslaw

KOL object for connecting to SQLite database Найти похожие ветки