Forum

Hi Experts,
 
i want to get data from external data source ExternalDataSources.XXXX.Tables.XXXX;

 how can i get all table data and iterate it,

 i tried like below but gives me error


 For Each DataRow In ExternalDataSources.XXX.Tables.XXXX Do

 EndDo;

Hello Selim!

None of the experts have answered you, so let me try to help you

For first - could you provide a more complete code?

And in general, it is better to work with external data sources using queries:

   Query = New Query;
   Query.Text = 
      "SELECT
      |   dbo_CURRENCIES.CODE AS CODE,
      |   dbo_CURRENCIES.NAME AS NAME,
      |   dbo_CURRENCIES.STATUS AS STATUS,
      |   dbo_CURRENCIES.EXTCODE AS EXTCODE
      |FROM
      |   ExternalDataSource.RK_RKeeper7.Table.dbo_CURRENCIES AS dbo_CURRENCIES";
   
   QueryResult = Query.Execute();
   
   SelectionDetailRecords = QueryResult.Select();
   
   While SelectionDetailRecords.Next() Do
      // Insert selection processing SelectionDetailRecords
   EndDo;

And how do you connect to external data source?

Hello Peter!

How to connect to an external source - this is material for a small article...

I have prepared several screenshots. I hope it will be clear to you how to connect. If you have any questions - ask!

First we add an external source in the Designer:

Select the tables whose data we want to work with. Also pay attention to screenshot 7 - it is necessary that the key field is filled in!

Now we launch 1C in working mode and open the External Source there:

There is one nuance here - when connecting for the first time, we need to specify the login and password again. Or the easiest way is to use the connection string, which can be copied from the Designer:

After this, we can work with the data in the tables directly:

Thank you for your help.

İs there another way to get all data from table without Query selection like below code

For Each DataRow In ExternalDataSources.XXX.Tables.XXXX Do

EndDo;

As far as I know, the table of the external data source cannot be iterated, so this code:

For Each a In ExternalDataSources.ExternalDataSource1.Tables.HumanResources_Employee Do 
   
EndDo;

Thank you for your help Sır