topic-13871

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

SQLWIN question
Posted: Sat Dec 06, 2008 09:34 AM

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

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

SQLWIN question
Posted: Sat Dec 06, 2008 09:54 AM

Marc,

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

SQLWIN question
Posted: Sat Dec 06, 2008 10:15 AM

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

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

SQLWIN question
Posted: Sat Dec 06, 2008 11:35 AM

Marc,

You may try ourxdbu from Miguel Marchuet:

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

Carlos Mora

Posts: 989

Joined: Thu Nov 24, 2005 03:01 PM

SQLWIN question
Posted: Sat Dec 06, 2008 08:36 PM

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,

Saludos
Carlos Mora
http://harbouradvisor.blogspot.com/
StackOverflow http://stackoverflow.com/users/549761/carlos-mora
“If you think education is expensive, try ignorance"

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

SQLWIN question
Posted: Sun Dec 07, 2008 09:13 PM

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

Carlos, I wiil try the firefox with Sqlite manager.

Thanks,
Marc

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

SQLWIN question
Posted: Sun Dec 07, 2008 10:33 PM

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.

regards, saludos

Antonio Linares
www.fivetechsoft.com

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

SQLWIN question
Posted: Mon Dec 08, 2008 08:22 AM

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 Collapse

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

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

SQLWIN question
Posted: Mon Dec 08, 2008 08:50 AM

Marc,

This code from Rafa (TheFull) may help you:

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

regards, saludos

Antonio Linares
www.fivetechsoft.com

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

SQLWIN question
Posted: Mon Dec 08, 2008 10:21 AM

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 :cry: