Read data from ExternalDataSource

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:

Attached Files

Download Pic_1.png (15.21 KB)

Download Pic_2.png (26.78 KB)

Download Pic_3.png (29.83 KB)

Download Pic_4.png (13.43 KB)

Download Pic_5.png (24.88 KB)

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!

Attached Files

Download Pic_6.png (21.39 KB)

Download Pic_7.png (48.27 KB)

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

Attached Files

Download Pic_8.png (20.96 KB)

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:

Attached Files

Download Pic_9.png (24.59 KB)

Download Pic_10.png (8.8 KB)

Download Pic_11.png (5.17 KB)

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

Attached Files

Download Pic_12.png (19.12 KB)

Download Pic_13.png (24.2 KB)

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