Показать сообщение отдельно
Старый 09.07.2024, 18:12   #1  
Blog bot is offline
Blog bot
Участник
 
25,644 / 848 (80) +++++++
Регистрация: 28.10.2006
a33ik: How to select from internal table
Источник: http://daxonline.org/1953-how-to-sel...nal-table.html
==============

There is one way how you can still fetch data from the table, which is marked as internal:






WHSPrinterName locPrinterName = ''; TableId tableId = tableName2Id('WHSWorkUserOverriddenLabelPrinter'); FieldId userIdFId = fieldName2Id(tableId, 'UserId'); FieldId printerNameFId = fieldName2Id(tableId, 'PrinterName'); Query q = new Query(); QueryBuildDataSource qbds = q.addDataSource(tableId); QueryBuildRange qbr = qbds.addRange(userIdFId); QueryRun qr; Common workUserOverriddenLabelPrinter; qbr.value('VK'); q.firstOnly1(true); qr = new QueryRun(q); while (qr.next()) { workUserOverriddenLabelPrinter = qr.get(tableId); locPrinterName = workUserOverriddenLabelPrinter.(printerNameFId); } info(locPrinterName);Alternatively, you can use direct queries.





Источник: http://daxonline.org/1953-how-to-sel...nal-table.html