Adding parameter to query

User enters a number in a field
System shows that amountPaids which is greater than the number

My code below;

SEL ECT
Sales.Number AS Number,
Sales.Date AS Date,
Sales.AmountPaid AS AmountPaid,
Sales.PaymentMethod AS PaymentMethod
FR OM
Document.Sales AS Sales

WHERE AmountPaid > what I need to write here
ORDER BY AmountPaid DESC

Attached Files

Download InkedAmountPaid_LI.jpg (0.88 MB)

Mesut,

you need to write something like this:

   Query = New Query;
   Query.Text = 
      "SELECT
      |   Sales.Number AS Number,
      |   Sales.Date AS Date,
      |   Sales.AmountPaid AS AmountPaid,
      |   Sales.PaymentMethod AS PaymentMethod
      |FROM
      |   Document.Sales AS Sales
      |WHERE
      |   Sales.AmountPaid > &Number";
   
   Query.SetParameter("Number", Number);
   
   QueryResult = Query.Execute();
   
   SelectionDetailRecords = QueryResult.Select();
   
   While SelectionDetailRecords.Next() Do

   EndDo;

Hi Mesut,

Please, rewatch this episode of the course. One of the topics is about passing parameter values to a query.

Konstantin

Thank you, I have solved the problem