Guest User

Untitled

a guest
Jul 16th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. CASE WHEN EXISTS(SELECT 1 FROM Transactions WHERE Hash='VLEYCBLTDGGLHVQEWWIQ' AND Time=1531739096)
  2. THEN UPDATE Transactions SET BlockID=0, PoolHeight=NULL WHERE Hash='VLEYCBLTDGGLHVQEWWIQ' AND Time=1531739096
  3. ELSE INSERT INTO Transactions (Hash, Time, _From, Signature, Mode, BlockID, OutputValue, PoolHeight) VALUES('VLEYCBLTDGGLHVQEWWIQ',1531739096,'GENESIS','GENESIS',-1,0,0,NULL)
  4. END;
  5.  
  6. System.Data.SQLite.SQLiteException: 'SQL logic error near "CASE": syntax error'
Add Comment
Please, Sign In to add comment