Re: NewEra Newbie - Problem using SuperTable Apply Buttons

Bill Bounds wrote: > > I've been playing around with NewEra for a couple of days and was > trying to make use of the built in Supertable buttons for Query, > Delete, etc and have run into a problem when using the Apply or Apply > All buttons. > > When trying to do an insert of a new row or an update of an existing > row, the apply returns an error and shows me a syntactically incorrect > SQL statement. Either the values to insert are not shown in the SQL > statement (nor any program variables) or in the case of the attempted > update, there is no field assignment immediately after the SET > keyword. > > I'm attempting this on a very simple table (4 columns) which contains > a unique index. The superfield associated with this column has the > primary key property set in its superfield. > > The Query/Retrieve options work just fine, so I know that it is not a > database connection issue. > > Any ideas would be greatly appreciated. > > Thanks, > > Bill Bounds > Director of Software Development > Echo Management Group > billb@echoman.com Bill, There are two things you should check, 1) the updaterole property for each superfield and 2) the primarykey (sp?) property of each superfield. Both of these properties dictate how the SQL is dynamically created. Hope this helps! -Jason