Hi
Any idea how to install System.Designer.dll file? I tried installing it as per
the below link with below xml file as extension xml file.
I created a custom extensions folder under C:\Program Files (x86)\Microsoft
Visual Studio 10.0\VSTSDB\Extensions and copied the System.Designer.dll file
On Sun, May 15, 2011 at 4:24 AM, Don Ireland sql...@donireland.com wrote:
Can anyone suggest a good source for sample C++ code? I really would
rather not come here and ask for every little thing--I'd learn it better
this way.
There are 3 different C++ wrappers here:
Just a correction... I am using Linq to SQL classes, not EDMX files. So I
can only create a db connection in server explorer, will I able to drop the
tables from there to linq to sql classes designer.
Thanks.
-Original Message-
From: Suresh Kumar R
Sent: Sunday, May 15, 2011 1:23 PM
Thanks for taking the time to respond. But I'd prefer to learn to use SQLite.
If I use one of these wrappers, I have to depend on someone to maintain it
anytime SQLite is updated. And from what I can tell, the last update to the
wrapper code was I n 2007.
Just as an example, I'm currently
Hi
Any idea how to install System.Designer.dll file? I tried installing it as per
the below link with below xml file as extension xml file.
I created a custom extensions folder under C:\Program Files (x86)\Microsoft
Visual Studio 10.0\VSTSDB\Extensions and copied the System.Designer.dll file
The official programming API is in C and Tcl.
If you want C++ API, you need to use 3rd party wrappers or write your own.
To use C API, go to SQLite Programming Interfaces section at
http://sqlite.org/docs.html
On May 15, 2011 5:39 PM, Don Ireland sql...@donireland.com wrote:
Thanks for taking
On Sun, May 15, 2011 at 11:39 AM, Don Ireland sql...@donireland.com wrote:
Thanks for taking the time to respond. But I'd prefer to learn to use
SQLite.
Then use sqlite's API. Why require C++? sqlite's API can be used just fine
from C++ programs.
If I use one of these wrappers, I have to
On 05/13/2011 03:15 PM, Trevor Borgmeier wrote:
I have a database where a field's value is a comma separated list
indicating the basic categories the item belongs to.
so if the categories field has a value of 1,8,15
I want to do a query like this:
SELECT categories FROM myTable WHERE 8 IN
I wrote one wrapper, that can be compiled, like sqlite3, in your C++
program.
It doesn't rely on any third library except sqlite3.
The update of sqlite3 is just done by replacing the amalgamation files.
https://gitorious.org/sylisa-dblite/sylisa-dblite
It uses the syntax borrowed from soci++,
Pontiac pontia...@gmail.com wrote:
On 05/13/2011 03:15 PM, Trevor Borgmeier wrote:
SELECT categories FROM myTable WHERE (,||categories||,) LIKE %,7,%;
Careful with how you have your like. As an added bonus, if you were to
hunt for category 1, your statement would be LIKE %,1,% which would
I keep getting an SQL error
unable to open database file
after doing some 20 inserts into two tables of my database in a loop
in a java function.
In the main code I have
String sql=INSERT INTO part(name,md5sum,size,pfad) VALUES (?,?,?,?);
String sql1=INSERT INTO
Not off topic, but i'm confused about why you explicitly need C++ for that.
I never said I need C++ not C. I asked for sample code for use in C++. If C
code will work just fine then sample C code would be fine and dandy with me.
Don Ireland
-Original Message-
From: Stephan Beal
I never said I need C++ not C. I asked for sample code for use in C++. If C
code will work just fine then sample C code would be fine and dandy with me.
I've already been reading through the docs you pointed me to. But it's kinda
hard to wrap my head around--they even start out warning that
On 15 May 2011, at 3:58pm, Don Ireland wrote:
I never said I need C++ not C. I asked for sample code for use in C++. If C
code will work just fine then sample C code would be fine and dandy with me.
See the end of
http://www.sqlite.org/quickstart.html
after that, Google on 'sqlite c sample
This is a little out there but I've been thinking about it and wondered if
anyone had any comments:
I've been using sqlite3 under iOS fine in FULLMUTEX mode, but it dies horribly
with NOMUTEX and I'm pretty sure this is because of my use of Grand Central
Dispatch (GCD).
GCD is related to
There a BUNCH of SQLite objects shown when I look through the object browser.
I was hoping to find samples for using those.
But I can figure out how to use the code from the link.
Don Ireland
-Original Message-
From: Simon Slavin slav...@bigfraud.org
To: General Discussion of SQLite
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 09:37 AM, Steven Parkes wrote:
I've been using sqlite3 under iOS fine in FULLMUTEX mode, but it dies
horribly with NOMUTEX
What problem are you trying to solve by getting rid of SQLite's mutexes?
Even if you remove them you still
I've been using sqlite3 under iOS fine in FULLMUTEX mode, but it dies
horribly with NOMUTEX
What problem are you trying to solve by getting rid of SQLite's mutexes?
Even if you remove them you still have to add the same thing back in again
to ensure you don't use SQLite internals
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 10:45 AM, Steven Parkes wrote:
Not trying to throw them away ...
Isn't that exactly what NOMUTEX does?
trying to switch from Serialized to Multi-thread. My reading of the docs
says that that's what SQLITE_OPEN_NOMUTEX does. Did I
Isn't that exactly what NOMUTEX does?
The docs (http://www.sqlite.org/threadsafe.html) say
The SQLITE_OPEN_NOMUTEX flag causes the database connection to be in the
multi-thread mode and
the SQLITE_OPEN_FULLMUTEX flag causes the connection to be in serialized mode.
Is this wrong?
Hello,
a friend of mine needs to read from an SQLite database that I made. He
needs to do it in Java, and what's special about the database is that it
contains some indexes which are based on a custom collation (German
umlaut).
Does anyone know of a recommendable java library (JDBC or else)
Thanks! I will study the sqlite3_auto_extension closer. I had trouble
compiling the extc file, but I can't remember what the errors were
and I just got back in town, so I will have to work my back to trying to
compile it.
Steve.
On 05/10/2011 01:24 PM, Mays, Steve wrote:
Question 1.)
Am 15.05.2011 20:43, schrieb Amy and Steve:
Thanks! I will study the sqlite3_auto_extension closer. I had trouble
compiling the extc file, but I can't remember what the errors were
and I just got back in town, so I will have to work my back to trying to
compile it.
I remember I had also
Ah, crud. I kinda forgot I had a WAL checkpoint thread running. I thought I had
disabled that a long time ago. And it was sharing a connection on a different
thread.
Fixing that, things seem stable under GCD with SQLITE_OPEN_NOMUTEX.
I'm still not 100% sure if there's a problem sharing
Hi,
SQLite probably was intended as an embedded database for standalone
software. However, because of its promotion by PHP community, it's been used
to power websites. I use it for that purpose too and prefer it over other
SQL DB solutions (primary because it allows me to move/backup data from a
On 15 May 2011, at 10:33pm, romtek wrote:
So, I am asking developers of SQLite to make it easy for tool developers to
offer the ability to rename attributes.
The SQL specification does not use the term 'attribute' in any way that would
give them names. Can you explain what you mean by
On Sun, May 15, 2011 at 4:39 PM, Simon Slavin slav...@bigfraud.org wrote:
On 15 May 2011, at 10:33pm, romtek wrote:
So, I am asking developers of SQLite to make it easy for tool developers
to
offer the ability to rename attributes.
The SQL specification does not use the term 'attribute'
On May 15, 2011, at 5:05 PM, romtek wrote:
On Sun, May 15, 2011 at 4:39 PM, Simon Slavin slav...@bigfraud.org wrote:
On 15 May 2011, at 10:33pm, romtek wrote:
So, I am asking developers of SQLite to make it easy for tool developers
to
offer the ability to rename attributes.
The SQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 11:14 AM, Steven Parkes wrote:
Isn't that exactly what NOMUTEX does?
The docs (http://www.sqlite.org/threadsafe.html) say
The SQLITE_OPEN_NOMUTEX flag causes the database connection to be in the
multi-thread mode and
the
On 15 May 2011, at 11:05pm, romtek wrote:
I will give you an example, and you correct my use of the terms, please.
A table:
id, eventName, date
I want to rename date to dateAdded.
Okay, that's a column name, and you want the ability to rename columns.
People currently jump through
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 03:05 PM, romtek wrote:
I want to rename date to dateAdded.
People currently jump through hoops in order to achieve such a simple (from
the user's point of view) and needed goal:
Am Sun, 15 May 2011 17:10:53 -0500 schrieb Mr. Puneet Kishor:
sqlite doesn't support changing the name of a table column (and, neither you
nor
your user should be doing this -- there is something strange with your app
requirements). That said, you can rename a column by creating a new table
Has anyone implemented the search result ranking function in Perl?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am trying to get time stamps to be reported as '10:33 AM' and '1:27 PM'
instead of '10:33' or '13:27'. I don't see any formatting options to return the
time in 12-hour format with AM/PM suffixed. Am I missing something, or do I
have to roll my own?
Puneet.
on 5/14/11 9:02 AM Trevor Borgmeier wrote:
...I was surprised when I tried a similar query with the same data in MySQL
and saw that it worked -- MySQL parsed the fields contents as if they were
separate items.
I just wanted to correct my statement about my MySQL query -- I wasn't
using IN, I
On Sun, May 15, 2011 at 10:39:22PM +0100, Simon Slavin scratched on the wall:
On 15 May 2011, at 10:33pm, romtek wrote:
So, I am asking developers of SQLite to make it easy for tool developers to
offer the ability to rename attributes.
The SQL specification does not use the term
I'm still not 100% sure if there's a problem sharing connections across
threads with SQLITE_OPEN_NOMUTEX as long as I guarantee that they aren't
concurrent. I suspect there aren't, but I'm not 100% sure. Any case where
sqlite3 would be less than happy that pthread_self wasn't always the
But apparently your not 100% sure is actually it's not
true in this case (as your tests showed).
No, I think we're good. As long as one is very careful (as Roger mentioned),
it seems to work fine under GCD. I was kinda reaching, thinking that moving
across threads mattered.
I was being very
Mr. Puneet Kishor punk.k...@gmail.com wrote:
I am trying to get time stamps to be reported as '10:33 AM' and '1:27 PM'
instead of '10:33' or '13:27'. I don't see any
formatting options to return the time in 12-hour format with AM/PM suffixed.
Am I missing something, or do I have to roll my
On Sun, May 15, 2011 at 5:10 PM, Mr. Puneet Kishor punk.k...@gmail.comwrote:
A table:
id, eventName, date
I want to rename date to dateAdded.
sqlite doesn't support changing the name of a table column (and, neither
you nor your user should be doing this -- there is something
On Sun, May 15, 2011 at 5:27 PM, Roger Binns rog...@rogerbinns.com wrote:
Wanting to rename a column should be a rare thing since it is so rare. If
you are frequently renaming columns then your code will be very brittle.
I was describing what I have to do during design time, which often
On Sun, May 15, 2011 at 9:44 PM, romtek rom...@gmail.com wrote:
On Sun, May 15, 2011 at 5:10 PM, Mr. Puneet Kishor punk.k...@gmail.comwrote:
I want to rename date to dateAdded.
sqlite doesn't support changing the name of a table column (and, neither
you nor your user should be doing this --
On Sun, May 15, 2011 at 5:22 PM, Simon Slavin slav...@bigfraud.org wrote:
Yeah, you have to fake it by making a new table. You want support for more
ALTER TABLE variants. The proper way to do it would be to
ALTER TABLE myTable ADD COLUMN dateAdded
UPDATE myTable SET dateAdded = date
ALTER
On Sun, May 15, 2011 at 10:05 PM, Nico Williams n...@cryptonector.comwrote:
Right, well, SQLite3 doesn't support renaming columns. Internally
SQLite3 only stores the CREATE statements for all schema elements
(plus actual b-trees for tables and indexes). Specifically SQLite3
does not store
On Sun, May 15, 2011 at 10:00 PM, Roger Binns rog...@rogerbinns.com wrote:
On 05/15/2011 07:48 PM, romtek wrote:
I was describing what I have to do during design time, which often
happens
after a website has been launched and is operational.
Huh? You launch and have a site in production
On May 15, 2011, at 10:49 PM, romtek wrote:
Let's not make this issue into something that it's
not.
Let's not.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
It's perfectly fair to ask for a feature. And ALTER TABLE rename
column support is a well justified feature to want, IMO; I don't blame
you for wanting it. Whether it will be added, or when, I'd not know.
The dev team (whom I do not speak for) has its priorities, and its
paying customers to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/15/2011 08:49 PM, romtek wrote:
I don't know about how things work in your world, but in mine requirements
for apps change sometimes, so I have to enter design stage after an app (may
be a website) has been released. Perhaps, you are a
Am 15.05.2011 16:04, schrieb Christoph P.U. Kukulies:
I keep getting an SQL error
unable to open database file
after doing some 20 inserts into two tables of my database in a loop
in a java function.
In the main code I have
String sql=INSERT INTO part(name,md5sum,size,pfad) VALUES
49 matches
Mail list logo
