Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4744 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted




[b]Find UNSOLD[/b]

[i]#[/i]

[i]# Attempt to get ALL sold & unsold records count[/i]

[i]#[/i]

[i]#[/i]

[i]#[/i]

[b]Set Variable [/b][ $$COUNT_sold; Value:"" ]

[b]Set Variable [/b][ $NAME; Value:Get(ScriptParameter) ]

[i]#[/i]

[b]Go to Record/Request/Page[/b]

[ First ]

[b]Loop If [/b][ $NAME = Products 2::name and not IsEmpty(Products 2::sold) ] 

[b]Set Variable [/b][ $COUNT_sold; Value:Products 2::sold ]

[b]Exit Loop If [/b][ $NAME ≠ Products 2::name ]

[b]If [/b][ $COUNT_sold ≠ Products 2::c_sold ]

[b]Else[/b]

[b]Set Field [/b][ Products 2::c_sold; $COUNT_sold ]

[b]End If [/b]

[b]End If[/b]

[b]Go to Record/Request/Page[/b]

[ Next; Exit after last ]

[b]End Loop [/b]



[b]Show Custom Dialog [/b][ Message: $$COUNT_sold; Buttons: “OK”, “Cancel” ] [i]# # # # #[/i]



Set Variable [ $COUNT_sold; Value:Products 2::sold ]

Exit Loop If [ $NAME ≠ Products 2::name ]

If [ $COUNT_sold ≠ Products 2::c_sold ]

Else

lets say that $COUNT_sold = 8 and Products 2::sold is empty , i put $COUNT_sold value into that field, how do i save that for

iteration later on for example next pass $COUNT_sold = 4 . or do i just use a summary field?

-i

Posted

I'd like to help, but your post is hard to read. It barely makes sense.

Maybe you need to just use another variable, or set repetitions of the same variable, and then set your field(s) at the end?

This topic is 4744 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.