BUG UNIDAC INCORRECT DATA SHOWN

[mboloz]

UniDAC 5.1.4
Delphi 7
Sqlite3


This is my sqlite table design :

Code: Select all

CREATE TABLE [barang] (
  [kodebrg] VARCHAR(15) NOT NULL ON CONFLICT ABORT, 
  [barcode] VARCHAR(25) DEFAULT 0, 
  [namabrg] VARCHAR(55), 
  [satuan] VARCHAR(10) DEFAULT Pcs, 
  [jenis] VARCHAR(20), 
  [harga] INT DEFAULT 0, 
  [stokmin] INT DEFAULT 1, 
  [stokawal] INT DEFAULT 0, 
  [stokakhir] INT DEFAULT 0, 
  [expired] DATE NOT NULL DEFAULT CURRENT_TIMESTAMP, 
  [ket] TEXT, 
  CONSTRAINT [sqlite_autoindex_barang_1] PRIMARY KEY ([kodebrg]) ON CONFLICT ABORT);

CREATE TABLE [masukdetail] (
  [kodebrg] VARCHAR(15) CONSTRAINT [FKbarang] REFERENCES [barang]([kodebrg]) ON DELETE CASCADE ON UPDATE CASCADE, 
  [expire] DATE, 
  [qty] INTEGER, 
  [retur] INTEGER, 
  [total] INTEGER);

CREATE TRIGGER [TG_STOKMASUK]
AFTER INSERT
ON [masukdetail]
FOR EACH ROW
BEGIN
UPDATE barang SET stokakhir=stokakhir+NEW.qty, expired=NEW.expire
WHERE kodebrg=NEW.kodebrg;
END;

after insert on the second table, there are trigger execute to update date field, on the sqlite manager show the correct, but in my delphi application shown 31/12/1899, even the date inserted to the second table not that

i just tried requery, refreshing the table, uniquery or unitable just the same..
but work fine in zeos...

[img=http://s21.postimg.org/cbc7ub9tf/image.jpg]

[AlexP]

Hello,

We cannot reproduce the problem. Please send a small sample demonstrating the problem (including the SQLite database file) to alexp*devart*com