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 place. (ARWARN 69).”
The last time the problem turned out to be “ISLONG” character fields, but I ran the same selection statement and found no such fields. In fact, there are no fields > 255 chars in the form. If I run an sql log I see: **** /CREATE VIEW LA_SILab (Request_ID,Submitter,Create_Date,Assigned_To,Last_Modified_By,Modified_Date,Status,Lab_Name,Software_title,Computer _type,What_to_do_,Work_Log,Others_still_In_Progress,Install_number,Valid_Through,Last_modified_by_person_Date,Attachment_Field4,Attachment_Field5,Attachment_F ield6) AS SELECT T426.C1,C2,C3,C4,C5,C6,C7,C8,C536870916,C536870917,C536870918,C536870919,C536870921,C540003300,C560000069,C563000663,CO1000000004||';'||CC100 0000004||';'||C1000000004,CO1000000005||';'||CC1000000005||';'||C1000000005,CO1000000006||';'||CC1000000006||';'||C1000000006 FROM T426, B426 WHERE T426.C1 = B426.C1,T426C536870919 WHERE T426.C1 = T426C536870919.entryId <SQL > <TID: 0023399328> <RPC ID: 0000001601> <Queue: Admin > <Client-RPC: 390600 > <USER: martinrd > /* Thu Apr 10 2008 10:41:57.5490 */*** ERROR *** ORA-00933: SQL command not properly ended *** If I run this statement in TOAD I get “ORA-00933: SQL command not properly ended” and it hi-lites the next to last “C1”. The form name is “LA:SILab”. I checked for fields with names the same as Oracle keywords. I have no problem updating other forms. So if all you good people who came to my aid last time would like to try again I will be very glad for your help. (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
