Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Read and execute large SQL Scripts that stored in file
Message
De
09/08/2002 07:40:39
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
09/08/2002 00:06:22
Ken Wong
Aspect Computing
Hawthorn, Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00687823
Message ID:
00687887
Vues:
12
>I am using FoxPro 5 and trying to use SQLEXEC to execute some large SQL scripts that are stored in plain ASCII text file.
>
>I am using FOPEN and FREAD to retrieve the contents of a SQL script file and store them into a string. Then I use SQLEXEC to execute the contents of the string.
>
>I am worry that the character string has limitation and not able to store the whole contents of the file and therefore can't pass to SQLEXEC to process.
>
>Do anyone has better solution such as running the SQL script directory from the file?
>
>Thanks

Ken,
A script file should easily fit VFP string limit (16 Mb). 255 chars limit only applies to literal strings. However possibly I'd use isql to run scripts.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform