Re: Custom Menu on Form

Try using indirection, ie. Name_In('block.item'). To use it's value in a Select Statement, you will need to assign it to a local variable first, eg. your_local_var := Name_In('block.item'); To use your_local_var in a Select statement, you will then need to either pass your_local_var to a second program unit that declares the cursor, use a SELECT INTO statement (not usually recommended), or pass your_local_var to an explicit cursor.

Shelli D. Orton wrote in message <37962F3D.5F2639DE_at_crha-health.ab.ca>...
>I have a table in my database with personnel information and a second
>table where the business departments are associated with people from the
>first list. Before I let the user delete a personnel record, I have a
>procedure that ensures the person is no longer associated with any
>department. It works great for my push button.
>
>I would like to be able to do the same thing with my Record|Delete menu
>command but can't seem to be able to. The problem is my procedure takes
>the pers_id field from the data block and uses it in a query to see if
>it exists in the second table. The menu module has a compilation error
>because it references a block.
>
>Is there any way to do this from a menu item, or should I remove it from
>the menu module and only let people access via the push button?
>
>Thanks in advance,
>Shelli
>
Received on Thu Jul 22 1999 - 07:35:03 CEST