Form sql view not found, again

2008-04-10 Thread Dwayne Martin
Dear List, I am suffering a recurrence of a problem I sent in back in February. I have a form with no sql view. If I change the db name of a field I get “Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully, but the SQL view is not in

Re: Form sql view not found, again SOLVED AGAIN

2008-04-10 Thread Dwayne Martin
Once again, Doug Mueller came thru with the answer. It was a variation on the previous problem, only this time it was a Diary field instead of a Character. When I did: select fieldId, isLong from field_diary where schemaId = 426 I got: FIELDID: 536870919, ISLONG: 1. Fortunately, we no longer