Recent

Author Topic: [SOLVED][SQLite] : i can't see table  (Read 19168 times)

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: [SQLite] : i can't see table
« Reply #30 on: May 15, 2017, 08:55:01 am »
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.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

majid.ebru

  • Sr. Member
  • ****
  • Posts: 494
Re: [SQLite] : i can't see table
« Reply #31 on: May 15, 2017, 11:15:47 am »
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) :o :o :o

i just don't do stage 6-2 and project work correctly and evry thing are OK.
.
Thank you from all.
 :) ;) :D ;D :) ;) :D ;D
« Last Edit: May 15, 2017, 11:18:47 am by majid.ebru »

Handoko

  • Hero Member
  • *****
  • Posts: 5131
  • My goal: build my own game engine using Lazarus
Re: [SQLite] : i can't see table
« Reply #32 on: May 15, 2017, 11:25:42 am »
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

  • Full Member
  • ***
  • Posts: 145
Re: [SQLite] : i can't see table
« Reply #33 on: May 15, 2017, 11:29:34 am »
@majid.ebru,

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

Michal

Handoko

  • Hero Member
  • *****
  • Posts: 5131
  • My goal: build my own game engine using Lazarus
Re: [SQLite] : i can't see table
« Reply #34 on: May 15, 2017, 11:44:51 am »
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

  • Full Member
  • ***
  • Posts: 145
Re: [SQLite] : i can't see table
« Reply #35 on: May 15, 2017, 12:14:35 pm »
@Handoko;

For ZQuery1.Active - True will be visible.

Michal

majid.ebru

  • Sr. Member
  • ****
  • Posts: 494
Re: [SQLite] : i can't see table
« Reply #36 on: May 15, 2017, 01:02:55 pm »
@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

  • Hero Member
  • *****
  • Posts: 5131
  • My goal: build my own game engine using Lazarus
Re: [SQLite] : i can't see table
« Reply #37 on: May 15, 2017, 02:04:37 pm »
@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

  • Sr. Member
  • ****
  • Posts: 494
Re: [SQLite] : i can't see table
« Reply #38 on: May 15, 2017, 03:29:22 pm »
@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.
« Last Edit: May 15, 2017, 07:14:48 pm by majid.ebru »

marsupilami79

  • New Member
  • *
  • Posts: 32
Re: [SQLite] : i can't see table
« Reply #39 on: May 15, 2017, 09:39:40 pm »
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
Zeos developer

 

TinyPortal © 2005-2018