Kbase 15507: Updatable browser in v8 and date fields in oracle db.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Updatable browser in v8 and date fields in oracle db.
It is possible to get a GPF under windows with progress V8 under the
following circumstances when either checking syntax or loading a .w
in the UIB.
- You have an updatable browser in that window.
- At least one table of an updatable field in the browser contains 4
dates fields.
- You are connected to an oracle database.
- The oracle database was created through SQL.
If this is the case, there are several workarounds:
1- Create a progress database first and then use the protoora tool to
generate the corresponding oracle database.
2- Create a 5th date field in that table, or suppress one unused date
field.
3- In the schema-holder, delete all the fields that have extension
'-1'
Note: What contains a field with extension '-1' in the schema holder?
In an oracle database one date is stored as an integers in one field.
This format includes the hours. When you build the schema holder,
progress can not use this date format. It needs two fields to store
the same informatation: On for the date (progress format) and one for
the hours which has extension '-1'.
Exemple:
Oracle database Progress schema holder
table xxx table xxx
datetest : date (oracle format) datetest : date (progress format)
datetest-1 : int. (to store hours)
Progress Software Technical Support Note # 15507