Jump to content

Parameterized query


This topic is 8550 days old. Please don't post here. Open a new topic instead.

Recommended Posts

The straight forward (and clean) solution is to put all four price lists in the same file and use the index to select one. Another option is to use four layouts, one with a portal to each of the four files. Enter the price list selection into a field (could be a global) and test the field to select a layout to jump to. -bd

[This message has been edited by LiveOak (edited December 22, 2000).]

Link to comment
Share on other sites

  • Newbies

Win98, FM5,

Hello:

I have a db that, when creating an invoices, requires looking up to one of 4 different pricelist files (tables).

Each file contains similar items but different prices (obviously). The descrptions vary as well.

I would like for the user to select a PriceList (ex: North America). This could be assigned somehow as a parameter so that the Portal would look up the correct file name based on said parameter.

How can I do this in FM5?

in sql it might look like: Select * from [NorthAmericaPriceListFile]

where the [...] is supplied the variable the user entered...

Thanks

Rior

Link to comment
Share on other sites

This topic is 8550 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.