Lantica User Forum - Field Value and Format in @xlookup

(UTC)

Lantica User Forum › Archived Topics › Archived Topics › Field Value and Format in @xlookup

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Field Value and Format in @xlookup (Read 764 times)

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Field Value and Format in @xlookup Jan 29^th, 2004 at 12:20pm	Print Post
	When you xloolup money field, it reads and gets value as text. You have to convert back into money to carry out further calculation. May be it is supposed to work that way or is it a bug?


	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Field Value and Format in @xlookup Reply #1 - Jan 29^th, 2004 at 1:10pm	Print Post
	Sesame in general is "strong typed" - that means that numeric fields, including money - are actually numeric. The SBasic language is also strong typed, but for practical reasons, converts values to strings so we don't have to have a separate function for each of the data types. So, yes - you will often need to convert values to and from string type.

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

Bharat_Naik Senior Member Members Offline Ever ready to learn and share Posts: 1202 Location: Chicago, Illinois Joined: Dec 16^th, 2003	Re: Field Value and Format in @xlookup Reply #2 - Jan 29^th, 2004 at 1:21pm	Print Post
	Mark, thank you for explanation. It is clear.


	IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›