Hi All,
I have created a function that takes 4 parameters. When I call the function it looses the last parameter.
I call the function from an SQL statement, something like this:
par1 = "Hello "
par2 = "World "
par3 = "it "
par4 = "works!!!"
SELECT units, FormatX(par1, par2, par3, par4) FROM ...
FUNCTION FormatX(par1, par2, par3, par4)
rslt = par1+par2+par3+par4
RETURN
when it gets to the function, par4's value is .F., which gives me the type mismatch error message.
Any ideas why?
TIA
Louis
I have created a function that takes 4 parameters. When I call the function it looses the last parameter.
I call the function from an SQL statement, something like this:
par1 = "Hello "
par2 = "World "
par3 = "it "
par4 = "works!!!"
SELECT units, FormatX(par1, par2, par3, par4) FROM ...
FUNCTION FormatX(par1, par2, par3, par4)
rslt = par1+par2+par3+par4
RETURN
when it gets to the function, par4's value is .F., which gives me the type mismatch error message.
Any ideas why?
TIA
Louis