New to Lazarus and Databases
lazarus / 16-Databases

----------------------------------------------------------------------
xenblaise · 2010-10-06 10:23

hi guys

Do you have any sample project that is using TSQLite3Connection? Just
a simple Adding record, Deleting and Updating.
Can anyone submit a link?
I hope some of you has it, when you were still a newbie of lazarus.

If you don't have the TSQLite3Connection, I'd like to see also in
TMYSQL50Connection.


Thank you.

----------------------------------------------------------------------
Leledumbo · 2010-10-06 10:49

I remember posting one in this forum, but I can't locate it. I'll post
a fresh copy tomorrow.

----------------------------------------------------------------------
stonefull · 2010-10-06 16:13

Using SQLite3Connection

http://professorcarlos.blogspot.com/2010/02/lazarus-acessando-banco-
de-dados-com.html
http://professorcarlos.blogspot.com/2010/02/lazarus-acessando-banco-
de-dados-com_24.html

In portuguese, but there is a link to download a sample.

----------------------------------------------------------------------
xenblaise · 2010-10-07 05:05

Here's my lazarus sqlite3 sample.
http://www.mediafire.com/file/0lssfhdr5mqz44c/lazarussqlite3.zip

The project is based on delphi and I paste to lazarus was great.
The project work perfectly.

The problem is?, it does not use a lazarus template, the project
composed of:
unit SQLite3;
unit SQLiteTable3;

How am I going to use the SQLdb TComponent with TSQLite3Connection?

Please if you have some old sample codes using the SQLdb
TSQLite3Connection, please do submit a link;

I only need to understand the procedure of how do it works using that
component.

And if you think that the project I've shown is good, I may use it,
but I really want the TSQLite3Connection of Lazarus
template/component.


Thank you for the replys

----------------------------------------------------------------------
xenblaise · 2010-10-08 15:23

hey guys?

I got it now using;

SqliteConnection
SqlTransaction
SqlQuery

and the

Datasource



BUT do you think this component palette is still on linux? since Im
using windows?

----------------------------------------------------------------------
theo · 2010-10-08 15:27

Quote from: xenablaise on October 08, 2010, 05:23:46 pmyou think this
component palette is still on linux? since Im using windows?

Yes.

----------------------------------------------------------------------
xenblaise · 2010-10-08 17:30

So, excited to see my first program running in Linux.  But windows
first, I have to setup a ubunto server first.

Thank you

----------------------------------------------------------------------
fabienwang · 2010-10-08 18:21

hey Xenablaise, you can start a virtual machine on your windows, try
to download Virtualbox

----------------------------------------------------------------------
xenblaise · 2010-10-09 03:22

QuoteVirtualbox
Is that program that starts your computer from windows then boot to
linux? linux what? ubunto? redhat? suse? mandriva?

I guess I have a small memory installed.

But I'll be glad to try it.


Thanks

----------------------------------------------------------------------
Leledumbo · 2010-10-09 04:26

QuoteIs that program that starts your computer from windows then boot
to linux? linux what? ubunto? redhat? suse? mandriva?
It's a processor emulator. You can use whatever OS there (well... as
long as the processor is supported, AFAIK it's only x86).

----------------------------------------------------------------------
xenblaise · 2010-10-10 08:51

http://www.virtualbox.org/wiki/Downloads
is that link correct? to download virtualbox, is that what you mean?

----------------------------------------------------------------------
Leledumbo · 2010-10-11 04:43

Quoteis that link correct? to download virtualbox, is that what you
mean?Yes and yes

----------------------------------------------------------------------
xenblaise · 2010-10-11 06:23

theo
Leledumbo 
FabienWang
stonefull

Thanks