Re: Visual Basic 5 with Informix CLI 2.5

In article <6o0jk3$76n@world2.bellatlantic.net>, jbramble@trendmls.com says... >I am trying to edit a field in an ODBC data source using Informix CLI 2.5 >from a snippet of code written in Visual Basic 5.0. The problem I am >running into is that every attempt I make to insert, or edit a field, I >receive an error that the database is read-only. The most common cause of this message is when Visual Basic cannot find a unique index for the table. This may happen when you actually do not have a unique index, when the solution is to add one (an Informix serial field, if nothing else, will do the trick). It may also happen when the primary index is created as a constraint rather than an actual index; the SQL used by some ODBC drivers to figure out whether there is a unique index frequently does not take constraints into account. ----- William Harris