> Yup

> I think from what you say, i can even open the mysql database from

within

> vfp, and then open a table just like any other table?

>

> S

No....

The commands I typed are from the msql command prompt, NOT the VFP

command window.

It is similar syntax and commands, but venture much further and they

(commands) start to diverge a lot more.

You can easily connect to mysql tables via ODBC (as was recently

discussed here), or you can feed data into your tables from the msql

command prompt with INSERT commands. The SQL syntax for VFP versus mySql

is virtually the same as I recall. BUT mySql enforces (can't remember

what the name if it is called) 'proper' GROUP BY syntax, whereas VFP

let's you be pretty free form.

Thanks,

Matthew Jarvis || Business Systems Analyst

IT Department

McKenzie-Willamette Medical Center

1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax:

541-744-6145

--------------------------------------------------------------------------

Disclaimer: This electronic message may contain information that is

Proprietary, Confidential, or legally privileged or protected. It

is intended only for the use of the individual(s) and entity named

in the message. If you are not an intended recipient of this

message, please notify the sender immediately and delete the

material from your computer. Do not deliver, distribute or copy

this message and do not disclose its contents or take any action in

reliance on the information it contains.

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/69F310C05DD83C48A84BA3769CE1ECF805C01968@TNTRIEXEVS02.triadhospitals.net

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.