Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Important
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00549630
Message ID:
00549867
Vues:
17
SET SAFETY OFF is scoped to each private datasession. So you need to include these types of commands in the INIT of any of your form base classes that use Private datasessions. Second, check for existence of the file first:
IF FILE(some_var + ".dbf")
   * handle it here
ENDIF
>Actually within the loop I am creating a view lv_Head_Claim from 3 tables. After creating the view I am copying the data to a new table whose name I donot know but the name of the new table is same as the value in the variable called VarBatch_num, which actually is the value from the Batch_num field of the view.Lets say the varBatch_num has the value "AC072", this should be the name of the new table in which i will insert the data from the view. So I wrote the command
>
> copy to (varBatch_num)
>that creates the table "AC072" and copies the data too. Loop now puts different value in varBatch_num and again the new table is created say "AC073" etc.. This works fine.
> Sometimes if a table of name say "AC072" already exist, I get the message "f:\pinnapp\Ac072 already exist. Do you want to overwrite it" ( earlier it gave me the message "File in use..). In this scenerio I donot want the user to see this message box rather the existing table should be deleted so that copy command could create the new table with same name without giving user any message. Inserting data in existing data won't work as the structure of already existing table can be different.
>
>thanks
>bharat
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform