can't select records with object ptr field

[Bart Pietercil]

Hi Robert,

I have had to change my tablename "users" to something else.
I am using 3.0 (2.5.9 did not have this problem).

However I don't think it is a "problem" but part of the new feature  
set, I suppose user is used in the sys tables.

When you look in the SQL keywords in the WIKI you see that user and  
users are reserved words.

Conclusion: change in your db the use of word "user(s)"

hth

Bart Pietercil



On 14-mei-07, at 05:26, Robert Nichols wrote:

> I have a table with an object ptr field named "user".
>
> I can't successfully select any records from the table using the  
> value of field "user" as a criterion. No matter how simple the  
> query. All other object ptr fields in the table can be selected no  
> problem. I have reindexed field.
>
> Interesting: when I try to diagnose the field, I get a failure:
>
>   23:19:49: line 1:28: unexpected token: user
>   23:19:49: Kernel error: 0x71000
>   23:19:49: line 1:28: unexpected token: user
>
> All other fields in the table diagnose fine.
>
> Did not have this problem with 2.5.6.
>
> val server 2.5.10, v4rb 2.5.10
> Mac OSX
> rb 5.5
>
>
> ______________________________________________________________________ 
> _______
>
> robert nichols
>
> formwork design llc | 114 3rd st ne | charlottesville, va 22902 |  
> www.formworkdesign.com
>
>
>
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina