SQLite Forum

Timeline
Login

2 forum posts by user vikingoarg2

2021-09-21
22:00 Reply: Number=Number (artifact: 18ffc0026a user: vikingoarg2)

ok, THNKS!

21:38 Post: Number=Number (artifact: f11d2d64cb user: vikingoarg2)

Hi All, Can you help me to understand this?

this query does not working with some records that are equals:

CREATE TABLE CTRL_PAGOS_TRX AS SELECT a.ACCT_CODE, a.acct_id, '' ESTADO_CONTROL, cast(a.NEW_CREDIT as REAL) as NEW_CREDIT, CAST(ifnull(B.trx_amt,0) AS REAL) AS PPM FROM BILL_INVOICE a LEFT JOIN MOVIMIENTOS_TRX B ON B.acct_id=A.acct_id AND B.trans_type='PPM';

UPDATE CTRL_PAGOS_TRX SET ESTADO_CONTROL='OK' WHERE (NEW_CREDIT=PMA);

I try to set or cast fileds to TEXT or REAL but not match in some equal values:

NEW_CREDIT=PMA -1450.97=-1450.97 -1041.3=-1041.3 -2409.72=-2409.72

Thnks!