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

[mangakissa]

My opinion.

If you come from delphi and always use ZEOS, please do also (even the multiple warnings from the compiler are forgiven).

If you are new to database programming (even with pascal) use the installed basic components.
SQLdb is very powerfull for a lot of databases.

[majid.ebru]

Hi
i understand what is my wrong ?!?!?

stages of Project :

1-i create application project
2 - i put a Zconnection1 and a ZQuery1 and a Datasource1 and a DBGrid1 in form
3 - Zconnection1 :
         3 - 1 : DataBase address : ...
         3 - 2 : LibraryLocation address : ....
         3 - 3 : Protocol : sqlite-3
         3 - 4 : Connection : True
4 - ZQuery1 :
         4 - 1 : connection := Zconnection1
         4 - 2 : SQL : SELECT * FROM "Person"
         4 - 3 : double click on ZQuery and add Fildes of Table
5 - Datasource1
         5 - 1 : Dataset : ZQuery1
6 - DBGrid
         6 - 1 : DataSource : DataSource1
         6 - 2 : double click on DBGrid and add some Fildes(Titles)

i just don't do stage 6-2 and project work correctly and evry thing are OK.
.
Thank you from all.
 

[Handoko]

So, everything is working correctly, right?

When something doesn't work as what we want, we should review what we have or have not done. I'm glad to see you wrote your step-by-step and made a review about it.

[miab3]

@majid.ebru,

4 - 3 and 6-2 - is not necessary.
Then you will automatically get all the downloaded fields.

Michal

[Handoko]

I rarely do database things. But if I remember correctly, if we do not do the step 6-2, the data won't show on DBGrid on design time.

[miab3]

@Handoko;

For ZQuery1.Active - True will be visible.

Michal

[majid.ebru]

@majid.ebru,

4 - 3 and 6-2 - is not necessary.
Then you will automatically get all the downloaded fields.

Michal

4 - 3  is  necessary becuase i should change width and name of fildes.

I rarely do database things. But if I remember correctly, if we do not do the step 6-2, the data won't show on DBGrid on design time.

i don't do step 6 - 2  and everything is working correctly

@Handoko;

For ZQuery1.Active - True will be visible.

Michal

No.
i don't change active and visible properties.

[Handoko]

@majid.ebru

I saw you're very diligent, in short period of time you have learned a lot of things.

You should use what you have learned to build some useful tools. For example, you can write a personal notebook program that collects notes like what I made, see the image. It is a tray icon program, it will stay on the taskbar until user clicks it. There you can have several (unlimited) tabs to group the notes. When I found some useful codes or tricks form the Internet, I will copy/paste it to the program. Very useful.

[majid.ebru]

@majid.ebru

I saw you're very diligent, in short period of time you have learned a lot of things.

You should use what you have learned to build some useful tools. For example, you can write a personal notebook program that collects notes like what I made, see the image. It is a tray icon program, it will stay on the taskbar until user clicks it. There you can have several (unlimited) tabs to group the notes. When I found some useful codes or tricks form the Internet, I will copy/paste it to the program. Very useful.

Thanks a lot
.
.
i am  beginner in PC programing and i like programing.
.
last time i want to create android apk and mr. jmpessoa and you , help and guide me to learn and build apk.
.
but now i should build Database application.
.
until now i desgin application and now i should write code.
.
i search internet for find my answer(too) and Lazarus forum is very very very gooooooood.

[marsupilami79]

Zeos developers take note! Offer option to use system default path for libraries (32 AND 64 bit). Offer option to make path relative.

Hello Thaddy,

you have some good points in your posts. There are a lot of things that could be done better in Zeos. What I really miss are your patches to solve problems and your bugreports? I didn't see you file anything in the Zeos forums or in the bugtracker.

With best regards,

Jan