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.
UPDATE EventTable
SET Date='D.+19110402..+00000000..' , SortDate='6705438749380050956'
WHERE Date='D.+19110000..+00000000..' AND EventType='18';
Near "-": syntax error - help
Posted - 02/04/2013 : 17:50:54
