Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting from a Cursor into an external .dbf
Message
De
06/04/2004 11:36:09
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
06/04/2004 11:31:39
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00892627
Message ID:
00892631
Vues:
16
>Hello,
>I have an application where I populate a cursor. The cursor has the same structure as c:\transact.dbf. What I want to do is append the contents of my cursor onto the end of the c:\transact.dbf. I looked into the insert into query but it seemed like all I could use was memvar. I am confused!!
>
>Thanks!!!
>
>MAC

You can't do it in a single step; I think this will be supported in VFP 9.

In earlier versions, it could go something like this:
select from SomeTable into table TempTable where ...
* if the cursor already exists:
* select SomeCursor
* copy to TempTable
use transact.dbf
append from TempTable
erase TempTable.dbf
HTH,

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform