Jump to content

Archived

This topic is now archived and is closed to further replies.

AV1611

Hooking to visual fox pro table?

Recommended Posts

anyone had success hooking to visual fox pro table? is there an odbc avail? I do access all the time, but seem to have problems with this...

Share this post


Link to post
Share on other sites
I would imagine you could use ODBC or some sort of COM object to talk to it. I've never tried it, however.

[a href=\"http://us2.php.net/manual/en/function.dbase-open.php\" target=\"_blank\"]http://us2.php.net/manual/en/function.dbase-open.php[/a]

You might want to read the comment at the bottom of that page.

Share this post


Link to post
Share on other sites
Well, I got it, but how do I make this not so sloooooooooowwwwwwwww....

<?php
$i=1;
$user="";
$host="localhost";
$password="";

$database = "teknetix";

mysql_connect($host,$user,$password);

mysql_select_db($database);

$kill=mysql_query("delete from firstpass") or die("kill:".mysql_error());

$connect = odbc_connect("QES9000", "", "");
$query = "SELECT itdatshta.`it_date`, itdatshta.`insptype`, itdatshta.`process`, itdatshta.`product`, itdatshta.`descr`,
itdatshta.`rev_level`, itdatshta.`serialno`, itdatshta.`failed`
FROM `itdatshta` itdatshta";
$result = odbc_do($connect, $query);
WHILE($row=odbc_fetch_array($result))
{
$it_date=$row['it_date'];
$insptype=$row['insptype'];
$process=$row['process'];
$product=$row['product'];
$descr=$row['descr'];
$rev_level=$row['rev_level'];
$serialno=$row['serialno'];
$failed=$row['failed'];
$query = mysql_query
("insert into firstpass (it_date, insptype, process, product, descr, rev_level, serialno, failed) values ('$it_date', '$insptype', '$process', '$product', '$descr', '$rev_level', '$serialno', '$failed')") or die(mysql_error());
echo $i;
echo "\n";
$i++;
}
odbc_close($connect);
?>

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.