08.12.2006, 13:27 | #1 |
Программер
|
Из-за пробелов не срабатывает 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. |
|