Rating:
27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.
Hi
I have a code. It doesn't work truely. Anyone who know exactly how works TempTableManager from script.
I have this script:
Code
AdresTablosu = New ValueTable;
AdresTablosu.Columns.Add("CaddeSokak");
AdresTablosu.Columns.Add("SatırID");
//CaddeSokak - CatalogRef typed
//SatırID - Number typed
Sorgu = New Query;
Sorgu.Text = "SELECT
| AdresTablosu.CaddeSokak,
| AdresTablosu.SatırID
|INTO EvrakAdresTablosu
|FROM
| &AdresTablosu AS AdresTablosu";
Sorgu.TempTablesManager = New TempTablesManager;
Sorgu.SetParameter("AdresTablosu", AdresTablosu);
Result = Sorgu.Execute();
The error message is:
Quote
{Document.RootAdresDeğişikliği_Hr.Form.DocumentForm.Form(183)}: Error calling context method (Execute) Result = Sorgu.Execute(); because: {(2, 2)}: You cannot select type in query <<?>>AdresTablosu.CaddeSokak,
TempTableManager doesn't support CatalogRef typed data?
AdresTablosu.Columns.Add("CaddeSokak", New TypeDescription("CatalogRef.<your catalog name>"));
AdresTablosu.Columns.Add("SatırID", New TypeDescription("Number"));