Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace .NULL. with value in a view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00225758
Message ID:
00225762
Vues:
13
>I am creating 2 local views with the following characteristics:
>
>Table A has cFileno
>Table B has cFileno, cName, cGroup where cGroup can either be "1" or "2"
>
>View 1:
>For each A.cfileno there is at least one or more B.cfileno from cGroup "1".
>With this I create LocalView1
>
>View 2:
>For each A.cfileno there is not always a B.cfileno from cGroup "2"
>
>I need a second local view where all A.cfileno are present including the ones that do not have a B.cfileno from cGroup "2". I can create that view and I obtain B.cfileno = .NULL. for those that are not equal to A.cfileno.
>
>Now instead of the null for those records I want to substitute a fixed (same) value to all of them. (The value is a common cFileno from Table B in cGroup 2) How can I do that?
>
>Thanks in advance

Raymond,
SELECT View2
REPLACE ALL ViewFieldName WITH "FileName" FOR ISNULL(ViewFieldName)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform