provider flags are hiding from me lazarus / 16-Databases ---------------------------------------------------------------------- 3rdshiftcoder · 2020-12-14 02:48 Hi all- I am trying to find the flags to let me update one side of 2 joined tables if that is possible. the sql for firebird looks kind of like this: Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i select *  from A  join B on A.id = B.code I can't seem to find any reference to provider flags in IDE. using lazarus db controls. I double clicked on tsqlquery in my data module and added fields there and in the grid control. the query returns fields but they are not editable. I didn't see where the edit button in the navigator control is lit up. thanks, robo-loki ---------------------------------------------------------------------- 3rdshiftcoder · 2020-12-14 02:56 Hi - I can just confirm that I got a read only on tsqldb control. I have to figure out possibly how to set a flag or 2. Not sure. thanks ---------------------------------------------------------------------- 3rdshiftcoder · 2020-12-14 03:05 https://forum.lazarus.freepascal.org/index.php?topic=38723.0 that seems to work. very cool. robo-loki