Re: Using I-SQL Forms with a fragmented table

>From: stiglich@promarkone.com >Date: Tue, 25 Mar 1997 17:51:15 -0600 >X-Informix-List-Id: <news.35801> > >I am trying to use an ISQL Form to query against a table that is >fragmented across multiple dbspaces. However, I get an error >saying no rowid's and nothing is returned. Is this a bug or a "feature" >:-) Will this affect 4gl cursors? I am using Online 7.2.2 and 6.05 of >ISQL. It's a feature! Read the release notes, which should cover this in excruciating detail. Put simply: fragmented tables don't have rowids unless you specify WITH ROWIDS when you create them. Perform relies on rowids to handle updates, etc. When it is run on a table which doesn't have them, it fails. It won't affect I4GL cursors unless you try using ROWID in your I4GL code too. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>