can't select records with object ptr field

Christer Olsson christer at ljusaideer.se
Mon May 14 03:58:26 CDT 2007


Try to wrap the name of the field in [], like tablename.[user]

   *************************************************************
   Christer Olsson   PO Box 9160        Phone +46 40 25 85 85
   Ljusa Idéer AB    SE-200 39 Malmo    Fax +46 40 25 85 89
   Kantyxegatan 5    Sweden             http://www.ljusaideer.se


14 maj 2007 kl. 05.26 skrev Robert Nichols:

> 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



More information about the Valentina mailing list