Data source query from dialog »

[steros]

I have to set sql of datasource based on dialog form input, like:
 ... where [db_field]=$S{Dialog.lineEdit.text}

How can I do ?

Thanks

[Arin Alex]

Hi!
You can create a query with a variable like this:

Code: [Select]

Select * from customers where CustomerId = $V{CustomerID}
then create some dialog with the line editor for example.
In the init script you can write something like this:

Code: [Select]

Dialog.lineEdit.text = getVariable("CustomerID")
Dialog.exec();
setVariable("CustomerID",Dialog.lineEdit.text)
 

[steros]

Perfect, it works ! Thank you very much !