Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append blank
Message
De
10/09/2008 08:46:21
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
10/09/2008 06:58:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01346279
Message ID:
01346293
Vues:
7
>hi all,
>
>i need to append new blank record , or if i have any data remove it
>as
>
>INSERT INTO qcombined1 (name,amt,dedcode,nat.....
>append blank
>replace all fields with space""
>or replace record with space"" 
>
>thanks for help

To add a new record, you either use INSERT INTO, or APPEND BLANK. You don't combine both.

Here is an example of each:
* INSERT INTO example
* This will create a new record and assign values in a single step.
insert into MyTable (Field1, Field2) values (Value1, Value2)

* APPEND BLANK example
* APPEND BLANK will only add a blank record; you then need a REPLACE to assign values
select MyTable
append blank
replace;
  Field1 with Value1,;
  Field2 with Value2
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
Répondre
Fil
Voir

Click here to load this message in the networking platform