Table meta data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan Bell - 13 Aug 2003 22:00 GMT

Hi all,

I'm trying to read a vfp table with 1+ records in it into
a MYSQL database using PHP. I know I've seen an article
somewhere on how to read the table meta data so that I
can move to the correct character position in each record
for the individual fields, but I can't for the life of me
find it.

Can anyone help please.

Regards
Bryan

Reply to this Message

Lee Mitchell - 14 Aug 2003 15:52 GMT

Hi Bryan:

What metadata information are you looking for? What is PHP? I am not
familiar with this abbreviation. Do you have VFP or are you simply
connecting from MySQL?

You might want to think about posting this on the discussing group at
www.universalthread.com/. I am not sure how much MySQL expertise we have
in this forum.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retires June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003

>Hi all,

>I'm trying to read a vfp table with 1+ records in it into
>a MYSQL database using PHP. I know I've seen an article
>somewhere on how to read the table meta data so that I
>can move to the correct character position in each record
>for the individual fields, but I can't for the life of me
>find it.

>Can anyone help please.

>Regards
>Bryan

Reply to this Message

Bryan Bell - 14 Aug 2003 20:32 GMT

Hi,

The meta data is the table header info that tells you
what the field data type is, its size, its postion in the
record etc., so that you can read the record as though it
is an ascii file and parse the data out of it.

I'll try your suggestion about the other group.

Ceers
Bryan

>-----Original Message-----
>Hi Bryan:
[quoted text clipped - 18 lines]
>Read about all the new features of VFP8 here:
>

http://www.universalthread.com/VisualFoxPro/News/VFP8Relea
se.asp

>Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
[quoted text clipped - 19 lines]
>
>.

Reply to this Message

Lee Mitchell - 15 Aug 2003 15:23 GMT

Hi Bryan:

Visual FoxPro has functions like Afields() and commands like COPY STRUCTURE
EXTENDED, but neither of these is going to give you detailed information
you need.

In VFP, you can use low-level file functions (FOPEN(), FREAD(), FSEEK(),
etc) to read the table data, but these functions don't work thought our
ODBC driver. Can you call them from your application somehow?

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retires June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003

>Hi,

>The meta data is the table header info that tells you
>what the field data type is, its size, its postion in the
>record etc., so that you can read the record as though it
>is an ascii file and parse the data out of it.

>I'll try your suggestion about the other group.

>Ceers
>Bryan

>-----Original Message-----
>Hi Bryan:
>
>What metadata information are you looking for? What is

PHP? I am not

>familiar with this abbreviation. Do you have VFP or are

you simply

>connecting from MySQL?
>
>You might want to think about posting this on the

discussing group at

>www.universalthread.com/. I am not sure how much MySQL

expertise we have

>in this forum.
>
>I hope this helps.
>
>This posting is provided "AS IS" with no warranties, and

confers no rights.

>Sincerely,
>Microsoft FoxPro Technical Support
[quoted text clipped - 3 lines]
>Read about all the new features of VFP8 here:
>

http://www.universalthread.com/VisualFoxPro/News/VFP8Relea
se.asp

>Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?

siteID=11518

>Keep an eye on the product lifecycle for Visual FoxPro

here:

>http://support.microsoft.com/default.aspx?id=fh;

[ln];lifeprodv

> - VFP5 Mainstream Support retires June 30th, 2003
> - VFP6 Mainstream Support retires Sept. 30th, 2003
>
>>Hi all,
>
>>I'm trying to read a vfp table with 1+ records in it

into

>>a MYSQL database using PHP. I know I've seen an article
>>somewhere on how to read the table meta data so that I
>>can move to the correct character position in each

record

>>for the individual fields, but I can't for the life of

>>find it.
>
>>Can anyone help please.
>
>>Regards
>>Bryan

Reply to this Message