mySQL views to not display derived columns names

I have a simple join that uses a coalesce to resolve null columns into sequnce numbers (if the name is null)

coalesce(gr.Name,s.MenuSeq) AS MenuChoice

for some strange reason, this column will not show up at a DataProviderResourse.

Other columns that are not derived work fine, and this column shows up in the query tool, and the Server browser. IT's not in the DataProvider Object ...

[413 byte] By [anicewick] at [2007-11-26 11:03:30]
# 1
Hello:I had the same problem and I solved this way.The mysql conncector 5.0 has a problem with this....just go back a release to 3.1.11 andi install this. It will work fine then.Good LuckMark
zxy at 2007-7-7 3:17:24 > top of Java-index,Development Tools,Java Tools...