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.
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: - Oct 29, 2014 07:05 AM
Pages:1
Users browsing this topic (guests: 1, registered: 0, hidden: 0)