Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

indexes and form painter

2 posts in PB Infomaker Report Writer Last posting was on 1998-12-03 16:09:47.0Z
Mike Proffitt Posted on 1998-12-03 14:15:05.0Z
Newsgroups: sybase.public.infomaker.general
Date: Thu, 03 Dec 1998 09:15:05 -0500
From: Mike Proffitt <mproffit@offo2.epa.ohio.gov>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: indexes and form painter
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 24
Message-ID: <348_36669CE8.BA2662E8@offo2.epa.ohio.gov>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6689
Article PK: 241676

I am trying to create a form using form painter so that our staff can
enter data into our data base. I go into form painter create a new
form, choose quick select / free form, select my table and add all
columns. When I hit OK, I get the following error message:
"No table index exists or at least one table index column is not
included in data source. Data can be displayed but not updated".

A little info about the database:

It was originally created in Fox pro 2.5 for windows. I tried to create
the form and got the above message, so I converted it over to Access.
Using Access, I checked the database and made sure that all fields were
indexed. When I used the database painter in Infomaker, it also showed
that all fields were indexed.

How do I get past this point so that we can enter data through a form?
Any help would be greatly appreciated. Thanks.

Mike Proffitt
mike.proffitt@epa.state.oh.us


Terry Dykstra Posted on 1998-12-03 16:09:47.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: indexes and form painter
Date: Thu, 3 Dec 1998 09:09:47 -0700
Lines: 30
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_Uv4$Z1sH#GA.151@forums.powersoft.com>
References: <348_36669CE8.BA2662E8@offo2.epa.ohio.gov>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:6688
Article PK: 241674

There must be an unique index or primary key. Regular indexes are not good
enough.

--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Mike Proffitt wrote in message <36669CE8.BA2662E8@offo2.epa.ohio.gov>...
>I am trying to create a form using form painter so that our staff can
>enter data into our data base. I go into form painter create a new
>form, choose quick select / free form, select my table and add all
>columns. When I hit OK, I get the following error message:
>"No table index exists or at least one table index column is not
>included in data source. Data can be displayed but not updated".
>
>A little info about the database:
>
>It was originally created in Fox pro 2.5 for windows. I tried to create
>the form and got the above message, so I converted it over to Access.
>Using Access, I checked the database and made sure that all fields were
>indexed. When I used the database painter in Infomaker, it also showed
>that all fields were indexed.
>
>How do I get past this point so that we can enter data through a form?
>Any help would be greatly appreciated. Thanks.
>
>Mike Proffitt
>mike.proffitt@epa.state.oh.us
>