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