Forum

TempTableManager

Apr 08, 2013 12:22 AM

Interested

Points:: 0
Joined:: Apr 5, 2012

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?

Profile

Murat Yazlıyev

Apr 08, 2013 12:53 AM

Interested

Points:: 0
Joined:: Apr 5, 2012

Developer Guide Chapter 8. Work with Queries Page 456.

There is notice:

Quote
IMPORTANT ! You can't create a temporary table if it is created based on value tables with a UUID-type value in the columns

CatalogRef typed data is UUID-type?

Profile

ivan avdonin

Apr 08, 2013 08:49 AM

Active user

Points:: 0
Joined:: Sep 26, 2012

You need set types for columns, like this:

Code
AdresTablosu.Columns.Add("CaddeSokak", New TypeDescription("String")); AdresTablosu.Columns.Add("SatırID", New TypeDescription("String"));

Profile

Timofey Bugaevsky

Apr 08, 2013 10:02 AM

Guest

Points::
Joined::

In your case:

Code
AdresTablosu.Columns.Add("CaddeSokak", New TypeDescription("CatalogRef.<your catalog name>")); AdresTablosu.Columns.Add("SatırID", New TypeDescription("Number"));

Profile