update table error

[kompas]

Hi,
I've went through several similar threads but didn't find the answer.
My code is:
update GrMar set bspa = bezspacji(marka)
where bspa and marka are columns of GrMar table and bezspacji() is the
function I've created.
I keep getting an error: Subroutine argument marka not defined.
Please help.
Jakub

[Peter Horsbøll Møller]

Jakub,

 

How have you declared your function (the header so to speak)?

You should use the ByVal keyword in this case, as this:

 

Declare Function bezspacji(ByVal sValue As String) As String

If you have not included the ByVal keyword, MapInfo will look for a variable (or function?) with the name "marka"

 

 

Peter Horsbøll Møller
Pitney Bowes Business Insight - MapInfo

 

2009/11/25 kompas <zbudni...@interia.pl>

[kompas]

Works great! Thank you Peter.
I'm stucked a few steps further though, but it's a material for the
new thread.
Jakub

On 25 Lis, 09:09, Peter Horsbøll Møller <mapinf...@horsboll-moller.dk>
wrote:

> Jakub,
>
> How have you declared your function (the header so to speak)?
> You should use the ByVal keyword in this case, as this:
>
> Declare Function bezspacji(ByVal sValue As String) As String
> If you have not included the ByVal keyword, MapInfo will look for a variable
> (or function?) with the name "marka"
>
> Peter Horsbøll Møller
> Pitney Bowes Business Insight - MapInfo
>

> 2009/11/25 kompas <zbudniewk...@interia.pl>