Показать сообщение отдельно
Старый 08.12.2006, 13:27   #1  
vasiliy is offline
vasiliy
Программер
 
288 / 17 (1) ++
Регистрация: 21.10.2004
Адрес: E-burg
? Из-за пробелов не срабатывает select
??? ????? ?????т ?????????? ?????


X++:

select firstonly inventTrans
order by DateFinancial desc
where inventTrans.ItemId == '740103000002'
&& inventTrans.inventDimId == '0110140'
&& inventTrans.StatusReceipt == StatusReceipt::Purchased
join InventJournalTable
where InventJournalTable.JournalId == inventTrans.TransRefId
&& (InventJournalTable.JournalType == InventJournalType:eliveryOveralls
|| InventJournalTable.JournalType == InventJournalType::OverallsMovement);






???? ???????? ???, добавить пробел


X++:

select firstonly inventTrans
order by DateFinancial desc
where inventTrans.ItemId == '740103000002'
&& inventTrans.inventDimId == '0110140'
&& inventTrans.StatusReceipt == StatusReceipt::Purchased
join InventJournalTable
===>>> where ' ' + InventJournalTable.JournalId == inventTrans.TransRefId
&& (InventJournalTable.JournalType == InventJournalType:eliveryOveralls
|| InventJournalTable.JournalType == InventJournalType::OverallsMovement);





?? ???????????? ?????????

???? ??????? (

Последний раз редактировалось vasiliy; 08.12.2006 в 13:29.