The online community for software testing & quality assurance professionals
 
 
Calendar   Today's Topics
Sponsors:




Lost Password?

Home
BetaSoft
Blogs
Jobs
Training
News
Links
Downloads



Testing Tools >> IBM/Rational Robot

Pages: 1
ronadp
Junior Member


Reged: 08/18/04
Posts: 1
Loc: CT
Using OLE to read FoxPro DBF files
      #144130 - 08/18/04 01:10 PM

Hello. I am attempting to use OLE through Robot to access FoxPro DBF files. I have been able to do this successfully by converting the DBF file to an Excel file and then using Excel OLE commands. However, one of our developers stated that he believes there are OLE commands that can bring me directly into the DBF files without having to convert them to Excel first. I could then look at tables, rows, columns, and fields instead of having to deal with Excel objects.

Would anyone know how I can access a DBF via OLE and how I would access the fields? I am mainly interested in syntax. If anyone could recommend a reference site or book that would be great too.

For example, in Excel I would use the following to read from cell A1:

Dim EO as object
Dim BO as object
Dim SO as object

Set EO = CreateObject("Excel.Application")
Set BO = EO.Workbooks.Open("C:\myfile.xls")
Set SO = BO.WorkSheets("Sheet1")

sVal = SO.Range("A1").Value

But what would be the similar syntax to do this in a FoxPro DBF?


Post Extras: Print Post   Remind Me!   Notify Moderator  
John_Dempsey
Newbie


Reged: 11/01/11
Posts: 1
Re: Using OLE to read FoxPro DBF files [Re: ronadp]
      #690012 - 11/01/11 10:25 AM

DBF databases can be repaired due to recover foxpro. It owns high end, easy to use interface for any experienced user. The program is able to work under any Windows OS. The software doesn't modify source data during restoration.

Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1



Extra information
0 registered and 7 anonymous users are browsing this forum.

Moderator:  AJ, RSBarber 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 2319

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5