Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    17

    Unanswered: FoxPro applications with Oracle database

    Good morning,

    Here at my work, we are discussing of what will be the best development environment to develop applications that will suit to a data structure common to Clipper (on handhelds) so DBF files, local database files (surely dbf files) and we plan to put data from these local files to an Oracle database.

    Most of the people here want to develop with Visual FoxPro.

    My question is :

    With FoxPro, is it easy to take data from dbf files and put it into an Oracle database?

    If you have other solutions, feel free to give me your suggestions.

    Thanks!

    Steve

  2. #2
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Re: FoxPro applications with Oracle database

    Originally posted by Zteev
    Good morning,

    Here at my work, we are discussing of what will be the best development environment to develop applications that will suit to a data structure common to Clipper (on handhelds) so DBF files, local database files (surely dbf files) and we plan to put data from these local files to an Oracle database.

    Most of the people here want to develop with Visual FoxPro.

    My question is :

    With FoxPro, is it easy to take data from dbf files and put it into an Oracle database?

    If you have other solutions, feel free to give me your suggestions.

    Thanks!

    Steve
    Hi,
    Yes you can use dbf files (fox pro) files to synchonize with a handheld.
    One of the methods that i know is writing an MS Excel Macro to do the
    data transfer.
    However, a better method to store data on a handheld is fixed width
    ascii text, but this totally does depend on your application.

    Hope it helps.
    nn

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    My question is :

    With FoxPro, is it easy to take data from oracle and put it into dbf?

    If you have other solutions, feel free to give me your suggestions.

    Thanks!

    Steve

  4. #4
    Join Date
    Dec 2003
    Posts
    47
    This is my solution but I don't think it is the best
    I use ODBC to create a system DNS to Oracle
    In Foxpro (I use Visual Foxpro 6.0) create a connection
    From DBF to Oracle: I scan the table and use insert command
    From Oracle to DBF: I use select command to a cursor, after that copy to DBF file

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •