Portal Row in calculation fields

[cdenby]

I have the need to send portal rows into separate fields in my database, as the portal rows, although they look like they sit in one record, actually exports as separate records with blank fields.

Is there a calculation element that manipulates or concatenates data from the portal rows? I've got a script running through all the rows in order to send data to the fields, but with a dozen rows and 2000 records, it's taking forever to run the script.

I need to be able to grab portal row data to use in calculations.

any thoughts?

[tlsparker]

Because portal rows are actually separate records in another database, it would probably be better to perform your operations directly in the database where the portal row information originates. (The portal is essentially [usually] a window into another database based on some relationship).

If you give more details, it might be possible to provide a more specific answer.

[droosan]

Are you freezing the window in your script? How's your RAM? Are your database files local?

I ask because I had a school database script that ran through 24 portal rows of about 8000 records. I don't remember exactly how long it took but it was seconds, not minutes.