Dynamics V2 SP1.
By using AddQueryWhere one can add a "Where" clause to the base query
string.
Is it possible to remove such a "Where" clause or even revert back to the
original base query string ?
Kind regards and thanks
Robert Pooley
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
Robert,
"setQueryWhere" with a empty (blank) where clause should set the query back
to the initial (design time) query.
Regards,
Wayne Hitchcock
Senior Systems Analyst.
Pulse Mining Systems Pty Ltd
Ph: +61 2 4933 3300
Fax: +61 2 4933 6732
E-mail: whitchcock@pulsemining.com.au
This e-mail is solely for the use of the intended recipient and may contain
information which is confidential or privileged. Unauthorised use of its
contents is prohibited. If you have received this e-mail in error, please
notify the sender immediately via return e-mail and then delete the original
e-mail.
-Original Message-
Sent: Wednesday, June 04, 2003 3:53 PM
To: dev@dynamics.possenet.org
Subject: FW: Reversing AddQueryWhere
Dynamics V2 SP1.
By using AddQueryWhere one can add a "Where" clause to the base query
string.
Is it possible to remove such a "Where" clause or even revert back to the
original base query string ?
Kind regards and thanks
Robert Pooley
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
Thanks, but I tried that and it didn't work.
Regards, Natalie.
- Original Message -
From: "Wayne Hitchcock" To: Sent: Wednesday, June 04, 2003 3:56 PM
Subject: RE: FW: Reversing AddQueryWhere
Robert,
"setQueryWhere" with a empty (blank) where clause should set the query
back
to the initial (design time) query.
Regards,
Wayne Hitchcock
Senior Systems Analyst.
Pulse Mining Systems Pty Ltd
Ph: +61 2 4933 3300
Fax: +61 2 4933 6732
E-mail: whitchcock@pulsemining.com.au
This e-mail is solely for the use of the intended recipient and may
contain
information which is confidential or privileged. Unauthorised use of its
contents is prohibited. If you have received this e-mail in error,
please
notify the sender immediately via return e-mail and then delete the
original
e-mail.
-Original Message-
Sent: Wednesday, June 04, 2003 3:53 PM
To: dev@dynamics.possenet.org
Subject: FW: Reversing AddQueryWhere
Dynamics V2 SP1.
By using AddQueryWhere one can add a "Where" clause to the base query
string.
Is it possible to remove such a "Where" clause or even revert back to the
original base query string ?
Kind regards and thanks
Robert Pooley
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
/*Remove the previously assigned updateAddQueryWhere and put the
query back to the initial state. Simply remove the where condition
and just pass the field and it will be reversed!
*/
RUN updateAddQueryWhere in ghDataSource (
INPUT '':U,
INPUT 'customer.custno':U).
-Original Message-
Sent: Wednesday, 4 June 2003 4:01 PM
To: dev@dynamics.possenet.org
Subject: Re: FW: Reversing AddQueryWhere
Thanks, but I tried that and it didn't work.
Regards, Natalie.
- Original Message -
From: "Wayne Hitchcock" To: Sent: Wednesday, June 04, 2003 3:56 PM
Subject: RE: FW: Reversing AddQueryWhere
Robert,
"setQueryWhere" with a empty (blank) where clause should set the query
back
to the initial (design time) query.
Regards,
Wayne Hitchcock
Senior Systems Analyst.
Pulse Mining Systems Pty Ltd
Ph: +61 2 4933 3300
Fax: +61 2 4933 6732
E-mail: whitchcock@pulsemining.com.au
This e-mail is solely for the use of the intended recipient and may
contain
information which is confidential or privileged. Unauthorised use of its
contents is prohibited. If you have received this e-mail in error,
please
notify the sender immediately via return e-mail and then delete the
original
e-mail.
-Original Message-
Sent: Wednesday, June 04, 2003 3:53 PM
To: dev@dynamics.possenet.org
Subject: FW: Reversing AddQueryWhere
Dynamics V2 SP1.
By using AddQueryWhere one can add a "Where" clause to the base query
string.
Is it possible to remove such a "Where" clause or even revert back to the
original base query string ?
Kind regards and thanks
Robert Pooley
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
Hi,
You need to do the following:
DYNAMIC-FUNCTION("setQueryWhere":U IN hDataSource, ?).
DYNAMIC-FUNCTION("setQueryString":U IN hDataSource, "":U).
I have noticed that sometimes only setQueryString works, but not in all
cases. The above-mentioned method seems to do the trick every time. I used
this code in the Dynamic TreeView before repositioning the SDO to the
selected node.
Mark Davies
Project Leader
Tel: +27 (0)11 575-1836 (Direct)
Tel: +27 (0)11 575-1800 (Switchboard)
Fax: +27 (0)11 576-2601
Cell: +27 (0)73 287 1254
MIP
2nd Floor, Zone 2
Wrigley Field, The Campus
Sloane Avenue, Bryanston
"Eagles may soar, but weasels don't get sucked into jet engines."
-Original Message-
Sent: 04 June 2003 08:01 AM
To: dev@dynamics.possenet.org
Subject: Re: FW: Reversing AddQueryWhere
Thanks, but I tried that and it didn't work.
Regards, Natalie.
- Original Message -
From: "Wayne Hitchcock" To: Sent: Wednesday, June 04, 2003 3:56 PM
Subject: RE: FW: Reversing AddQueryWhere
Robert,
"setQueryWhere" with a empty (blank) where clause should set the query
back
to the initial (design time) query.
Regards,
Wayne Hitchcock
Senior Systems Analyst.
Pulse Mining Systems Pty Ltd
Ph: +61 2 4933 3300
Fax: +61 2 4933 6732
E-mail: whitchcock@pulsemining.com.au
This e-mail is solely for the use of the intended recipient and may
contain
information which is confidential or privileged. Unauthorised use of its
contents is prohibited. If you have received this e-mail in error,
please
notify the sender immediately via return e-mail and then delete the
original
e-mail.
-Original Message-
Sent: Wednesday, June 04, 2003 3:53 PM
To: dev@dynamics.possenet.org
Subject: FW: Reversing AddQueryWhere
Dynamics V2 SP1.
By using AddQueryWhere one can add a "Where" clause to the base query
string.
Is it possible to remove such a "Where" clause or even revert back to the
original base query string ?
Kind regards and thanks
Robert Pooley
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
______________________________________
This e-mail may contain confidential information and may be legally
privileged and is intended only for the person to whom it is addressed. If
you are not the intended recipient, you are notified that you may not use,
distribute or copy this document in any manner whatsoever. Kindly also
notify the sender immediately by telephone, and delete the e-mail. When
addressed to clients of the company from where this e-mail originates ("the
sending company ") any opinion or advice contained in this e-mail is subject
to the terms and conditions expressed in any applicable terms of business or
client engagement letter . The sending company does not accept liability for
any damage, loss or expense arising from this e-mail and/or from the
accessing of any files attached to this e-mail.
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
Be careful with setQueryString:
"The ADM2 API Reference manual states
setQueryString
NEVER set this directly. It should only be maintained by other query
manipulation methods."
-Original Message-
Sent: Wednesday, 4 June 2003 4:09 PM
To: dev@dynamics.possenet.org
Subject: RE: FW: Reversing AddQueryWhere
Hi,
You need to do the following:
DYNAMIC-FUNCTION("setQueryWhere":U IN hDataSource, ?).
DYNAMIC-FUNCTION("setQueryString":U IN hDataSource, "":U).
I have noticed that sometimes only setQueryString works, but not in all
cases. The above-mentioned method seems to do the trick every time. I used
this code in the Dynamic TreeView before repositioning the SDO to the
selected node.
Mark Davies
Project Leader
Tel: +27 (0)11 575-1836 (Direct)
Tel: +27 (0)11 575-1800 (Switchboard)
Fax: +27 (0)11 576-2601
Cell: +27 (0)73 287 1254
MIP
2nd Floor, Zone 2
Wrigley Field, The Campus
Sloane Avenue, Bryanston
"Eagles may soar, but weasels don't get sucked into jet engines."
-Original Message-
Sent: 04 June 2003 08:01 AM
To: dev@dynamics.possenet.org
Subject: Re: FW: Reversing AddQueryWhere
Thanks, but I tried that and it didn't work.
Regards, Natalie.
- Original Message -
From: "Wayne Hitchcock" To: Sent: Wednesday, June 04, 2003 3:56 PM
Subject: RE: FW: Reversing AddQueryWhere
Robert,
"setQueryWhere" with a empty (blank) where clause should set the query
back
to the initial (design time) query.
Regards,
Wayne Hitchcock
Senior Systems Analyst.
Pulse Mining Systems Pty Ltd
Ph: +61 2 4933 3300
Fax: +61 2 4933 6732
E-mail: whitchcock@pulsemining.com.au
This e-mail is solely for the use of the intended recipient and may
contain
information which is confidential or privileged. Unauthorised use of its
contents is prohibited. If you have received this e-mail in error,
please
notify the sender immediately via return e-mail and then delete the
original
e-mail.
-Original Message-
Sent: Wednesday, June 04, 2003 3:53 PM
To: dev@dynamics.possenet.org
Subject: FW: Reversing AddQueryWhere
Dynamics V2 SP1.
By using AddQueryWhere one can add a "Where" clause to the base query
string.
Is it possible to remove such a "Where" clause or even revert back to the
original base query string ?
Kind regards and thanks
Robert Pooley
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
______________________________________
This e-mail may contain confidential information and may be legally
privileged and is intended only for the person to whom it is addressed. If
you are not the intended recipient, you are notified that you may not use,
distribute or copy this document in any manner whatsoever. Kindly also
notify the sender immediately by telephone, and delete the e-mail. When
addressed to clients of the company from where this e-mail originates ("the
sending company ") any opinion or advice contained in this e-mail is subject
to the terms and conditions expressed in any applicable terms of business or
client engagement letter . The sending company does not accept liability for
any damage, loss or expense arising from this e-mail and/or from the
accessing of any files attached to this e-mail.
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
Wayne,
Thanks that works fine.
Kind regards
Robert Pooley
-Original Message-
Sent: 04 June 2003 07:56 AM
To: dev@dynamics.possenet.org
Subject: RE: FW: Reversing AddQueryWhere
Robert,
"setQueryWhere" with a empty (blank) where clause should set the query back
to the initial (design time) query.
Regards,
Wayne Hitchcock
Senior Systems Analyst.
Pulse Mining Systems Pty Ltd
Ph: +61 2 4933 3300
Fax: +61 2 4933 6732
E-mail: whitchcock@pulsemining.com.au
This e-mail is solely for the use of the intended recipient and may contain
information which is confidential or privileged. Unauthorised use of its
contents is prohibited. If you have received this e-mail in error, please
notify the sender immediately via return e-mail and then delete the original
e-mail.
-Original Message-
Sent: Wednesday, June 04, 2003 3:53 PM
To: dev@dynamics.possenet.org
Subject: FW: Reversing AddQueryWhere
Dynamics V2 SP1.
By using AddQueryWhere one can add a "Where" clause to the base query
string.
Is it possible to remove such a "Where" clause or even revert back to the
original base query string ?
Kind regards and thanks
Robert Pooley
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
setQueryWhere('') reverts back to the base query.
HÃ¥vard
-Original Message-
Sent: Wednesday, June 04, 2003 1:53 AM
To: dev@dynamics.possenet.org
Subject: FW: Reversing AddQueryWhere
Dynamics V2 SP1.
By using AddQueryWhere one can add a "Where" clause to the base query
string.
Is it possible to remove such a "Where" clause or even revert back to the
original base query string ?
Kind regards and thanks
Robert Pooley
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@dynamics.possenet.org
For additional commands, e-mail: dev-help@dynamics.possenet.org