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: 921
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

phone book with sqlite

Post by dragancesu »

My first project with sqlite base, phone book
Attachments
phone.zip
(24.83 KiB) Downloaded 410 times
User avatar
serge_girard
Posts: 3166
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: phone book with sqlite

Post by serge_girard »

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

Serge
There's nothing you can do that can't be done...
User avatar
serge_girard
Posts: 3166
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: phone book with sqlite

Post by serge_girard »

Dragan,

Please supply HBP file!

Serge
There's nothing you can do that can't be done...
User avatar
dragancesu
Posts: 921
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

Re: phone book with sqlite

Post by dragancesu »

It is not necessary, just

build phone.prg
User avatar
mol
Posts: 3721
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: phone book with sqlite

Post by mol »

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: 3721
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: phone book with sqlite

Post by mol »

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: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: phone book with sqlite

Post by Rathinagiri »

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: 1461
Joined: Fri Oct 26, 2012 7:58 pm
Location: Guadalajara Jalisco, MX
Contact:

Re: phone book with sqlite

Post by andyglezl »

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 5727 times
Andrés González López
Desde Guadalajara, Jalisco. México.
Post Reply