TSQLQuery lookup field?

[panoss]

I 'm trying to make a lookup field in a TSQLQuery.
Right click->Edit fields->Create new fields->LookUp.
I choose the 'Dataset' from the drop down list and a message appears:
"Access violation.

Press OK to ignore and risk data corruption.
Press Cancel to kill the program."

If I press cancel, Lazarus gets killed.

If I press Ok, 'LookUp keys' combo and 'Result field' combo are disabled.
In 'keyfields' combo, I can type the field name, but there's no list of fields.

[mangakissa]

The lookupfiels will not work in TSQLQuery as you expect. Is there a reason to create this lookupfield?

[exdatis]

Of course you can use select query to show everything but also you can create new field lookup-type. It works excellent.
see: http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdblookupcombobox.html

I guess that the problem is an active SqlQuery, try to set query active tru or false and then try again

p.s. http://wiki.freepascal.org/dblookupcombobox
       http://free-pascal-lazarus.989080.n3.nabble.com/Lazarus-How-to-use-DBCombobox-td4024465.html

[panoss]

The lookupfiels will not work in TSQLQuery as you expect. Is there a reason to create this lookupfield?

I have a grid which takes data from the table OrderDetails.
The table has a field, productID.

Another table, Products, has the fields ProductD and Name.

I want in the grid to show the product Name, not the productID that is shown now.

So I thought of a lookup field, like in ms Access.

[panoss]

Of course you can use select query to show everything but also you can create new field lookup-type. It works excellent.
see: http://lazarus-ccr.sourceforge.net/docs/lcl/dbctrls/tdblookupcombobox.html

I guess that the problem is an active SqlQuery, try to set query active tru or false and then try again

How do I create a lookup field?
I 'm using SQLite.

[exdatis]

See :
/usr/share/lazarus/1.2.6/examples/database {* this is path on Debian 7.7 *}
there is an example: dblookup and sqlitetutorial(find it in lazarus folder).

[exdatis]

So I thought of a lookup field, like in ms Access.

Use fields editor to create new field(query->fields)
(M$access is not similar)

[panoss]

So I thought of a lookup field, like in ms Access.

Use fields editor to create new field(query->fields)
(M$access is not similar)

You mean a new field in the TSQLQuery?

[panoss]

See :
/usr/share/lazarus/1.2.6/examples/database {* this is path on Debian 7.7 *}
there is an example: dblookup and sqlitetutorial(find it in lazarus folder).

There are no lookup fields in these examples. (or maybe there are but I can't understand them. Also, in the dblookup they use DBase database)

[talorigomat]

Hi Panoss

I also had the access violation error when I tried to set up a lookup field.  After I recieved this error I restarted Lazarus and opened the project again.  Before trying to set up the Lookup field set all the relevant TSQLQuery(s) to active so that the TSQLQuery that you want to set up the lookup filed is showing some data.  Then proceed as before.

[panoss]

Before trying to set up the Lookup field set all the relevant TSQLQuery(s) to active

I tried this and returns me error: 'no such table: Products'.
(the table, of course, exists)
The Connection and the Transaction (the respective ones to my TSQLQuery) are active.

[exdatis]

OnHold field is created as new field, calculated, boolean, the same way as create lookup field

[panoss]

exdatis read my first post.

[exdatis]

I tried this and returns me error: 'no such table: Products'.
(the table, of course, exists)
The Connection and the Transaction (the respective ones to my TSQLQuery) are active.

I can't understand? Do you have TSQLQuery which use table Products and TDataSet which use query Products?

[panoss]

I guess I'm doing something wrong.
I must tell you how each component connects to the others.
I use 4 components:

Code: [Select]

TSQLite3Connection
name: Connection
DatabaseName: data
Transaction: Transaction

TSQLTransaction
name: Transaction
Database: Connection

TSQLQuery
name: qryProducts
Database: Connection
Transaction: Transaction
SQL: Select * FROM Products

TDataSource
name:DataSource
DataSet: qryProducts