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 receive
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 discussed extensively
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 within a
> given changed
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
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 Mistach
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-
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
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 Constraints. Then
> I tested it, and
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 a
9 matches
Mail list logo