How to use External Data Sources like Catalog?

1C:Enterprise platform integration capabilities and techniques

#1
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Sep 21, 2014
Company:

Hi there,
I got question, I have  database on SQL, SQL and 1c connected no any problems, but, I could not figure out how to use External Data Sources like Catalog.
for ex
on SQL : Database name = Products
please, if it's possible attache jpg
thank you.

 
#2
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Sep 5, 2014
Company:

Hi Odilbek Saporov!
You could do follow:
- Use "External data source" that you Add.
- In new external data source that you have just add -> select "Data" tab -> select "Select from list of external data source tables" => that you config "Connection string" and some thing. You can understand the meaning on the form.
- After you done above, you can write an action the same:

Code
StrQuery = New Query;
StrQuery.Text = "SELECT 
          |   Products.ID,
          |   Products.Name
          |FROM
          |   ExternalDataSource.ExternalDataSource1.Table.Products AS Products";
Result = StrQuery.Execute().Choose();
While Result.Next() Do
   ;
EndDo;


I hope you can do it, good luck.

Edited: Huong Tram - Oct 29, 2014 07:05 AM
 
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.