start with sqlite
Posted: Fri Apr 19, 2019 12:36 pm
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
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