Re: Move and edit masks

[Joan Hudson <joan@MEDIWARE.COM>]

Another note on edit masks -- at least for
Informix, and maybe for other db's as well
-- SQR seems to know whether column vars
are integer or double.

Anything like &count is treated as pure
integer when moved to a $var, and depending
on how the column is declared in the db
schema, the move will give differing results.

joan
-----Original Message-----
From: Brian Nice <bnice@CCCI.ORG>
To: Multiple recipients of list SQR-USERS
Date: Wednesday, January 27, 1999 5:47 AM
Subject: Move and edit masks


I have a question regarding edit masks. They seem to behave differently
depending on
whether you are using the mask for an number or a column variable that
contains a number.
What is the difference between the following?

BEGIN-SELECT
count(*)        &count
  move &count to $count XXXXX
  let #testNumber = 1
  move #testNumber to $testNumber XXXXX
  show $count ' ' $testNumber
from dual
END-SELECT

$count returns 1
$testNumber returns 1.000

Thanks for the help!



/****************************
* Brian Nice
* ABBA Systems Inc.
* Orlando, FL
*****************************/