I have a DBF with 503 fields in my server . I could able to open in read only using dBase V. The dbf is updated thru an application. I want to query the file using VB or VFP. Thanks for all inadvance .
Hari
As yuu have been told on other forum use ODBC to query the data in parts and connect them with a 1-to-1 relation.
Dear Cetinbasoz
Will you please tell me which odbc driver I should use to query.
As I know vfp does not accept tables with more than 255 fields. You may need to split you table in order to use it with vfp.
What does that mean "I am unable to query". What is the aerror() result? Is ODBC driver is for dBase V? Did you try querying just a few fields first? If that succeeds proceed with split queries.
S.G.K.Hari,
We are changing the issue type to “Comment” because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to “Question” by editing your initial post and changing the radio button at the top of the post editor window. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.
Thank you!
