I'm new to sql and have achieved simple table upates before but with this one I keep running into trouble. Please ignore the data format it is accurate, just the syntax hang up for whatever reason.
All variotions of wrapping the data come up with 'near "-": syntax error', I am using SQLiteSpy to modify the database in question.
Any advice very welcome.
SET Date='D.+19110402..+00000000..' , SortDate='6705438749380050956'
WHERE Date='D.+19110000..+00000000..' AND EventType='18';