Re: Forms Variables

Shawn Odekirk wrote:
>
> I would like to have some global variables that can be accessed across multiple
> forms and some form level variables.
> The global variables look like they are limited to a string up to 255 characters.
> Is the standard method of storing a number in a global variable to convert them to
> a string and back?
> How about a form level variable that only the form can see even if there are multiple
> instances of the form open.
> I think that you are limited to 256 chars with Global - the way that
we got around this was to write a DB package that Contained two functions, say GlobalRead and GlobalWrite. You can then store any data type you want within the package passing it as an argument to GlobalWrite, and read it back from another form using GlobalRead (provided both forms are in the same SQL session). - you do need to define each value you store within the package, though. This is quicker than using a tempory table in the db (the other other way to do this).
Nick.

-- 
+--------------====================------------------------+
| Nick Clark.  ####################   NickC_at_dial.pipex.com |
+--------------====================------------------------+