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 be

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] SQLite support on windows

2012-08-26 Thread Kevin Benson
On Sun, Aug 26, 2012 at 9:23 AM, Arbol One arbol...@gmail.com 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 Simon Slavin
On 26 Aug 2012, at 2:23pm, Arbol One arbol...@gmail.com 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 manipulation

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

[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 =

[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

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 uka...@gmail.com 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 for this

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] Connect MySQL database made with phpMyAdmin to Sqlite

2012-08-26 Thread Simon Slavin
On 26 Aug 2012, at 11:37am, Νικολέττα Σιώτα nicolesi...@hotmail.com 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 project since

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 uka...@gmail.com 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. ? Is