forms on a fragmented table

Hi all, I'm having a little issue with fragmented tables and forms I build on them. This is the senario, I have a table XYZ which is fragmented by months (5 mths) over 5 dbspaces. Now I want to build a form (isql dbname) forms generate and then run the form on the table XYZ but when I query its gives me a message "rowid does not exist on table" and a followup one that says "the cursor or statement is not available" and the final one being "there are no rows satisfing the condition" Is there a way to let the forms use records number instead of the rowid? THX 4 all ur help. Marco

Fragmented tables do not have the pseudo-column ROWID as that rowid is not unique across dbspaces/fragments. You can add a hidden automatically indexed column rowid to any fragmented table to serve the same purpose by: ALTER TABLE xyz ADD ROWIDS; That should make ISQL happy. Art S. Kagel ----- Original Message ----- From: Marco Marin <mmarin@btl.net> At: 6/16 12:03 > Hi all, I'm having a little issue with fragmented tables and forms I build on > them. This is the senario, I have a table XYZ which is fragmented by months (5 > mths) over 5 dbspaces. Now I want to build a form (isql dbname) forms generate > and then run the form on the table XYZ but when I query its gives me a message > "rowid does not exist on table" and a followup one that says "the cursor or > statement is not available" and the final one being "there are no rows satisfing > the condition" > Is there a way to let the forms use records number instead of the rowid? > THX 4 all ur help. > Marco