Page 1 of 1

Opening Stock.dbf using a .NET program

Posted: Fri Apr 04, 2008 5:16 pm
by Shane
I am accessing the capital DBF files from an external .NET program using the
OleDb Provider for Visual FoxPro
I have no problems accessing SORDERS.DBF, SOSTOCK.DBF & SUPPLIER.DBF, but
when attempting to access STOCK.DBF
I get the following error:
File 'staddkeytitle.prg" does not exist.

This error totally baffles me, I have google'd "staddkeytitle.prg" and came
up with nothing, so I assume it is Capital Office related, my connection
string is as follows:
"Provider=VFPOLEDB.1;Data
Source=\\belldc\Capital\CAPITAL\Bellanco;Collating Sequence=MACHINE"

Posted: Fri Apr 04, 2008 5:19 pm
by COBS Tech Support
STKEYTITLE is a user defined indexing function for keywords and your OleDB Provider is probably attempting to report to you that it doesn't know how to resolve that index tag. Some things you might be able to try:

1. See if you can open the table without opening its structural index (but the Provider may not allow this).
2. Copy the STOCK.DBF file to a location without the STOCK.CDX and open it from that location
3. Turn off key word search in CAPITAL and run a Database Maintenance to update your index.

A fourth option coming soon is that we will be releasing a new product; an ActiveX/OLE control that will give users access to CAPITAL tables and scripting functions. If you use our control instead of the Visual FoxPro one, you should not have any problems accessing CAPITAL tables.

How do we get this ActiveX/OLE control

Posted: Wed Jun 25, 2008 11:06 pm
by Richard F
Hi,

How do I get this ActiveX/OLE control.

Thanks

Posted: Thu Jun 26, 2008 11:25 am
by COBS Tech Support
Documentation available here:

http://www.capitaloffice.com.au/downloa ... eclass.chm

Pricing for a licence is $495 + GST.