PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → AS400 Native Access
AS400 Native Access
Débuté par gknott, 11 nov. 2007 10:28 - 2 réponses
Posté le 11 novembre 2007 - 10:28
I'm just starting out using Windev with the AS400 native access. I am starting out by bringing up two AS400 files in the analysis. Both are physical files. Both have several indexes (logical files). When I look at the files, the first file just shows the primary key and the second file shows the primary key and two composite keys which match the associated logical files. Why would the composite keys not show up on the first file?

Thanks

Glenn
Posté le 11 novembre 2007 - 18:46
If the logical File uses only one field of the table, in the analysis the field is matched with the logical file. Composite keys are build for keys with more than one field.

Konrad

>I'm just starting out using Windev with the AS400 native access. I am starting out by bringing up two AS400 files in the analysis. Both are physical files. Both have several indexes (logical files). When I look at the files, the first file just shows the primary key and the second file shows the primary key and two composite keys which match the associated logical files. Why would the composite keys not show up on the first file?

Thanks


>Glenn
Posté le 11 novembre 2007 - 21:54
Hi Glenn,
Adding to Konrad post, must also say that if the logical indexes have 'omit' or 'include' clauses, these inexes are not retrieved by the physical file import. You must import them separately.

Christian

I'm just starting out using Windev with the AS400 native access. I am starting out by bringing up two AS400 files in the analysis. Both are physical files. Both have several indexes (logical files). When I look at the files, the first file just shows the primary key and the second file shows the primary key and two composite keys which match the associated logical files. Why would the composite keys not show up on the first file?

Thanks

Glenn