Kbase 17861: Apptivity - Update and Prepare statement errors - Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Apptivity - Update and Prepare statement errors - Oracle
As noted in the Release Notes for Apptivity 2.0, if you are
- programming against Oracle and
- the tables specified in your SQL SELECT statement do not have
primary keys defined
you should not SELECT columns using the '*'. Instead, you should
refine the SELECT statement to explicitly identify each column in the
select list.
If you use the '*' in a SELECT statement under these circumstances,
you may encounter one or more of the following errors:
- "FROM keyword not found where expected"
- an error indicating that the prepare statement failed
If you refine the SELECT statment to explicitly specify columns, but
have not defined primary key(s) for the table(s) referenced in the SQL
SELECT statement, you may encounter an error on update of the
record(s) found with that query. To eliminate the update error,
define primary key(s) on the table(s).
Progress Software Technical Support Note # 17861