Has anybody successfuly ported DISQLite3 from Delphi to Lazarus?
----- Original Message -----
From: "Michael Hooker" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, August 09, 2007 9:47 AM
Subject: Re: [sqlite] New User: Creating/Modifying tables
How do I create/alter tables with a GUI?<<
Short of buying some kind of commercial pre-written db manager, you could
use the DisqLite3 you already have to write something in Delphi which you
already have. All you really need is an edit control into which you put
your SQLite3 statements and a button to execute them, along with some more
edit controls or a StringGrid to display the output, but you can make it
as complicated as you like. For example, how you display the data you
extract from the database is entirely up to you and you can reformat your
dates however you like. It's not very much harder than using the Delphi
data-aware components, though if you only have a personal edition you
won't have seen these. Once you've written something useful, then you
don't have to write a program every time - you just modify the one you've
already written to add new functionality when/if you need it. Statements,
database paths and so on can be stored as text files so they can be
re-used - just like SQLiteSpy.
Check out the example programs that come with DisqLite3. Ralf Junker has
put a lot of work into this, so look at the examples for beginners which
he recently added - he wrote these at my request when I was stuck, and I'm
very grateful to him.
If you need assistance with Delphi programming there is no shortage of
helpful people on Forums such as Tek-Tips. Obviously, this isn't the
place to deal with those issues.
Michael Hooker
----- Original Message -----
From: "mos" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, August 09, 2007 6:17 AM
Subject: [sqlite] New User: Creating/Modifying tables
I created my first Delphi program with DISQLite3 1.40 and I used the
Importer component to create the table and I imported a few of the rows
from MySQL 5. The problem is the dates in the SQLite table show up as
floating point, which is how they are natively stored.
1) How can I determine what the date is with SQLiteSpy? I need the dates
formatted as '2006-05-11'. Do I have to write a program every time I
2) How do I create/alter tables with a GUI? I can't find that option in
SQLiteSpy or SQLite3 Mgr.
TIA
Mike
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------