• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

User Selection

samlsc

Active Member
I need help on User Selection. I understand that before I do "Set User Selection", I must "Set User Append Flag" to "Yes" first. If then, what is the use of "Set User Append Flag = No"? Is it supposed to end "User Selection" process? And what is the conjunction <AND>, <OR>, <NONE> used for?

Thank You!

Samuel Liew
XE SP15, NT4 Server ,WIN2000 Client ,SQL2000
 

fwr

Member
Hi Samuel

If you do a "Set User Append Flag" to "Yes" it will add the selection onto
your data selection. If you do a "Set User Append Flag" to "No" it will
replace the data selection completely.

Frikkie Rushmer
B7331
 

michelle_perrin

Active Member
Setting the User Append Flag to 'Yes' means that the user selections that
you define within the ER will be additional to any filters that are
specified on the form. Setting the User Append Flag to 'No' means that any
filters that are specified on the form are ignored.

The AND, OR, NONE parameters determine how your selection will be appended
to the where clause that is being built. If you specify 'OR' you selection
will be appended to the current wehre clause preceeded by an 'OR' (eg: where
xxx = xxx OR yourcolumn = yourdata)

Michelle Perrin
 
Top