Page 1 of 6

start with sqlite

Posted: Fri Apr 19, 2019 12:36 pm
by dragancesu
It will be a few steps

1. loading dbf into sqlite, step1.zip, compile program imp_gen, select dbf file and create imp<DBFNAME>.prg

2. reading the table structure from the database, step2.zip, just compile sch_imp.prg and structure be in _STRUCT.DBF

3. it's practical to have a table structure in dbf, step3.zip will read _struct.dbf and write _sql_tab.dbf with all description fields from table, just compile sch_stru.prg

The dictionary of data is essential to have to start with the creation of programs for working with tables,

p.s. If someone makes a better program for step 3, please send here

Thank you

Re: start with sqlite

Posted: Mon Apr 22, 2019 11:51 am
by bpd2000
Thank you for sharing

Re: start with sqlite

Posted: Fri Apr 26, 2019 8:29 pm
by Steed
Thanks

Re: start with sqlite

Posted: Sun May 05, 2019 2:55 pm
by mustafa
Hello friends:

Seeing the magnificent sample that I bring
the dragancesu companion:
viewtopic.php?f=5&t=5989&p=58231&hilit= ... esu#p58231
and the complement in:
viewtopic.php?f=5&t=5994&p=58252#p58252

With the Sample that I am contributing, I do not intend to overcome Master Dragan
Only a small contribution to start in the world of SQLite

I have not managed to update the dbf file when creating a new file
new incorporation of the new file in -> COMBOBOX Combo_1
There are also some mistakes that I have tried to correct on the fly
if the program does not have any DBF file for conversion it is created
ERROR I leave you a sample file "Customer.dbf" to be able
to experience.

*--------------------------- Content ---------------------------------- *

1º DBF «-» SQLite
   Option provided by Master Rathinagiri -> dbf2sqlite.zip
   viewtopic.php?p=20587#p20587
   DBF «-» SQLite Exporter, conversion of the two formats
   with Structura SQLite info in file txt format

2º Create Program
   Option provided by Master Dragan, this option creates a
   PRG file in Folder "SQLite_New_PRG" where the DBF File will be
   the file to compile (imp + filename DBF .prg)
   with this option, the same name db3 file and the file will be created
   with Structura SQLite information in file txt format

3º Create DBF
   This option allows us to create a new DBF file

4º View DBF
   This option allows us to see the contents of the DBF File that
   we have selected in "Choose Database"
5º View SQLite
   this option allows us to see the contents of created files
   in the conversion of formats

   View help in Folder -> \ Help_Tools \ where you will find Help_Tools.pdf
   where in an abbreviated way the different options are explained.

Regards
Mustafa

Re: start with sqlite

Posted: Sun May 05, 2019 7:34 pm
by mol
+1

Re: start with sqlite

Posted: Mon May 06, 2019 2:18 pm
by dragancesu
@mustafa thanks for the suggestions
I saw what Rathi did, but I'm always a developer and I have an idea of how to do it, this is the first step, loading DBF data into the SQLite database

added: loading logical field, select database

ask: which you use the SQLite manager?

Re: start with sqlite

Posted: Tue May 07, 2019 12:36 am
by jairpinho
mustafa wrote:
Sun May 05, 2019 2:55 pm
Hello friends:

Seeing the magnificent sample that I bring
the dragancesu companion:
viewtopic.php?f=5&t=5989&p=58231&hilit= ... esu#p58231
and the complement in:
viewtopic.php?f=5&t=5994&p=58252#p58252

With the Sample that I am contributing, I do not intend to overcome Master Dragan
Only a small contribution to start in the world of SQLite

I have not managed to update the dbf file when creating a new file
new incorporation of the new file in -> COMBOBOX Combo_1
There are also some mistakes that I have tried to correct on the fly
if the program does not have any DBF file for conversion it is created
ERROR I leave you a sample file "Customer.dbf" to be able
to experience.

*--------------------------- Content ---------------------------------- *

1º DBF «-» SQLite
   Option provided by Master Rathinagiri -> dbf2sqlite.zip
   viewtopic.php?p=20587#p20587
   DBF «-» SQLite Exporter, conversion of the two formats
   with Structura SQLite info in file txt format

2º Create Program
   Option provided by Master Dragan, this option creates a
   PRG file in Folder "SQLite_New_PRG" where the DBF File will be
   the file to compile (imp + filename DBF .prg)
   with this option, the same name db3 file and the file will be created
   with Structura SQLite information in file txt format

3º Create DBF
   This option allows us to create a new DBF file

4º View DBF
   This option allows us to see the contents of the DBF File that
   we have selected in "Choose Database"
5º View SQLite
   this option allows us to see the contents of created files
   in the conversion of formats

   View help in Folder -> \ Help_Tools \ where you will find Help_Tools.pdf
   where in an abbreviated way the different options are explained.

Regards
Mustafa

great example works perfect thanks for sharing

Re: start with sqlite

Posted: Tue May 07, 2019 11:20 am
by mustafa
Dragan
very successful your sample, congratulations
ask: which you use the SQLite manager?
SQLite manager?
I think I understand, what do you mean -> Sql1.prg
copied from the original of Rathinagiri
regards
Mustafa

Re: start with sqlite

Posted: Tue May 07, 2019 12:53 pm
by dragancesu

Re: start with sqlite

Posted: Tue May 07, 2019 4:18 pm
by mustafa
+1