🚀 go-pugleaf

"Werner Renhardt" <werner@kangaroo.nwy.at> wrote:

>Concatenation of strings and numerical-values in SQL:

Can't do it. SQL doesn't allow it.

>      Auto-Conversion of numerical values to strings does not work. )

It does this in IntraBuilder only when using IntraBuilder specific
commands.

> How can I cast the numerical value 'TabID' to a String-value?
> I've found no function (e.g. Str(<Number>))
> I've found no operator (e.g. &  (Ampersand) in ACCESS which implicit
>                         casts numerical values to Strings)
> There is no hint in the 'Localsql.hlp' of BDE
> and the IntraBuilder-Helpfile

Rather than using SQL to do this, try creating a calculated field in
the rowset using a query object:
// note that the following is untested and taken from somewhere else:
q = new query();
q.sql = "select * from mytable";
f = new Field();
f.fieldName = "My Calculated Field";
// note: this will fire for each row ...
// "this" refers to the field, "parent" is the fields
// array ... (substitute 'field1' with the name of the
// field, and of course, you would want to set your
// calculation for what you need
f.beforeGetValue = {|| this.parent["numfield"].value +
  this.parent["charfield"].value };
q.rowset.fields.add( f );
q.active = true;

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm