Delete a selection from query

Understanding basics of 1C:Enterprise platform. To start working with 1C:Enterprise platform visit Getting started page

Pages: 1

mohammad maleh

People who like this:0 Yes/0 No

Jul 11, 2013 12:35 AM

Active user

Rating: 5
Joined: Jun 4, 2013
Company:

hi I'm trying to delete a specific catalog item ... I thought it will work out if i use queries ... so i wrote :

Code

   Query = New Query;
   Query.Text = "SELECT * FROM catalog.second"  ;
   Selection = Query.Execute().Choose();
   
        while Selection.Next() do
   
          if String(selection.company)="" then
   
   // **HERE I WANT DO DELETE THIS SELECTION**
   
     endif;
      
   enddo ;

if anyone can help me with this I'll bee Thankful

ivan avdonin

People who like this:0 Yes/0 No

Jul 11, 2013 01:31 AM

Active user

Rating: 7
Joined: Sep 26, 2012
Company: individual

try so

Code
if String(selection.company)="" then selection.Ref.GetObject().Delete(); endif;

Sergey Polikarpov

People who like this:1 Yes/0 No

Jul 11, 2013 02:03 AM

Active user

Rating: 8
Joined: Jun 25, 2013
Company: 1C Company

Please pay attention to the following recommendations:

1) Always include selection conditions in a query when it is possible.
2) Mark objects for deletion instead of deleting them directly and then delete them with the "Marked object deletion" data processor. It helps you to keep you data integrity.

Here is your example:

Code

   Query = New Query;
   Query.Text =
   "SELECT
   |   *
   |FROM
   |   Catalog.Second AS SecondCatalog
   |WHERE
   |   SecondCatalog.Company = VALUE(Catalog.Companies.EmptyRef)";
   // If Company is a value of Catalog.Companies type 

   Selection = Query.Execute().Choose();
   
   While Selection.Next() do
   
      SelectedObject = Selection.Ref.GetObject();
      SelectedObject.DeletionMark = True;
      SelectedObject.Write();
      
   Enddo;

1C Company support team

mohammad maleh	#4 People who like this:0 Yes/0 No Jul 11, 2013 03:27 AM
Active user Rating: 5 Joined: Jun 4, 2013 Company:	Thanks it worked

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)

Delete a selection from query

Download brochures