Re: Value error

Nick Lehane wrote:
>
> Hi all,
>
> Just a quick question - I've got an SQL Select statement which I know is
> correct because it retrieves what I want in SQL server, but using it in
> forms 4.5 is a different matter.
>
> The only difference between the statements is that I am basing the
> statement on a global variable as opposed to hard coding the string to
> search on (as is done directly in the server).
>
> I have tried all sorts to get round this but with no luck. Can anyone
> offer some help please? I might just be doing something simple wrong.
>
> Thanks,
>
> Nick

do you select a numeric value intothe global ?

remember globals are always CHAR Received on Tue Sep 22 1998 - 05:54:46 CDT