utahfuntimes

HENRY SMITH JONES BURTON-GOODRICH How can I build a calc to change these 3 example last names to proper case? The first two I know how to do, but when the field contains a - dash between two names with no space, I cant quite figure that one out.

I have my FM9 setup to access a SQL table. The only thing is that I can not make changes to any data within a recored. If I try to change any field data, I just get an error: ODBC Error: Update or insert of view or function "PRO01.dbo.ARTRAN_Sales" failed because it contains a derived or constant field. Anyone seen an error like this?

Well I found the problem... when choosing the external data source, there is an option for filtering by... with a views check box. I did not see it. Checking it now makes the SQL views show up.

Quick question: I have setup an external data source...using ODBC to look at a Microsoft SQL 2005 database. Everything is working fine. I can access the various SQL tables and add them to my FM solution. ONE problem...SQL views. How do I access a view? I know how to access different tables...under manage database...relationships tab...I just double click my table, choose my datasource, and then I see a list of all the SQL tables to choose from. But I only see a list of tables...no views. How do I choose a view?

OK. So here is what seems to solve the problem...and this thinking goes along with xochi's comments above...the fact that he did a reinstall to get it to work. Go to your FM folder. Open the Extensions folder. Open the web support folder. Move the item called "FM Web Publishing" to your desktop. Now launch FM. Your IWP will of course not work. Quite FM. Move "FM Web Publishing" back into the "Web Support" folder again. Now when you launch FM all should be working properly again. I have confirmed this with both machines I was having problems with...it seems to have fixed it. This is better than doing a complete reinstall. Larry

FOLLOW-UP! My above post WAS NOT an isolated incident. To test the latest Apple update, I updated a second machine. FM IWP did work for a while...but after one day it is now broken. The first machine was a desktop PPC, the second machine was a Intel-based Macbook Pro. This confirms there is a BIG issues with the latest Apple update and FM IWP. Be warned!

BIG problems. Did the install. Restarted my computer. Now IWP is hosed. Can not even get it to run. My entire FM IWP solution will not run any more. I had to port it all over to another computer.

Your answer "Yes" was nice...how about some elaboration?

I would love to know the answer to this one as well.