Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Feature is not available
Message
De
31/08/2009 12:37:32
 
 
À
31/08/2009 12:35:53
Raza Malik
Universal Accounting Software
Edgewater, New Jersey, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01421918
Message ID:
01421919
Vues:
63
How big is the FPT file on disk?

>Hello Experts!
>
>I have just encountered a strange proble. I have a table with 74000 records and each record about 2K with 4 memo fields. I use
>SPT commands using VFP ODBC connection to insert new records. List below is a sample code is use to insert new records:
>
>
>                     lcWrk_numb = "123"
>                     lnID = 90223
>
>	lcSQL = "INSERT INTO wo_a(wrk_numb, iid_numb) VALUES (?lcWrk_numb, ?lnID) "
>	=ExecuteSql(lcSql)	
>
>
>It was working fine until recently. I get the following error:
>
>
>Connectivity Error [Microsoft ODBC???] Feature is not available
>
>
>I deleted about 10000 records from the file and the error went away. Can someone tell me what is going on ? ANy suggession or work around.
>
>Thank you in advance
>
>
>Raza Malik
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform