TempTableManager

Common questions about 1C:Query language, Query builder tool and Data composition schema

Pages: 1

Murat Yazlıyev

People who like this: 0 Yes / 0 No

Apr 08, 2013 12:22 AM

Interested

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?

Edited: Murat Yazlıyev - Apr 08, 2013 12:44 AM

Murat Yazlıyev

People who like this: 0 Yes / 0 No

Apr 08, 2013 12:53 AM

Interested

Rating: 27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.

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?

ivan avdonin

People who like this: 0 Yes / 0 No

Apr 08, 2013 08:49 AM

Active user

Rating: 7
Joined: Sep 26, 2012
Company: individual

You need set types for columns, like this:

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

Timofey Bugaevsky

People who like this: 0 Yes / 0 No

Apr 08, 2013 10:02 AM

Timofey Bugaevsky

Guest

Joined:
Company:

In your case:

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

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)

Download brochures