Re: [sqlite] syntax error near AS

Do you know of any implementation of SQL that accepts an AS clause for the updated table? I don't think any do. Some versions have a FROM extension and you CAN specify an alias for the updated table in that clause, however, as far as I know the update table cannot be aliased and the "set =

[sqlite] syntax error near AS

Hi Wondering if someone else can spot the syntax error in the following statement. "locns" is an attached database. There are four "AS" terms in the statement, they all alias tables. Ok, found it. It seems that an alias for an "UPDATE" table name is not permitted. Is there a particular

Re: [sqlite] Sqlite problem with opening database

On 5 Jul 2017, at 1:41pm, Gregor Pavuna wrote: > As it seems there's some sort of server problem(Windows 2012 server). My > guess is server is caching 64bit files and serving them to 32bit operating > systems. I tested on my test server with laptop (32bit windows 7) and

Re: [sqlite] Error Message "The database disk image is malformed"

> On Jul 5, 2017, at 5:29 AM, Manoj Sengottuvel wrote: > > I have encrypted the db using SEE. After that I got the message - Error > Message "The database disk image is malformed". Generally that means you gave the wrong password (or didn’t give a password) before

Re: [sqlite] Sqlite problem with opening database

Hey Simon, no i am not mixing, because it works on most of the clients 32bit and 64bit. That one is exception (well on several PCs, two different clients). As it seems there's some sort of server problem(Windows 2012 server). My guess is server is caching 64bit files and serving them to 32bit

Re: [sqlite] Sqlite problem with opening database

On 5 Jul 2017, at 8:36am, Gregor Pavuna wrote: > System.BadImageFormatException: An attempt was made to load a program with > an incorrect format. (Exception from HRESULT: 0x8007000B) Obtain and log the properties of this error:

[sqlite] Error Message "The database disk image is malformed"

Hi Richard, I have encrypted the db using SEE. After that I got the message - Error Message "The database disk image is malformed". Regards, Manoj ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Sqlite problem with opening database

Good day, I'm turning on you, since i have no general idea how to solve this. I googled a lot of similar questions and tried them all, but without success. I tried to compile to x86 only, prefer 32bit only, . Let me explain my situation: Application was built for Any CPU and is supposed