I am not sure if that can work. Try modifying this example to meet your need:
TableForInsert TableForInsert;
SalesTable SalesTable;
recordInsertList recInserts = new RecordInsertList(tableNum(TableForInsert));
;
SalesTable SalesTable;
recordInsertList recInserts = new RecordInsertList(tableNum(TableForInsert));
;
while select SalesTable where SalesTable.SalesID == 'GX1900'
{
TableForInsert.Field1 = SalesTable.ApprovedBy;
recInserts.add(TableForInsert);
TableForInsert.clear();
}
recInserts.insertDatabase();
{
TableForInsert.Field1 = SalesTable.ApprovedBy;
recInserts.add(TableForInsert);
TableForInsert.clear();
}
recInserts.insertDatabase();
Varden Morris
J. Wray & Nephew Ltd. - Group I.S.
Phone: (876) - 923 - 6141 Ext. 2226
Fax: (876) - 923 - 5372
Cell: (876) - 3833566
Email: [EMAIL PROTECTED]
compashi <[EMAIL PROTECTED]> wrote:
Hi everybody,
Have any one of you tried Insert_recordset() with some join condition
with some other tables and then inserted the result into a table.
I am trying follwing code but it's giving error that
" The selection field list (2 fields) does not match the insertion
field list (1 fields)"
if(salestable)
{
ttsbegin;
Insert_Recordset fcfrtable(TmpDRNo)
select salesid from salestable where
salestable.sreDRStatus==sreDrStatus::PostedDR ||
salestable.sreDRStatus==sreDrStatus::ClosedDR &&
salestable.sreClosure==Noyes::No
|| salestable.sreForeclosure==noyes::No ||
salestable.sreRestructure==noyes::No
|| salestable.sreRepossession==noyes::No &&
salestable.sreSalesType==sresalestype::DR;
join * from salesline where
salestable.SalesId==salesline.SalesId &&
salesline.sreBusCat==dlgBusCat.value();
ttscommit;
}
please share your views. is it possible in Axapta 3.0 .
If yes then what is the problem.
Byee and have a nice time.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
