Does EDB support character case transformations like DBIsam?

Thanks
Kai

Kai,

Yes, but not in the same way as DBISAM. EDB is much more SQL based, so
naturallly there are SQL statements to accomplish this. The LOWER
and/or UPPER statements will do what you need:

LOWER(<StringExpression>)

<StringExpression> =

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

UPPER(<StringExpression>)

<StringExpression> =

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Hope this helps.
--
Jan Ferguson [Team Elevate]


Kai Peters wrote:

> Does EDB support character case transformations like DBIsam?

Hi J.B.,

I guess I should have been more precise about the "where" - only in triggers, or are there other options?

Thanks
Kai


"J. B. Ferguson" wrote:

Kai,

Yes, but not in the same way as DBISAM. EDB is much more SQL based, so
naturallly there are SQL statements to accomplish this. The LOWER
and/or UPPER statements will do what you need:

LOWER(<StringExpression>)

<StringExpression> =

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

UPPER(<StringExpression>)

<StringExpression> =

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Hope this helps.
--
Jan Ferguson [Team Elevate]


Kai Peters wrote:

> Does EDB support character case transformations like DBIsam?

Kai,

Maybe it's too early here, just woke up, but I don't understand your
question. These statements will work wherever you have any of the types
listed. Are you asking if there are other options, or other ways to
perform "case transformation"?

--
Jan Ferguson [Team Elevate]


Kai Peters wrote:

> Hi J.B.,
>
> I guess I should have been more precise about the "where" - only in
> triggers, or are there other options?

Jan

I seems to me that what Kai is wanting to know is if there is any other way
to convert strings to uppercase automatically when they are stored, other
than triggers.
Kai, if thats what you are looking for, i dont think so, at least i cant
remember of any other way of doing it.

Fernando Dias
[Team Elevate]



"J. B. Ferguson" <jnobspamfergnospamusonatgnospammaildotcom> escreveu na
mensagem news:45D63036-4CBA-4DAE-A2BF-8EAC38090CB3@news.elevatesoft.com...
> Kai,
>
> Maybe it's too early here, just woke up, but I don't understand your
> question. These statements will work wherever you have any of the types
> listed. Are you asking if there are other options, or other ways to
> perform "case transformation"?
>
> --
> Jan Ferguson [Team Elevate]
>
>
> Kai Peters wrote:
>
>> Hi J.B.,
>>
>> I guess I should have been more precise about the "where" - only in
>> triggers, or are there other options?

Fernando & Kai,

OK...yes, I can see what Kai might mean now. Kai, I agree with Fernando
that I don't know of any automatic way of having this done. You would
have to either use a trigger or write something into your BeforePost
event.
--
Jan Ferguson [Team Elevate]


Fernando Dias wrote:

> Jan
>
> I seems to me that what Kai is wanting to know is if there is any
> other way to convert strings to uppercase automatically when they are
> stored, other than triggers.  Kai, if thats what you are looking for,
> i dont think so, at least i cant remember of any other way of doing
> it.


> > > I guess I should have been more precise about the "where" - only
> > > in triggers, or are there other options?