|  30.03.2010, 18:26 | #1 | 
| Участник | exist method on temporary table 
			
			Hi,  I'm trying to make exist method on temporary table something like this... Код: static boolean exist(MyTempTable _tempTable,
                             RefTableId      _tableId,
                             RefRecId        _recId)
{
    return _tableid && _recId && (select RecId from _tempTable
                                                   where _tempTable.TableNum = _tableId
                                                       && _tempTable.RecordNo = _recId
             ).RecId != 0;
}Any ideas what's the problem? | 
|  | 
|  30.03.2010, 18:48 | #2 | 
| ---------------- | X++: static boolean exist(MyTempTable _tempTable, RefTableId _tableId, RefRecId _recId) { if(! _tableid || !_recId) return false; select RecId from _tempTable where _tempTable.TableNum = _tableId && _tempTable.RecordNo = _recId return _tempTable.RecId != 0; } | 
|  | |
| За это сообщение автора поблагодарили: ist (1). | |
|  30.03.2010, 19:08 | #3 | 
| Участник | 
			
			tks.
		 | 
|  | 
|  31.03.2010, 10:16 | #4 | 
| Axapta | 
			
			Just to make it clear for you. See the "Select statement" article in the Dev Guide: Цитата: 
		
			Field select It is also possible to use a select statement in a lookup on a field. After a select statement that fetched a record in a table, you can write .field name to reference a field in the table. Notice the difference between the normal select and the field select. The field select operates directly on a table, whereas the select statement operates on a table variable. | 
|  |