provider flags are hiding from me

[3rdshiftcoder]

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][+][-]

1. select *
2.   from A
3.   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]

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]

https://forum.lazarus.freepascal.org/index.php?topic=38723.0

that seems to work.
very cool.

robo-loki