Global Var in queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Burke - 17 Jul 2006 19:10 GMT

I have a global var "G_NAME"
I would like to use it in a query.

Is it posible?????????????????

Scott Burke

Reply to this Message

Ofer Cohen - 17 Jul 2006 19:48 GMT

Yes, by using a function that return the variabe

Function Get_G_NAME ()
Get_G_NAME = G_NAME
End Function

Create the function in a module, and then you can use the function as
another field in the query or as a criteria

Select * From TableName Where FieldName = Get_G_NAME ()

Or
Select Get_G_NAME() As G_NAME, TableName.* From TableName

Signature

Good Luck
BS"D

> I have a global var "G_NAME"
> I would like to use it in a query.
>
> Is it posible?????????????????
>
> Scott Burke

Reply to this Message

Scott Burke - 17 Jul 2006 21:06 GMT

If it was any simpler... It would be imposible to use. :)

Thanks
Scott Burke

> Yes, by using a function that return the variabe
>
[quoted text clipped - 16 lines]
> >
> > Scott Burke

Reply to this Message