Android Question [SOLVED] REPLACE INTO

DonManfred

Expert
Licensed User
Longtime User
It is part of the SQLite language. Why it should not work? Do you get any error using it?
 
Upvote 0

makis_best

Well-Known Member
Licensed User
Longtime 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';
 
Upvote 0
Top