Re: SQLite database file from third-party sources?

[Mark Schonewille]

Hi Peter,

Thanks, but I tried that file just as an experiment. The real problem  
is that the people in that thread on the forum seem to be unable to  
use particular SQLite 3 files. I'm now waiting for a reply from the  
original poster of that thread to have confirmed that he is using an  
SQLite 3 file and he is using the correct syntax. I wonder whether  
Rev's SQLite can read any SQLite 3 file without any restrictions.


Best regards,

Mark Schonewille

--

Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz

A large collection of scripts for HyperCard, Revolution, SuperCard and  
other programming languages can be found at http://runrev.info





On 13 apr 2008, at 10:39, Peter Alcibiades wrote:


I downloaded the file and tried opening it with the firefox plug in.
Which reports it is corrupted.  sqlitebrowser reports its not an
sqlite 3 database.  Tksqlite, which does both 2 and 3, opens it
however.  So its probably v 2 and just needs converting.  Tksqlite
might do that?

Peter




___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: SQLite database file from third-party sources?

[Peter Alcibiades]

I downloaded the file and tried opening it with the firefox plug in.  
Which reports it is corrupted.  sqlitebrowser reports its not an
sqlite 3 database.  Tksqlite, which does both 2 and 3, opens it
however.  So its probably v 2 and just needs converting.  Tksqlite
might do that?

Peter



Mark Schonewille-3 wrote:
> 
> Ian, Peter and William,
> 
> Can you think of any reason why a SQLite 3 file wouldn't work with  
> Rev? The reason why I ask is the problem discussed in the forum:
> <http://forums.runrev.com/phpBB2/viewtopic.php?p=6516#6516 
>  >. It really intrigues me why people have problems using SQlite 3  
> databases.
> 
> Best regards,
> 
> Mark Schonewille
> 
> --
> 
> Economy-x-Talk Consulting and Software Engineering
> http://economy-x-talk.com
> http://www.salery.biz
> 
> A large collection of scripts for HyperCard, Revolution, SuperCard and  
> other programming languages can be found at http://runrev.info
> 
> 
> 
> 
> On 11 apr 2008, at 22:46, william humphrey wrote:
>> I created my SQLite database with SQLite Manager and access it all  
>> the time.
> 
> ___
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

-- 
View this message in context: 
http://www.nabble.com/SQLite-database-file-from-third-party-sources--tp16638272p16656745.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: SQLite database file from third-party sources?

[Mark Schonewille]

Ian, Peter and William,

Can you think of any reason why a SQLite 3 file wouldn't work with  
Rev? The reason why I ask is the problem discussed in the forum: . It really intrigues me why people have problems using SQlite 3  
databases.


Best regards,

Mark Schonewille

--

Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz

A large collection of scripts for HyperCard, Revolution, SuperCard and  
other programming languages can be found at http://runrev.info





On 11 apr 2008, at 22:46, william humphrey wrote:
I created my SQLite database with SQLite Manager and access it all  
the time.


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: SQLite database file from third-party sources?

[william humphrey]

I created my SQLite database with SQLite Manager and access it all the time.

On Fri, Apr 11, 2008 at 2:15 PM, Mark Schonewille <
[EMAIL PROTECTED]> wrote:

> Thanks for the reply, Ian. Would it be possible to send me a small sample
> database, which hasn't been touched by Rev?
>
> Best,
>
> Mark
>
> --
>
> Economy-x-Talk
> Consultancy and Software Engineering
> http://economy-x-talk.com
> http://www.salery.biz
>
> Get your store on-line within minutes with Salery Web Store software.
> Download at http://www.salery.biz
>
> Op 11-apr-2008, om 20:11 heeft Ian Wood het volgende geschreven:
>
>
> >
> > I do this all the time with Aperture's DB, but only reading data.
> >
> > Rev 2.7 and newer, whatever version of the external is in the default
> > install.
> >
> > OS X, not tried on Windows or Linux.
> >
> > Ian
> >
>
> ___
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



-- 
http://www.bluewatermaritime.com
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

SQLite database file from third-party sources?

[Peter Alcibiades]

Yes, I made an sqlite database using both sqlitebrowser and also the firefox 
plugin sqlite manager.  Both were super easy, but the firefox plug in is a 
lot faster, it did 15k records in a flash, whereas squlite browser choked.  I 
imported a tab delimited file to sqlite.  Saved it.  Then I connected to it.  
This was from one of the 2.9 linux betas.  Connection seemed OK.  I didn't 
try queries or adds, just wanted to verify connection.  The db had never been 
touched by Rev until the connection was set up.

This is Debian Lenny, pretty much up to date.

Around the same time there was a correspondence about how tab delimited files 
and custom properties or arrays were as good or better, and I thought OK they 
are going to be a lot faster and easier to write.  So didn't pursue it 
further.

Did you have trouble with queries after it reported the connection was made?  
Or could you not get it to make the connection?

Peter
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: SQLite database file from third-party sources?

[Mark Schonewille]

Thanks for the reply, Ian. Would it be possible to send me a small  
sample database, which hasn't been touched by Rev?


Best,

Mark

--

Economy-x-Talk
Consultancy and Software Engineering
http://economy-x-talk.com
http://www.salery.biz

Get your store on-line within minutes with Salery Web Store software.  
Download at http://www.salery.biz


Op 11-apr-2008, om 20:11 heeft Ian Wood het volgende geschreven:



I do this all the time with Aperture's DB, but only reading data.

Rev 2.7 and newer, whatever version of the external is in the  
default install.


OS X, not tried on Windows or Linux.

Ian


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: SQLite database file from third-party sources?

[Ian Wood]

On 11 Apr 2008, at 18:56, Mark Schonewille wrote:

I am unable to access SQLite databases from third-party sources. Has  
anyone ever been able to use an SQLite database file that was not  
created by the SQLite external for Revolution?


If you were successful, was there a special trick to make this work  
and which version of the external and which version of Revolution  
did you use?


I do this all the time with Aperture's DB, but only reading data.

Rev 2.7 and newer, whatever version of the external is in the default  
install.


OS X, not tried on Windows or Linux.

Ian
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

SQLite database file from third-party sources?

[Mark Schonewille]

Hello,

I am unable to access SQLite databases from third-party sources. Has  
anyone ever been able to use an SQLite database file that was not  
created by the SQLite external for Revolution?


If you were successful, was there a special trick to make this work  
and which version of the external and which version of Revolution did  
you use?


Best regards,

Mark Schonewille

--

Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz

A large collection of scripts for HyperCard, Revolution, SuperCard and  
other programming languages can be found at http://runrev.info





___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution