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

import dbf to SQLite

Post by dragancesu »

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 449 times
Last edited by dragancesu on Fri Sep 11, 2015 4:48 pm, edited 2 times in total.
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: import dbf to SQLite

Post by Rathinagiri »

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: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: import dbf to SQLite

Post by bpd2000 »

Rathinagiri wrote:Thanks a lot for the sharing.
+1
BPD
Convert Dream into Reality through HMG
User avatar
danielmaximiliano
Posts: 2611
Joined: Fri Apr 09, 2010 4:53 pm
Location: Argentina
Contact:

Re: import dbf to SQLite

Post by danielmaximiliano »

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

Saludos / Regards
DaNiElMaXiMiLiAnO

Whatsapp. := +54901169026142
Telegram Name := DaNiElMaXiMiLiAnO
User avatar
serge_girard
Posts: 3162
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 »

Thanks Dragan!

Serge
There's nothing you can do that can't be done...
Post Reply