Opening Stock.dbf using a .NET program
  • Shane

    Opening Stock.dbf using a .NET program

    by Shane » Fri Apr 04, 2008 5:16 pm

    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"
  • COBS Tech Support
    Posts: 678
    Joined: Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Fri Apr 04, 2008 5:19 pm

    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.
  • Richard F
    Posts: 6
    Joined: Thu Jun 08, 2006 2:25 pm

    How do we get this ActiveX/OLE control

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

    Hi,

    How do I get this ActiveX/OLE control.

    Thanks
  • COBS Tech Support
    Posts: 678
    Joined: Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Thu Jun 26, 2008 11:25 am

    Documentation available here:

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

    Pricing for a licence is $495 + GST.

Who is online

Users browsing this forum: No registered users and 1 guest