[SOLVED][SQLite] : i can't see table

[majid.ebru]

Hi
i make a project and i want to see my table but i can't see.
i see my table in sqlite IDE.
help me please
 

[Handoko]

Hello majid.ebro.

I tested your code but I can't make it work. Where can I find zcomponent?

[Thaddy]

Zeos sh*t maybe?

Anyway it works with:

Code: Pascal  [Select][+][-]

1.     ZConnection1: TSqlite3Connection;
2.     ZQuery1: TSqlQuery;
3.  

@Handoko: you can install zeos with the online package manager. (And, like me, uninstall it again later )

You will also see that the query doesn't have the datasource connected, duh!

[majid.ebru]

sorry

you can download zeos from here

[Thaddy]

Connect the query to the datasource otherwise you won't see much 

[majid.ebru]

sorry
i don't understand what you say?!??!
.
can you more explain,please
and
how can i solve i?
.

this sample works corectly?!?!

[Handoko]

Hooray, it works! 

I haven't tested "base", but your first one "TestShow" works. It works almost effortlessly on my test, I just need to configure the path and some settings. I use Linux.

Thanks Thaddy for recommending Online Package Manager. I heard it a lot but this is my first time using that tool. Nice, I will keep using it.

[Thaddy]

Also works (the same) on WIN64

[majid.ebru]

Hooray, it works! 

I haven't tested "base", but your first one "TestShow" works. It works almost effortlessly on my test, I just need to configure the path and some settings. I use Linux.

Thanks Thaddy for recommending Online Package Manager. I heard it a lot but this is my first time using that tool. Nice, I will keep using it.

Wooooooooooooo
 
.
.
oh my god
.
that is true
.
what is my wrong?
what is my problme?
.
help please!!

[valdir.marcos]

what is my wrong?
what is my problme?

Please, study bellow information and try SQLDB components instead of ZEOS components:
http://wiki.freepascal.org/Working_With_TSQLQuery
http://wiki.freepascal.org/SqlDBHowto
http://wiki.freepascal.org/SQLite

If your have any other doubt, please come back here.

[Thaddy]

The problem is that he forgot to set the datasource property. (That's for sure) He did not say if that fixed it yet.
The only other issue I can think of is a wrong version of sqlite installed. Unlikely, but possible.

[majid.ebru]

no
the "base.rar" works corectlly.
.
i just see this clip and then build the "Base.rar"
.
then i want to change program but i don't know what i changed?
.
ok
.
thank you very much for answer

[Handoko]

but i don't know what i changed?

Write a log of "recent changes" and/or use version control software. If don't want to use version control software, keep several backups of the working code and use Meld => http://meldmerge.org/

Forget what have changed that damaged the code? 
That's often happens (on beginners only). So don't repeat same mistakes. Learning programming is one thing, learning how to write code better is a different thing.

[miab3]

@majid.ebru,

FieldName not assigned.

( ZQuery1.ExecSQL; // not needed)

Michal

[miab3]

@Thaddy,

Zeos sh*t maybe?

Can you justify it?

Michal