Reserved words for field names?

[Ruslan Zasukhin]

On 12/15/04 8:34 PM, "Arthur Clemens" <arthur at visiblearea.com> wrote:

Hi Arthur,

> After some hair pulling this afternoon I found out from trial and error
> that I cannot use the word "from" in a field name.

> I had modified a table with the new field "derived_from". I could
> successfully add the field, but I could not query the table for that
> field. It was there, listed in Valentina Carbon and in ViSQL Carbon,
> but I got a 602 error when using SELECT on that field.
> 
> When I changed the field name to "derived" everything worked as should.
> 
> Is this normal, or is this a bug?

1) it is bug because you use devired_from
    so it is not exact 'from' keyword

2) by SQL standard you cannot use keywords of SQL




-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------