[Kexi] parameter query

Jarosław Staniek js at iidea.pl
Fri Oct 20 09:42:33 CEST 2006


Bruce Hohl said the following, On 2006-10-18 13:26:

> Is it possible to create a "parameter" query in Kexi
> which will ask the user to input a value to be used in
> the query.  (I want to create this query using the
> query design tool.)  
> 
> As an example in MS Access I would use the following
> SQL to achieve this:  SELECT DISTINCTROW
> tblItemMaster.ITEM, tblItemMaster.ITEM_DESC,
> tblItemMaster.TOT_ROLCST, tblItemMaster.PRICE FROM
> tblItemMaster WHERE (((tblItemMaster.ITEM)=[enter
> part]));
> 
> In Access my parameter is "[enter part]".
> Thanks for any help with this.

This is not available yet. I am considering this addition in version 1.1.1.

-- 
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on
  Kexi & KOffice: http://www.kexi-project.org, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org



More information about the Kexi mailing list