Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jhchrysler

  1. jhchrysler

    Checking for Additions to a .dbf File

    So if I understand you correctly, the triggers added to a .dbc will fire without an executable? I am curious how this is possible without a data engine! I am still unclear as to whether or not I can add an existing .dbf to a .dbc that will allow me to create a trigger on it. This would solve...
  2. jhchrysler

    Checking for Additions to a .dbf File

    From my reading, looks like triggers in Foxpro are handled programmatically and are more like a function, unlike MS SQL where they are handled through the data engine. Can someone verify this for me? If this is the case and I can't add the existing .dbf's to a .dbc then even programming the...
  3. jhchrysler

    Checking for Additions to a .dbf File

    Mike, I've tried both and found that I have different problems with them. The OLEDB Provider for ODBC will allow updates, inserts, etc, but does so with an error which I believe is due to the fact that there are no unique indexes in the .dbf table. They are both extremely slow and I can only...
  4. jhchrysler

    Checking for Additions to a .dbf File

    Craig, Great plan if I was building a Foxpro database from scratch. Problem is the .dbf files are from an existing OTS application built on Clipper using a flat file structure that I have no programming control over. Is it possible to communicate with these files through a Foxpro or...
  5. jhchrysler

    Checking for Additions to a .dbf File

    All, I am wanting to build an interface of sorts for a phone messaging application. The app writes call entries to a .dbf file that I would like to monitor for additions. Once an addition is made to the table, I would like to insert a new record in to a SQL table and change a status field in...

Part and Inventory Search

Back
Top