Re: [sqlite] Can this be done in one query?

Kai Peters wrote: I do have an audit table with this structure: AuditID ChangeDate RowID (foreign/primary key in TableName) ActionType TableName and I want to query for records pertaining to a certain table name within a given changedate range. I do, however, only want to

Re: [sqlite] Can this be done in one query?

Kai Peters wrote: > and I want to query for records pertaining to a certain table name within a > given changedate range. > I do, however, only want to receive the last (ChangeDate) record in cases > where more than one record > per rowid exist. A very similar problem was

Re: [sqlite] Can this be done in one query?

On 9 Sep 2012, at 5:19am, Kai Peters wrote: > I do have an audit table with this structure: > > AuditID > ChangeDate > RowID (foreign/primary key in TableName) > ActionType > TableName > > and I want to query for records pertaining to a certain table name

[sqlite] Can this be done in one query?

Hi all, I do have an audit table with this structure: AuditID ChangeDate RowID (foreign/primary key in TableName) ActionType TableName and I want to query for records pertaining to a certain table name within a given changedate range. I do, however, only want to receive the last

Re: [sqlite] System.Data.SQLite and .NET 4.5

Nicolas Rivera wrote: > > Does System.Data.SQLite support .NET 4.5? > It has not been tested with the .NET Framework 4.5; however, I am not of any reason(s) why it will not work. I do know that it will not work in WinRT, due to the complete lack of ADO.NET in that environment. -- Joe

[sqlite] System.Data.SQLite and .NET 4.5

Hi, Does System.Data.SQLite support .NET 4.5? The downloadable binaries only come in 3.5 and 4.0 flavors (although it is possible for assemblies to support multiple .NET versions). Thanks, Nick ___

[sqlite] Disks lie

One topic that comes up here from time to time is the difficulty of ensuring ACIDity and resilience under power failure, even if your code is 100% correct, because the OS lies to your app and hardware lies to the OS. It's difficult explaining this stuff because a programmer /has/ to rely on OS

Re: [sqlite] Foreign Key

On 7 September 2012 21:28, Dennis Klein wrote: > Hallo, > > I am Using the latest Version of the precompiled shell Application from the > Download section, and the C/C++ Sources in Version 3.7.11 > > Now i created my tables, using Primary Key and Foreign Key

[sqlite] Foreign Key

Hallo, I am Using the latest Version of the precompiled shell Application from the Download section, and the C/C++ Sources in Version 3.7.11 Now i created my tables, using Primary Key and Foreign Key Constraints. Then I tested it, and inserted test data, with a foreign key which doesn't exist