Re: [sqlite] Import at first unhappy - then happy after all

2012-08-26 Thread Kevin Benson
On Sun, Aug 26, 2012 at 11:30 AM, Udi Karni wrote: > The following scenario happens occasionally. > > At first the import fails on mismatched columns - as if the "end-of-line" > marker is off. > > You run it again right away and everything completes successfully. > >

Re: [sqlite] Connect MySQL database made with phpMyAdmin to Sqlite

2012-08-26 Thread Simon Slavin
On 26 Aug 2012, at 11:37am, Νικολέττα Σιώτα wrote: > I have created a database with several tables in MySQL using the phpMyAdmin > tool > from XAMPP (apache) and I want to connect it with a VB.NET project. I thought > that > using Sqlite would be better for my

Re: [sqlite] Import at first unhappy - then happy after all

2012-08-26 Thread Udi Karni
Thanks for the explanation. Is there a way to change the Sqlite escape character globaly? Chose some out-of-the-way character that would allow backward quotes to be used normally? Something like - .escape [ .read c:\path\file.sql ??? On Sun, Aug 26, 2012 at 9:41 AM, Kevin

Re: [sqlite] Import at first unhappy - then happy after all

2012-08-26 Thread Kevin Benson
On Sun, Aug 26, 2012 at 11:30 AM, Udi Karni wrote: ***SNIP*** > > As an aside - not a big deal - this is on Windows - the file specifications > in the ".import" and ".read" commands require 2 back slashes in the syntax > - can that be fixed? > > Thanks ! > > The explanation

[sqlite] Connect MySQL database made with phpMyAdmin to Sqlite

2012-08-26 Thread Νικολέττα Σιώτα
Hello everyone, My name is Nicole Siota and I am a university student currently working on my thesis. I want to make a PC trivia game with 2D graphics and write a manual on how to do it. I decided to work on this project to learn more about this and give it my best shot. Unfortunately, I

[sqlite] Jdbc & Blob & Incremental I/O

2012-08-26 Thread gwenn
Hi, I've been trying to support incremental I/O in a Jdbc driver. By forcing the user to access the rowid before the blob, it's possible to use only the JDBC API for loading a Blob: // CREATE TABLE test (data BLOB); INSERT INTO test (data) VALUES (zeroblob(1024)); ResultSet rs =

Re: [sqlite] unique constraints

2012-08-26 Thread John Taylor
The circumstances I was thinking about is if you had many tables with a column called 'name'. If each table had a different name for the constraint, then they could be differentiated. Otherwise, it would be nice to at least have the name of the table included in the error message. Also, I just

Re: [sqlite] SQLite support on windows

2012-08-26 Thread Simon Slavin
On 26 Aug 2012, at 2:23pm, Arbol One wrote: > [Quote] > *There are a number of devices that run Windows CE > > That is the vortex in this issue. > > The app is being developed on Win7. Using C++ and Gtkmm as the GUI toolkit, > the libraries used for

Re: [sqlite] SQLite support on windows

2012-08-26 Thread Kevin Benson
On Sun, Aug 26, 2012 at 9:23 AM, Arbol One wrote: > [Quote] > *There are a number of devices that run Windows CE > > That is the vortex in this issue. > > The app is being developed on Win7. Using C++ and Gtkmm as the GUI toolkit, > the libraries used

Re: [sqlite] SQLite support on windows

2012-08-26 Thread Arbol One
[Quote] *There are a number of devices that run Windows CE That is the vortex in this issue. The app is being developed on Win7. Using C++ and Gtkmm as the GUI toolkit, the libraries used for manipulation and storage of data is 'home cooked', with the exception of the SQLite3

Re: [sqlite] unique constraints

2012-08-26 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 25/08/12 20:19, Simon Slavin wrote: > You know, it does make sense that if the problem is a violated > constraint, it does always tell you which constraint was violated. You > might have a number of different constraints on a column, and it would