PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Rob

Pages: [1]
Nomads / Re: Pass an argument to a grid cell query
« on: December 16, 2022, 11:48:27 AM »
I wanted to limit what shows up in the query based on the value of another column.

That other column only has 2 valid values so I ended up creating two queries and put a different fixed Key Prefix in each.

I read the value of the other column when the query cell gets focus and place the name of the appropriate query in a string variable.

The Preset Value/Expression for the query cell is just equal to the string variable.

I'm surprised that there isn't some easy way to pass an argument to the query. Maybe in Celltag$? I would think that this comes up fairly often.

Nomads / Pass an argument to a grid cell query
« on: December 15, 2022, 03:47:11 PM »
How do I pass an argument to a query which is attached to a grid cell?

Version 2020

Is there some way to set up the Pro system so that it behaves as a Base system?

Sometimes I have used a Pro feature without realizing it and I only discover my mistake when the program doesn't work on the client's Base system.

Isn't it already possible to set the color with 'BACKCOLOR$ ?

Pages: [1]