AnsweredAssumed Answered

Exporting found records from global field

Question asked by newlyuser on Mar 7, 2010
Latest reply on Mar 7, 2010 by FentonJones

Title

Exporting found records from global field

Post

All,

When I export found records from the global field, it's exporting the found records multiple times. This is how my script it set:

Set Field (Test::g_field; "")
Enter Find Mode
Set Field (Test::Status1; "X")
New Record/Request
Set Field (Test::Status2; "X")
New Record/Request
Set Field (Test::Status3; "X")
New Record/Request
Set Field (Test::Status4; "X")
Perform Find
Go to Record/Request/Page[First]
Loop
If (Test::Status1 = "X")
Set Field (Test::g_Field; Test::g_Field &"q" & Test::ID & "," & Test::Name & "," Test::Type
End If
If (Test::Status2 = "X")
Set Field (Test::g_Field; Test::g_Field &"q" & Test::ID & "," & Test::Name & "," Test::Type
End If
If (Test::Status3 = "X")
Set Field (Test::g_Field; Test::g_Field &"q" & Test::ID & "," & Test::Name & "," Test::Type
End If
If (Test::Status4 = "X")
Set Field (Test::g_Field; Test::g_Field &"q" & Test::ID & "," & Test::Name & "," Test::Type
End If
Go to Record/Request/Page [Next; Exit after last]
End Loop
Export Records [Windows (ANSI)]

When the export runs, if the found records is 10, the global g_Field have 10 records X 10 times but I only need to see those 10 records one time.

I have tried Omit Record and Show Omiitted Only from the Found Records, but that does not work either.

Can anybody provide me some guidance? Thanks!

















Outcomes