Why I have this error with FireDac (Delphi 10.1 update 2)
Why I have this error with FireDac (Delphi 10.1 update 2)
I use PostgreSQL 9.6, table name "user" and column id is primary key(UUID).
https://drive.google.com/open?id=0B48WrMOs1-o6SkNRN005bXRSZjQ
I use PostgreSQL 9.6, table name "user" and column id is primary key(UUID).
https://drive.google.com/open?id=0B48WrMOs1-o6SkNRN005bXRSZjQ
Rik van Kekem Thank you very much.
ReplyDeleteNow, FetchOptions.CursorKind to ckDefault, it display 2 rows if I set TFDTable1.Active := true on Form.Create.
But if set TFDTable1.Active := true on design time it display : "Duplicate row found on unique index".
My PostgreSQL database has "Collate = English_United States.1252"
And FDConnection1.FormatOptions.SortLocation = 1033 ( MAKELCID(MAKELANGID (LANG_ENGLISH, SUBLANG_ENGLISH_US), SORT_DEFAULT) = 1033). FDConnection1.FormatOptions.SortOptions := [soNoSymbols];
Then you're getting the exact error that is mentioned here: http://docwiki.embarcadero.com/RADStudio/Berlin/en/TFDTable_Questions. So you need to set those options so that the client sort order will match the database sort order. (I have no experience with FireDac/PostgreSQL so I'm not sure what you need to set exactly)
ReplyDeleteRik van Kekem Thank you very much.
ReplyDelete