Adding parameter to query

For students who study 1C Junior course.

#1
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

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

 
#2
People who like this:0Yes/0No
Administrator
Rating: 9
Joined: Oct 3, 2019
Company:

Mesut,

you need to write something like this:


Code
   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;


Aleksandr

 
#3
People who like this:0Yes/0No
Active user
1C:Professional
Rating: 7
Joined: May 8, 2013
Company: 1C Company

Hi Mesut,

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

Konstantin

 
#4
People who like this:0Yes/0No
Interested
Rating: 10
Joined: Sep 30, 2020
Company: Nortek Bilişim

Thank you, I have solved the problem

 
Subscribe
Be the first to know tips & trick on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.