On 4 January 2013 05:35, Petite Abeille wrote:
>
> On Jan 3, 2013, at 10:19 AM, nospam.nospam.nos...@gmail.com wrote:
>
>> I'm trying to create two queries so I can determine which of the keys
>> for a given sqlite3 table is the primary key and which keys are
>> foreign.
Perfect! Exactly what I needed
Thanks a lot,
- Levi
- Original Message -
From: d...@sqlite.org
To: LEVI HASKELL (BLOOMBERG/ 731 LEXIN)
Cc: sqlite-users@sqlite.org
At: Jan 1 2013 09:03:00
On Thu, Dec 27, 2012 at 11:43 AM, Levi Haskell (BLOOMBERG/ 731 LEXIN)
On Jan 3, 2013, at 10:19 AM, nospam.nospam.nos...@gmail.com wrote:
> I'm trying to create two queries so I can determine which of the keys
> for a given sqlite3 table is the primary key and which keys are
> foreign.
pragma table_info() returns a 'pk' attribute. You can use that to identify the
On 3 Jan 2013, at 6:11pm, Simon Slavin wrote:
> On 3 Jan 2013, at 5:29pm, Quanren Xiong wrote:
>
>> Just curious. Do you know how the Visual Studio Designer works?
>> In designer, the Null value is converted to 0.
>
> In SQL null is not 0. 'null'
On 3 Jan 2013, at 5:29pm, Quanren Xiong wrote:
> Just curious. Do you know how the Visual Studio Designer works?
> In designer, the Null value is converted to 0.
In SQL null is not 0. 'null' means 'value missing' or 'value unknown'. It is
closer to NaN = NotANumber.
> Hi,
>
> I'm a complete sql novice so please go easy :)
>
> I'm trying to create two queries so I can determine which of the keys
> for a given sqlite3 table is the primary key and which keys are
> foreign.
Hello,
I did not fully review your question detail, but perhaps this may help.
The
Seems like a strange thing for VS Designer to do. NULL is not 0.
RobR
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Quanren Xiong
Sent: Thursday, January 03, 2013 12:30 PM
To: General Discussion of SQLite Database
Hi Joe,
Just curious. Do you know how the Visual Studio Designer works?
In designer, the Null value is converted to 0.
I would like to something similar.
Thanks
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Joe
Quanren Xiong wrote:
>
> I mapped a Sqlite INTEGER field to a C# Nullable property in EF 5.0.
>
> When the field is NULL, Visual Studio throws exception with following
info:
>
The method throwing the exception
(System.Data.SQLite.SQLiteDataReader.GetInt64)
does not attempt to automatically
Denis Burke wrote:
>
> Moving from v1.0.81.0 to v1.0.83.0 (no code changes on my part), results
in
> a change in reported state from the SQLiteConnection.State property.
>
The change causing the behavior you are seeing was made in release 1.0.82.0.
Prior to that release, opening a connection
Hi All,
I mapped a Sqlite INTEGER field to a C# Nullable property in EF 5.0.
When the field is NULL, Visual Studio throws exception with following info:
-***-
Message "Specified cast is not valid." string
nospam.nospam.nos...@gmail.com wrote:
> I'm trying to create two queries so I can determine which of the keys
> for a given sqlite3 table is the primary key
SQLite does not give you this information. PRAGMA index_list gives
you only indexes, but if the primary key is the ROWID, there is no
Hi,
I'm a complete sql novice so please go easy :)
I'm trying to create two queries so I can determine which of the keys
for a given sqlite3 table is the primary key and which keys are
foreign.
I understand that sqlite's pragmas aren't queryable so I have some
code that moves the result set
Moving from v1.0.81.0 to v1.0.83.0 (no code changes on my part), results in
a change in reported state from the SQLiteConnection.State property.
I could not find any documentation/bug fixes which indicates that this is
an expected change.
Background info:
Vb.net app, .NET 3.5SP1, VS 2010,
On 12/21/2012 05:18 PM, Dan Kennedy wrote:
Thanks. I think it's this:
http://www.sqlite.org/src/info/0cfd98ee20
Dan.
You are right. I have been re-reading our mail thread and this is
exactly what happens. I have build a SQLite
version from the latest version in the archive (3.7.16) and
15 matches
Mail list logo