Wednesday, December 7, 2016, 9:15:57 AM, you wrote:
Thanks Ryan, this looks very useful, think I've got what I need now to
make it work!
Richard
>> But how do I do this for multiple records and mutiple fields? I
>> imagine I need to use SQLiteTransaction here but I'm not sure about
>> the syntax
Wednesday, December 7, 2016, 3:12:05 AM, you wrote:
>> On Dec 6, 2016, at 5:40 PM, Richard Andersen wrote:
>>
>> cmd.CommandText = @"UPDATE pdata SET FileName = @fileName WHERE FileName =
>> 'filename.zip'";
> You can add other columns to set
I have a table with several thousand records each with multiple
fields. One field contains a filename, this is the only unique field
so I use it to identify the different records.
What I need is a way to update all fields that have changed in any
record, at once. There's no need to check IF a re
ite library -
> not included)." That is, you have to provide a SQLite3 DLL
> supporting the encryption scheme of your choice. For example,
> - SQLCipher (https://github.com/sqlcipher/sqlcipher), you have to build the
> DLL yourself
> - wxSQLite3 (https://github.com/utelle/wxsql
encrypted using
> the encryption in system.data.sqlite. I use SQLITE Expert. It allows you
> to replace the standard library which does not support encryption to one
> from the system.data.sqlite that does. It is the interop dll that you
> replace. Then after entering the password,
I'm using the ADO.NET version (System.Data.SQlite).
I've created an RSA encrypted database using SQLite2009 and that is
working fine, but I can't find any tools for editing the table in
SQLite2009 once it's been created. Is it possible at all?
In DB Browser for SQlite I can edit the table but I
6 matches
Mail list logo