HMGforum.com

Posted: **Wed Oct 12, 2011 9:00 am**

rathinagiri wrote:...changed DBF->SQLite Exporter to DBF<-->SQLite Exporter...

Thanks a lot Rathi, it's exactly what I need

Best regards

--

Esgici

Posted: **Wed Oct 12, 2011 11:39 am**

Hello rathinagiri

Queria saber como debo compilar el sqlite2dbf con la version HMG 3.0.35 ?
Se puede con dicha version?
Muchas Gracias

Claudio

Quizás quisiste decir: Hello ratnagiri Queria saber como debo compilar el sqlite2dbf con la version HMG 3.0.35 ? Se puede con dicha version? Muchas Gracias Claudio
Hello rathinagiri

I wanted to know how to compile the sqlite2dbf HMG version 3.0.35?
You can with this version?
thank you very much

Claudio

Posted: **Wed Oct 12, 2011 11:57 am**

Hi,

In that case, you have to attach this file also, and delete the references of hmgsqlite in hbc file..

c:\hmg.3.0.39\hmgsql\source\hmgsqlite.prg

Posted: **Wed Oct 12, 2011 3:59 pm**

ok, lo voy a probar
Gracias

Claudio

Posted: **Thu Oct 20, 2011 12:06 pm**

rathinagiri wrote:Hi,

As per Esgici's request, I have changed DBF->SQLite Exporter to DBF<-->SQLite Exporter.

Now, a SQLite Table can be exported to DBF. It seems to work fine for me. Kindly let me know if there is any bug/error...

Thank you.

Hi Rathi,

I have a two small corrections in the function export2dbf():

1) retrieve of max field's content length of character field must be rewritten as

Code: Select all

            aTable1 := sql( oDB1, 'select max( length( ' + cFieldName + ' ) ) from ' + c2sql( cSQLTable ) )

2) max lenght of field name of DBF must be restricted to 10 symbols in the following lines

Code: Select all

            for j := 1 to len( aRecord )
               cFieldName := Left( aStruct[ j, 1 ], 10 )  // <-- changed here
               replace &cFieldName with aRecord[ j ]
            next j

Hope that helps

Posted: **Thu Oct 20, 2011 12:33 pm**

Thanks a lot for the corrections Grigory. I have made the corrections.

Posted: **Wed Jun 20, 2012 8:19 am**

Thanks, I try to compile but can not because there is error

" C:/DOCUME~1/prima/LOCALS~1/Temp/hbmk_cyffzc.dir/main.o:main.c:(.data+0x348): und
efined reference to `HB_FUN_MISCSQL'
C:/DOCUME~1/prima/LOCALS~1/Temp/hbmk_cyffzc.dir/main.o:main.c:(.data+0x3a8): und
efined reference to `HB_FUN_C2SQL'
C:/DOCUME~1/prima/LOCALS~1/Temp/hbmk_cyffzc.dir/main.o:main.c:(.data+0x408): und
efined reference to `HB_FUN_CONNECT2DB'
C:/DOCUME~1/prima/LOCALS~1/Temp/hbmk_cyffzc.dir/sqlite2dbf.o:sqlite2dbf.c:(.data
+0x88): undefined reference to `HB_FUN_CONNECT2DB'
C:/DOCUME~1/prima/LOCALS~1/Temp/hbmk_cyffzc.dir/sqlite2dbf.o:sqlite2dbf.c:(.data
+0xc8): undefined reference to `HB_FUN_SQL'
C:/DOCUME~1/prima/LOCALS~1/Temp/hbmk_cyffzc.dir/sqlite2dbf.o:sqlite2dbf.c:(.data
+0x158): undefined reference to `HB_FUN_C2SQL'
collect2: ld returned 1 exit status
hbmk2: Error: Running linker. 1 "

Posted: **Wed Jun 20, 2012 9:40 am**

Hi,

Have you included hmgsqlite library while compiling?

Posted: **Thu Jun 21, 2012 2:44 am**

Thank you, to get the file where?
can you please give instructions

Thank you,
beni

rathinagiri wrote:Hi,

Have you included hmgsqlite library while compiling?

Posted: **Thu Jun 21, 2012 4:55 am**

Hello bels79 !

You just need to edit file: dbf2sqlite.hbp ( can be edited via HMG IDE )

If you dont have "HMGSQL LIB" just download from link below:
viewtopic.php?f=8&t=1562&p=12079&hilit=HmgSql#p12079

dbf2sqlite.hbp - before changes:

Code: Select all


main.prg
sqlite2dbf.prg

dbf2sqlite.hbp - After changes:

Code: Select all


main.prg
sqlite2dbf.prg

#
# libs
#
# 
-lhbsqlit3

#
# .hbc files
#
# 
hbsqlit3.hbc
dbf2sqlite.hbc

HMGforum.com

DBF<-->SQLite Exporter

Re: DBF->SQLite Exporter

Re: DBF<-->SQLite Exporter

Re: DBF<-->SQLite Exporter

Re: DBF<-->SQLite Exporter

Re: DBF->SQLite Exporter

Re: DBF<-->SQLite Exporter

Re: DBF<-->SQLite Exporter

Re: DBF<-->SQLite Exporter

Re: DBF<-->SQLite Exporter

Re: DBF<-->SQLite Exporter