SQLWIN question

[Marc Vanzegbroeck]

Hi,

Is it already possible to open SQLITE-files with SQLWIN?
I downloaded it,but I don't find the include-files.

Thanks,
Marc

[Antonio Linares]

Marc,

No, not yet. SQLWIN is on a very early development stage.

[Marc Vanzegbroeck]

Thanks for ths info.

By the way, do you know I can open/edit sqlite with foxpro? I need to change some data in a sqlite-database and wanted to do it with FWH, but because it doesn't work yet, I want to open it in foxpro and maybe convert it to dbf.

Thanks,
Marc

[Antonio Linares]

Marc,

You may try ourxdbu from Miguel Marchuet:

http://sourceforge.net/projects/ourxdbu/

[Carlos Mora]

Hi Mark,

if you use Firefox, the browser, try to install an extention called 'Sqlite manager'. It is like a DBU, but runs inside the browser. It' only a few Kb to download. This extention surprised me buecause its small, and very complete.

I'm not sure, but may be you con try to access sqlite using ADO. Rafa Carmona (aka thefull) wrote some time ago some functions to access sqlite, but i never used them.

best regards,

[Marc Vanzegbroeck]

Antonio, OurXdbu can't read the SQLite-file.

Carlos, I wiil try the firefox with Sqlite manager.

Thanks,
Marc

[Antonio Linares]

Marc,

> OurXdbu can't read the SQLite-file

If you report it to its developer, M.A. Marchuet, he will surely add support for it.

[Marc Vanzegbroeck]

Hi,

I found this example on a Foxpro-forum. It's working very nice in VFP.
Can it be translated to FWH?

Code: Select all  Expand view

Local lcDatabase, lcUser, lcPassword, lnHandle
lcDatabase = "my.db"
lcUser = "user"
lcPassword = "password"

lnHandle = db_connect(lcDatabase, lcUser, lcPassword)

If lnHandle>=0
   Local lcAlias
   lcAlias = "mycursor"
   SQLExec(lnHandle,"select * from mytable",lcAlias)
   Select (lcAlias)
   Browse
   db_disconnect(lnHandle)
Else
   ? "connect failed"
Endif

Procedure db_connect()
   Lparameters tcDatabase, tcUser, tcPassword
   Local lnHandle
   strng="DRIVER=SQLite3 ODBC Driver;Database=d:\mydb.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;"
   lnHandle = Sqlstringconnect(strng)
   Return lnHandle
Endproc

Procedure db_disconnect()
   Lparameters tnHandle

   SQLDisconnect(tnHandle)
Endproc


You have to install the ODBC-driver http://www.ch-werner.de/sqliteodbc/ first.

Thanks,
Marc

[Antonio Linares]

Marc,

This code from Rafa (TheFull) may help you:

http://forums.fivetechsoft.com/viewtopic.php?t=7358

[Marc Vanzegbroeck]

Antonio,

Thanks for the link. I have follow the link to thefull's blog. Maybe my Spanish translator didn't translate it very good, but I didn't found the code

Regards,
Marc

[Antonio Linares]

Marc,

It looks as you have to use CVS to download it:
cvs -z3 -d:pserver:anonymous@t-gtk.cvs.sourceforge.net:/cvsroot/t-gtk co -P sqlite3

or simply copy it from here
http://t-gtk.cvs.sourceforge.net/viewvc/t-gtk/sqlite3/

[Marc Vanzegbroeck]

Thanks,

I will give it a try...

Regards,
Marc

[Antonio Linares]

Marc,

This is a great free tool to manage SQLite tables:

http://sqliteadmin.orbmu2k.de/

[Marc Vanzegbroeck]

Thanks Antonio,

Regards,
Marc