import dbf to SQLite

Utilities like DBU, Make, IDE written in HMG/ used to create HMG based applications

Moderator: Rathinagiri

Post Reply
User avatar
dragancesu
Posts: 560
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia

import dbf to SQLite

Post by dragancesu » Fri Sep 11, 2015 11:14 am

I'm sure there are many tools to help you do this, but I still made another. Based on the DBF structure program will create a table in SQLite database, and transfer data, 1: 1, and you later make optimize
The result is a program that you need to compile

First step: compile imp_gen.prg
Second: compile result program

File sql1.prg you can found on c:\hmg\samples\hfcl\sql\sqlite // author Rathinagiri

p.s. in hmg folder, in file hmg.hbc line #libs=hbsqlit3 remove #
Attachments
import3.zip
(3.55 KiB) Downloaded 179 times
Last edited by dragancesu on Fri Sep 11, 2015 4:48 pm, edited 2 times in total.

User avatar
Rathinagiri
Posts: 5234
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: import dbf to SQLite

Post by Rathinagiri » Fri Sep 11, 2015 1:36 pm

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

User avatar
bpd2000
Posts: 1024
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: import dbf to SQLite

Post by bpd2000 » Fri Sep 11, 2015 1:45 pm

Rathinagiri wrote:Thanks a lot for the sharing.
+1
BPD
Convert Dream into Reality through HMG

User avatar
danielmaximiliano
Posts: 2081
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Contact:

Re: import dbf to SQLite

Post by danielmaximiliano » Fri Sep 11, 2015 11:03 pm

Thanks a lot for the sharing Dragan
*´¨)
¸.·´¸.·*´¨) ¸.·*¨)
(¸.·´. (¸.·` *
.·`.HMG : It's magic !
(¸.·``··*

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. : +54901169026142
Telegram Name : DaNiElMaXiMiLiAnO

User avatar
serge_girard
Posts: 2092
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: import dbf to SQLite

Post by serge_girard » Sun Sep 13, 2015 7:52 am

Thanks Dragan!

Serge

Post Reply