New to Lazarus and Databases

[xenblaise]

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]

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

[stonefull]

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]

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]

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]

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

Yes.

[xenblaise]

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

Thank you

[fabienwang]

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

[xenblaise]

Virtualbox

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]

Is 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]

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

[Leledumbo]

is that link correct? to download virtualbox, is that what you mean?

Yes and yes

[xenblaise]

theo
Leledumbo 
FabienWang
stonefull

Thanks