SQLite Forum

SQLite3 interfacing with MS SQL Server
Login
Ok, I'll follow your suggestion of asking elsewhere.

But, I am not combining <i>select</i> with <i>set</i>. In fact, I am trying to do an update:

<strong>UPDATE OPENQUERY([SQLITE3],'select s from log') SET s='hello'</strong>

equals

<strong>UPDATE log SET s='hello'</strong>

in SQLite3.... It's a tweak of SQL Server....