Extracting the contents of a record's field.

[BigChimp]

Strange.

Did
- an sql query
- bound to the existing ibconnection+transaciton
- not bound to the datasource
not work?

Having the lookup query in the same transaction as the grid lets it show the same data...

[Pascaluvr]

cov,

I am a newbie also and just learning this stuff by trial and error - so  what I say may be wrong (or inefficient) but it works for me:

1.  You only need one Transaction (I don't know about other dbms, but sqlite will not allow a transaction within a transaction.    So far, i have not  found a need for a 2nd Transaction)

2.  To access the a second 'select' without losing the first, you not only need a 2nd Query, but also a 2nd Datasource (and prossibly a 2nd DBgrid to display it).

3.  Since you need to access columns that you don't want displayed, simply:

Code: [Select]

        DBGrid1.Columns[x].Visible := False; 
(where x= column not to be displayed but you still wish to access, x=0 is first column)

Hope this helps

[teos]

I wonder if using a second sqlquery component would work (with its own datasource and dbgrid) and using the afterscroll event to fill parameters of a second sqlquery which is then opened. (would give the right record and also only records required).

A pitty that master-detail is not implemented which would handle that on the fly.

b.t.w.: I think that ZTable with use of master-detail could be easier..

[BigChimp]

http://wiki.lazarus.freepascal.org/MasterDetail

[teos]

Okay.. missed it. But nevertheless the link provides a perfect answer.

[cov]

Thank you.

I'll look at that.