Returning a partial string

[Ruslan Zasukhin]

On 7/10/05 2:59 PM, "jda" <jda at his.com> wrote:

> I have instituted the temporary method technique and it works very
> well. So my problem is solved.
> 
> BTW, if my app crashes before I can drop the temporary field (say, in
> the middle of the sql query) will the field be part of the db, and
> I'll get an error when trying to open it again?

Good question. Ivan ?

> I do NOT do a 
> db.flush between creating the field, doing the query, and dropping
> the field.

I think system tables get updated.

TMP Tables do not go into system tables at all.
TMP fields -- it seems we have no such mechanism...

We really need all it working in select ...
Although again, this will be slower solution, because each time it needs
build index for that new column.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]