Zero out found records?

[PatriciaW]

I add a record to table via a script ... that part works Ok ... but when I add the record it gets added to an existing found set.

I want to have it as the only record in the found set. In other words I want to discard the entire found set before I do the new record request. I have been unable to find a straightforward way to do this. Is there one?

[PeterHW]

Depends on what you call straightforward but inserting the following after your New Record/Request step will do what you want

Show All Records

Omit Record

Show Omitted only

HTH,

Peter

[aaa]

If i understand:

Show All Records

New Record request

Such?

And if you want to see in found set only this record:

Omit Record

Show omited.

[aaa]

I am sorry! When i was printng my post last answer was not here.

[PeterHW]

Hey, don't worry, at least she got a consistent answer !

Peter

[-Queue-]

To start with no found set in a multi-user system,

Show All Records

Show Omitted Only

Loop

Exit Loop If [not Get(FoundCount)]

Omit Record

End Loop

If not multi-user, the loop is superfluous.

To isolate a new record in a multi-user system,

New Record/Request

Show All Records

Omit Record

Show Omitted Only

Loop

Exit Loop If [Get(FoundCount) = 1]

Go to Record/Request/Page [Last]

Omit Record

End Loop

Or create a simple self-relationship based on the serial and use

New Record/Request

Commit Records/Requests [skip data entry validation; No dialog]

Go to Related Record [show only related; "self-relationship"; ]

[comment]

OK, you have already explained the first part before. But the second part? How is it possible for a user who has just intitated New Record to end up on another record?

[-Queue-]

It is not possible. Read the original post again. It isolates the new record, regardless of how many records are in the current found set. But you know this already; maybe you just haven't had your coffee yet? :o

[comment]

Touché, and well deserved!