Hi

I want to concatenate string & double value (domain tcqiv1).Can anybody tell me the function to convert double value to string value.

Thanks
Shelly

Hi

I want to concatenate string & double value (domain tcqiv1).Can anybody tell me the function to convert double value to string value.

Thanks
Shelly

Hello,

BaanERP Programmers Guide

str$()
--------------------------------------------------------------------------
Syntax
string str$( num_expr )

Description
This converts an integer or floating point expression to a string.

Or sprintf$() functions

Doubles

string result(80)

result = sprintf$("number: %-*.*f",10,2,1.2")

| result contains "number: 1.20 "

| minimum length of the double value is 10 positions

| number of digits after decimal sign is 2

Amounts

| Suppose the default currency is USD ($)

| and A001 is defined as "$$ 999T999T999VD99"

string result(80)

result = sprintf$("%A001", 1234.56)

| result contains "$ 000,001,234.56"

result = sprintf$("%-10A001,hfl", 1234.56)

| result contains "fl 000.001.234,56"

result = sprintf$("%-.10A001,hfl", 1234.56)

| result contains "001.234,56"; there is insufficient space

| for currency symbol



Regards

Thanks bdittmar!!!