Need assistance with fpODBC

[Rick Hane]

-----Original Message-----
From: Kenneth Brody [mailto:kenbrody at spamcop.net] 
Sent: Thursday, October 25, 2012 9:41 AM
To: Rick Hane
Cc: file Pro Mailing List
Subject: Re: Need assistance with fpODBC

On 10/24/2012 4:58 PM, Rick Hane wrote:
>>[... Populating a file from an ODBC "import" ...]
>>
>> Thanks for the reply and information.  Here is the info I copied from

>> the ODBC link in Excel.
>>[...]
>> From this I see most that I need to set up the ODBC Link in fp.
>> I looked through the ODBC 'Sample' files and I have three questions.

>> I am still not understanding the flow.
>>
>> 1. In what filePro file do you put this link? New or do you use the 
>> 'sample' files they came with fp?
>>
>> 2. If it is a new file, do you create a record for each table to
read?
>>
>> 3. If it is only one link definition, do you "use" the appropriate 
>> table in each processing?
>>
>> As I said I'm just not getting the flow.  Actually it just my age
(64).

> If you were to populate a filePro from from a CSV file via IMPORT
ASCII, how would you do it?  The same answers apply to your 3 questions
above.
>
>(Again, this is going under the assumption that you want to "import"
the file into filePro, rather than have live access to the SQL data.)
>
>--
>Kenneth Brody

Ken,

That's my point exactly.

I use dif with import dif but it's the same.  The link, tables and
fields are all defined in the dif file.  There is no intermediate file
any longer.

So I assume (insert joke here) that I would define the link, table and
fields in the import process.  If that is correct then I just
misunderstood what the sample files show and all makes sense.

Thanks
Rick