could you create your view or cursor or whatever with a command like
select (am>order #) as am_order_no, anotherfield from mytable
That will allow you to rename the local fields...
>I have connected successfully, using ODBC, to some remote data. In my case its to Btrieve data, but that's not significant for this question.
>
>Most of the tables have "normal" field names and work fine. The tables I now have to access, have field names like the following:
>
>AM>Driver
>AM>Order #
>AM>Order Date
>
>My error message says that there is no such column. I saw an earlier thread (but can't currently find it) that talked about problems with the # character and had some sort of workaround. I seem to also be having trouble with the > character. I'm also confused as to how to handle imbedded spaces in the field names. I'm trying to do something like
>SELECT * FROM TheTable WHERE (AM>Order #) = "12345"
>
>I don't have the option of having the field names changed in the remote data.
>
>Bob
--Todd Sherman
-Wake Up! Smell the Coffee!