Devart Forums

Code: Select all

-- Table: cec.messagesservice
-- DROP TABLE cec.messagesservice;

CREATE TABLE cec.messagesservice
(
    dtmess timestamp without time zone NOT NULL DEFAULT now(),
    priority smallint NOT NULL DEFAULT 5,
    message text COLLATE pg_catalog."default" NOT NULL,
    id numeric(20) NOT NULL,
    status character varying(20) COLLATE pg_catalog."default",
    CONSTRAINT messagesservice_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE cec.messagesservice OWNER to cec;
GRANT ALL ON TABLE cec.messagesservice TO cec;

Code: Select all

SELECT ID, MESSAGE 
FROM MessagesService
WHERE STATUS='AAA'
ORDER BY PRIORITY DESC, DTMESS, ID
FOR UPDATE

Code: Select all

if (!QGetMessage->Prepared)
        QGetMessage->Prepare();