Boyum Menu Query

Answered

Brian Branco

• February 20, 2024 02:27

Hi,
I have a simple query that will prompt the user to enter in a BP Catalog number and return the results.

I tried to put it on a menu with a universal function as a macro, but it doesnt show the prompts on the screen and its freezing up.

The query is SELECT T2."ItemCode", T2."CardCode",T1."CardName" FROM OCRD  T1 INNER JOIN OSCN T2 ON T1."CardCode" = T2."CardCode" WHERE T2."Substitute"=[%0]

What am I doing wrong?

Vote

0

• 

  Ramon Duunk

  • February 20, 2024 07:16

  Your query runs fine, so maybe some error in the macro ?
  Did you try to run it in debug mode ?
• 

  Brian Branco

  • February 20, 2024 12:50

  I can run it from Query Manager but not from Boyum, I set a universal function and a macro and copied the query in there.

  The prompt appears to put in the part number, but the wording on the screen is not correct and it just freezes.

  This is the second one I wanted to add on a screen but the same results.

  I am doing something wrong, but not sure what that is...
• 

  Ramon Duunk

  • February 20, 2024 13:40

  Hi Brian,

  You need to give more info about the setup for anyone here to help.
  This is to generic.
  Post some pictures so we can see configuration.
  
  Maybe i am not the one who can answer, but without this info i think nobody will :)
• 

  Brian Branco

  • February 20, 2024 15:22

  Thanks, I got it working, the unversal function type had to be SQL Report, I had it set as Macro.

   

Please sign in to leave a comment.