Kbase 20733: ODBC(SQL 89) and Progress database extents fields explained.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/4/2008 |
|
Status: Unverified
GOAL:
How Progress database extent fields are handled using the Merant 3.60 ODBC SQL 89 driver.
FACT(s) (Environment):
Progress 8.3x
FIX:
When working with an application using Merant ODBC (SQL 89) and Progress Database V8.3x, SQL interprets each extent as a separate field.
Example:
If the following fields exist:
Name Datatype Extent
Cust-num integer 3
Name char 2
Displaying the field information using a:
SELECT cust-num, name FROM customer.
Will be shown as:
cust-num__1 cust-num__2 cust-num__3 name__1 name__2.
In order to insert data into a field that has extents it should be done as follows:
INSERT INTO customer (cust-num__1, cust-num__2, cust-num__3, name__1, name__2) VALUES ("100", "110", "120", "Helen", "Robin").