if ($gDB) {
$arr = $gDB->MetaTables();
}
print PHPLensArrayMenu('table2 onchange=fetchtable2() ', $arr, true, $lens_qb_detail, false);
?>
</td><td width=50%>
Foreign Key
<?php
if ($gDB) {
$colarr = $gDB->MetaColumns($lens_qb_detail);
}
if ($colarr) {
$arr = array();
foreach ($colarr as $k => $v) {
$arr[] = $k;
}
print PHPLensArrayMenu('col2 onchange=fetchtable2() ', $arr, true, $lens_qb_detail_key, false);
}
?>
</td></tr>
</table>
</FORM>
<?php
if (!empty($lens_qb_master) && !empty($lens_qb_master_key) && !empty($lens_qb_detail) && !empty($lens_qb_detail_key)) {
print "<a href=masterdetail2.php?table={$lens_qb_master}>Generate Master Detail Code</a>";
}
?>
</body>
</html>
<table border=0 width='100%'><tr><td>
<FORM name=gettable> <b>Table</b>
<?php
if ($gDB) {
$arr = $gDB->MetaTables();
}
print PHPLensArrayMenu('tables onchange=fetchtable() ', $arr, true, false, false);
?>
</FORM>
</td><td>
<FORM name=getdriver> <b>Database</b>
<?php
$arr = array();
foreach ($PHPLENS_DATABASES as $k => $v) {
$arr[] = $k;
}
print PHPLensArrayMenu('drivers onchange=fetchdb() ', $arr, false, $lens_qb_drivername, false);
?>
<a href=sql.php target=_top><b>SQL Tool</b></a>
</FORM>
</td><td align=right>
<form>
<a href=confighelp.html target=_confighelp>Builder Help</a>
</form>
</td></tr>
</table>
</body>
</html>
