=var->AskC_SO

[David]

In the WOrkOrder form I am trying to create a Print Preview button that I can run the query by "Customer" or by "Ponumber" and then print.
I have this in another db and it works fine. I can't figure what I am doing wrong.
Thanks,

[David]

Re: =var->AskC_SO

I created this query by adding the ask var to a saved query and then added to the print preview button that i added, now I have done this a different way as shown in the pic. At first it didn't work. I did a compact and shut off and restarted A5 and still didn't work. This morning it works. I didn't restart computer, just restarted A5.

In the attached file of the previous thread it would work on the name but not the number.

[David]

Re: =var->AskC_SO

Based on the pic above, I added 3rd query option using the "and" and it worked for a while and now it does not work. I added some records to one of the tables, which I don't think that should make a difference.
If I just use the query genie and add the conditions I want and then go through the Print/Preview it works ok. I am just trying to eliminate some steps.
What am I doing wrong on the "Script Genie: Preview a Layout"?
Thanks

[johnkoh]

Re: =var->AskC_SO

David,

Try the other way. See attached screen shots
I added two buttons and created it with action scripts.
Print bttn 01 A.jpgPrint bttn 01 b.jpgPrint bttn 02 A.jpgPrint bttn 02 B.jpg
You may be find what is the problem with your code.

[David]

Re: =var->AskC_SO

Thanks for that. I will try this.

[Ray in Capetown]

Re: =var->AskC_SO

David
Your query string is
= (LEFT(CUSTOMERREFFULLNAME,LEN("hook tackle")) = "hook tackle" ) .OR. (REFNUMBER = "" )

Firstly you prompt for a PO number but search for REFNUMBER
Secondly, the refnumber cannot be left blank unless you only want to include blank refnumbers
The randomness you experience is more a case of COINCIDENCE

[David]

Re: =var->AskC_SO

thanks Ray in Capetown. I found the wrong PO/REFNUMBER after I uploaded the file. Secondly, What you say makes sense.
So your statement

= (LEFT(CUSTOMERREFFULLNAME,LEN("hook tackle")) = "hook tackle" ) .OR. (REFNUMBER = "" )

is the one that should work? I will try that also.
I am still working on johnkoh method to see if I can make that work.

I have a similar query in another db that work fine.
In the other db I have a button that runs a query that I created with the query genie:

(left(Worker,len(var->AskC_Worker)) = var->AskC_Worker ) .and. (Pay_date = var->AskD_Date_Paid )

This is not a Print Preview button, just a querry and this works with the date blank.
attached is a screen shot of the 2 conditions. I can't get the 2nd pic to load.
I'm not smart enough to know why one works and one doesn't.

[Ray in Capetown]

Re: =var->AskC_SO

Well it DOES appear to work in your example.....
According to the condition statement - remember in this one you have customer ="" .OR. refnumber = ""
Thats either one or the other for it to be included

note that;
In the first example of yours you have .AND. - wherein the two conditions must both be true

[johnkoh]

Re: =var->AskC_SO

David,

to know why one works and one doesn't.

Just try to get the CONCEPTION of the flow programming, like the Ray's comment.

This are very different code between "A= x " .or. "B = y" and
"A= x " .and. "B = y" and you will get different result

To print or review the records, Finding the records with something which called "Filter "

How to create a "Filter "
Case a -  Print current records which current view records at a form level. - you do not need the filter again
Case b - Using the tool such as
             (1) A5's Tool -- Limited to manipulate 
             (2) create your own style tool  -- Unlimited (?, may not right word but you can control )