phone book with sqlite

You can share your experience with HMG. Share with some screenshots/project details so that others will also be benefited.

Moderator: Rathinagiri

Post Reply
User avatar
dragancesu
Posts: 671
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 21 times
Been thanked: 135 times

phone book with sqlite

Post by dragancesu » Thu Oct 15, 2015 10:00 am

My first project with sqlite base, phone book
Attachments
phone.zip
(24.83 KiB) Downloaded 243 times

User avatar
serge_girard
Posts: 2311
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 555 times
Been thanked: 116 times
Contact:

Post by serge_girard » Thu Oct 15, 2015 10:09 am

Thanks Dragan, I will take a look at it soon !

Serge

User avatar
serge_girard
Posts: 2311
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Has thanked: 555 times
Been thanked: 116 times
Contact:

Post by serge_girard » Thu Oct 15, 2015 10:18 am

Dragan,

Please supply HBP file!

Serge

User avatar
dragancesu
Posts: 671
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 21 times
Been thanked: 135 times

Post by dragancesu » Thu Oct 15, 2015 11:03 am

It is not necessary, just

build phone.prg

User avatar
mol
Posts: 3195
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 214 times
Been thanked: 120 times
Contact:

Post by mol » Thu Oct 15, 2015 11:31 am

I think, you should build file phone.hbp and put there one line
phone.prg

Then run IDE and in Configuration tab, add one line:
libs=sqlite3

User avatar
mol
Posts: 3195
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 214 times
Been thanked: 120 times
Contact:

Post by mol » Thu Oct 15, 2015 11:35 am

When I've tried add new records, some problems with sql update occurs.
When you try to edit record, you should fill fields for edition - I get empty fields.

User avatar
Rathinagiri
Posts: 5263
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 169 times
Been thanked: 172 times
Contact:

Post by Rathinagiri » Thu Oct 15, 2015 4:04 pm

It is working fine for me.

Good work done. Thanks a lot for sharing.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

User avatar
andyglezl
Posts: 1149
Joined: Fri Oct 26, 2012 7:58 pm
Location: Guadalajara Jalisco, MX
Has thanked: 35 times
Been thanked: 68 times
Contact:

Post by andyglezl » Thu Oct 15, 2015 9:29 pm

Gracias dragancesu
---------------------------
Thanks dragancesu
mol wrote: When you try to edit record, you should fill fields for edition - I get empty fields.
Me pasa igual
-----------------------------
the same happens to me


Y con Find / Query da lo siguiente:
------------------------------------------
And with Find / Query gives the following:
phone01.jpg
phone01.jpg (73.66 KiB) Viewed 3342 times
Andrés González López
Desde Guadalajara, Jalisco. México.

Post Reply