Android Question [SOLVED] REPLACE INTO

makis_best

Active Member
Licensed User
The only problem I have is that I can't use two conditions using it
I mean I have a table created...
B4X:
CREATE TABLE IF NOT EXISTS positions (
    id integer PRIMARY KEY,
    title text NOT NULL,
    min_salary numeric,
      tts String
);
I want to do a replace into when the id is known and the tts differ.

Something like
B4X:
REPLACE INTO positions (id, title, min_salary, tts)
VALUES
    (2, 'New Sullary', 1100, 'Full') WHERE tts <> 'Low';
 
Top