Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Have an application that uses a local view, definition is:
CREATE SQL VIEW "MUSICCAT" ;
AS SELECT Musictbl.catalog, Musictbl.composer, Musictbl.title, ;
....
FROM appdata!musictbl musictbl ;
WHERE &?Criteria
"Criteria" is a PUBLIC variable that is populated before the view is opened. Thus the definition of the view does not change, but the contents presented to each user can vary.
A grid is presented and the user has the option to sort the grid by double-clicking on a column header. The program then creates indexed on the view (INDEX ON UPPER(TITLE) TAG TITLE, for example).
Everything works fine in a stand-alone environment. On a network, however, when adding a new record and issuing a BEGIN TRANSACTION, we get error 1548, indicating that "MusicCat" has a non-structural index open. If the user ignores the error, everything seems to be OK - the new record gets added properly.
Each user runs from a unique workarea on their local hard drive, but sharing a common data directory and DBC.
Wondered if anyone had any idea about what might be going on here.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement