ToNumber({?Parameter}) not allowed ? 1

[mulema]

Hi all,
My database field "Invoice_No" is a string (Varchar2 ).
I want to convert this string to number.

My Select Expert formula is :
{Table.Invoice_no} = {Invoice#}

How can I correctly use the TONUMBER function here?
I tried using {Table.Invoice_no} = TONUMBER({Invoice#}), also TONUMBER({Table.Invoice_no}) = TONUMBER({Invoice#})
but got the error " A string is required here"

What am I doing wrong?

Thanks,
Mulema.

 

[pgtek]

hi

try

tonumber({your field})
then you will be able to pass it as a number

pg

 

[pgtek]

Create formula
@TONumberInvoice

tonumber({InvoiceNumber})

 

[mulema]

Pg,
Thanks for the quick fix.

Mulema.

 

[Ngolem]

*************
I tried using {Table.Invoice_no} = TONUMBER({Invoice#}), also TONUMBER({Table.Invoice_no}) = TONUMBER({Invoice#})
*************

In the first case...you cannot assign a value to a database field....and in the second case...your field{Table.Invoice_no} is probably a numeric field so ToNumber won't work on it since it needs a string

I assume {Invoice#} is your string parameter(shud be written {?Invoice#} so we can easily recognize that)



Jim Broadbent