Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
1 field become 2 fields in newtable
Message
De
01/10/2006 05:17:12
 
 
À
29/09/2006 12:07:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01158176
Message ID:
01158429
Vues:
29
For versions below VFP 9 you might try something like
SELECT MAX(IIF(recno()=1,amount,SPACE(LEN(amount)))) as amount1,;
       MAX(IIF(recno()=2,amount,SPACE(LEN(amount)))) as amount2;
INTO TABLE newtable
>Hi all,
>
>I have mytable
>
>amount ( char. field) with 2 records
>10000
>20000
>
>to get newtable with 2 fields with 1 record
>
>newtable ( this table already exists with a structure)
>amount1 amount2
>10000 20000
>
>This is to transfert from mytable 2 records to newtable to get 1 record
>but 2 fields ( amount1 and amount2 ).
>
>TIA for who can help me out.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform