Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Feature is not available
Message
From
31/08/2009 12:37:32
 
 
To
31/08/2009 12:35:53
Raza Malik
Universal Accounting Software
Edgewater, New Jersey, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01421918
Message ID:
01421919
Views:
64
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform