Hi there,
I have a Form 'Debt_Xact_pay_m' into which I enter a Payment record consisting of an Account id 'Tx_acc_idf' and other data.
A Save button calls, in addition to others, a Script 'Trde_xact_plug_rows_only'. I attach a screen shot showing the code.
I include an Index 'td_tx.index_primary_put("Rows_Plug_")'. This index includes an Account Id "WOW001 " and other fields. I attach a screen shot showing the index structure.
The result is what I am looking for ie. row number to "WOW001 " selected records. I attach a screen shot showing the resulting Browse 'Trde_Xact_awt_alloc_b'.
This works only if Account Id "WOW001" is selected. There are a few thousand Accounts, so I have a problem of building a few thousand Indexes !!
I have tried replacing then Account id with a variable 'gdpp_acc_id' in the index "Rows_Plug_" when I define the index, but the problem is that it builds nothing because at the time of index definition the var->gdpp_acc_id is empty. I tried introducing 'td_tx.index_create_begin("Rows_Plug_" ,s_quote(td_tx.Tx_dtef), filt)
'Row_Crte = td_tx.index_create_end(), but the problem is that the Table 'trade_transactions' is probably being used at that time for Enquiries or whatever.
Any suggestions on how to get those row number onto the Browse ?
I trust I have given enough here to explain my problem. If need be I can extract data down to 5Mb and attach the db.
Looking forward
I have a Form 'Debt_Xact_pay_m' into which I enter a Payment record consisting of an Account id 'Tx_acc_idf' and other data.
A Save button calls, in addition to others, a Script 'Trde_xact_plug_rows_only'. I attach a screen shot showing the code.
I include an Index 'td_tx.index_primary_put("Rows_Plug_")'. This index includes an Account Id "WOW001 " and other fields. I attach a screen shot showing the index structure.
The result is what I am looking for ie. row number to "WOW001 " selected records. I attach a screen shot showing the resulting Browse 'Trde_Xact_awt_alloc_b'.
This works only if Account Id "WOW001" is selected. There are a few thousand Accounts, so I have a problem of building a few thousand Indexes !!
I have tried replacing then Account id with a variable 'gdpp_acc_id' in the index "Rows_Plug_" when I define the index, but the problem is that it builds nothing because at the time of index definition the var->gdpp_acc_id is empty. I tried introducing 'td_tx.index_create_begin("Rows_Plug_" ,s_quote(td_tx.Tx_dtef), filt)
'Row_Crte = td_tx.index_create_end(), but the problem is that the Table 'trade_transactions' is probably being used at that time for Enquiries or whatever.
Any suggestions on how to get those row number onto the Browse ?
I trust I have given enough here to explain my problem. If need be I can extract data down to 5Mb and attach the db.
Looking forward
Comment