Req row number to select records

[Dave Mac Callum]

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

[Tom Cone Jr]

Re: Req row number to select records

Dave,

A brief narrative explaining what you are trying to accomplish would help us help you. You've done a good job telling us what your code does, but havent' told us why. What's the goal?

Instead of using a filtered index to identify the records to be changed I can think of two other options:

a) run a query against the target table, and then change the records one at a time; or

b) order the records in the target table by Tx_acc_idf, then use a custom UDF to fetch the first candidate record and then change it if the found record has the necessary characteristics, then fetch the next record, examine it, and either change or skip, and continue until the Tx_acc_idf field changes or you fetch past eof.

[MoGrace]

Re: Req row number to select records

I think for the variable to work in the index it has to be defined as global and be initiated when the app opens. Then you can change that variable in the OnFetch event of the form or with a script.

[Al Buchholz]

Re: Req row number to select records

You don't put the variable in the index.

Use the variable to find the record in the index with code in an event for the form or browse.

1. set the index
2. do a fetch find to get the record needed using the variable.
or
do a query based on the variable to get the records that have that value in it..

If you put a variable filter in an index, the index is evaluated with the value of the variable at the time the index is built or reindexed, but doesn't change as the variable changes.

[Dave Mac Callum]

Re: Req row number to select records

Hi Guys,

I am attaching by condensed db so you can see what I require

Looking forward.

[Al Buchholz]

Re: Req row number to select records

Dave

Way too much to work through... Hopefully someone has the time to look at this..

Or you need to simplify what you have to focus on one issue at a time..

[Dave Mac Callum]

Re: Req row number to select records

Hi Guys,

Thanks for your pointers - got thru with the row numbers.