<?php
// Version: 1.28beta  (D0.01).  Generated: 2001-Jun-17 17:56:33
// Visit http://www.phplens.com for more info & updates on PHPLens
		
//---------------------------------------------------------
// This initialization code needs to be declared only once
if (!defined('PHPLENS_DIR')) define('PHPLENS_DIR','d:/Inetpub/wwwroot/php/phplens/gridbuilder/..');
include_once(PHPLENS_DIR.'/phplens.inc.php');
session_start();
// Place code above before any HTML is sent to client
?>

<?php


$lens = PHPLensPConnect('profnew',"select * from lens_profile where profile not like '*%' order by seq",'mysql','localhost','root','','xphplens_2');
if (! $lens) die('PHPLens 740556d5 failed to start');
//-----------------------------------------------------
// to disable dynamic editing, uncomment the line below
//$lens->dynEdit = 0;


//----------------------------------------------------------
// Define Lens properties which cannot be defined through UI
$lens->password = '';	// Password to modify everything, including SQL
$lens->menuHide = '';	// Which menu items to hide. Eg. menuHide="ALL;NAV;FILTER" to hide ALL, NAV=hide next/prev btns, FILTER=hide search 
$lens->canEdit = true;	// Show Edit Button
$lens->canNew = true;	// Show New Record Button
$lens->canDelete = true;	// Show Delete Button

//--------------------------------------------------------
// Define Lens properties which can be set through the UI


$lens->keyTable = 'lens_profile';	// Save Data Table
$lens->keyCol = 'PROFILE';	// Primary Key of Save Data Table
$lens->pageSize = 10;	// rows per page

$lens->nameLens = 'DEFPERMS^DEFPERMS^Default Perms<br>(R=readonly I=insert U=update D=delete <br>S=search Y=system tables)^Default Perms<br>(R=readonly I=insert U=update D=delete <br>S=search Y=system tables)^';

$lens->lookupLens = 'DEFPERMS^=R/R/I/I/U/U/D/D/S/S/Y/Y';
$lens->checkboxLens = 'DEFPERMS';	// Show as checkbox
# Modify the samples to create your own stored procedures. Note: spNew does not include defaultLens values 
# $this->spNew = "spnew({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spNew = "insert into lens_profile(PROFILE, DEFPERMS, SEQ) values ({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spEdit = "spedit({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spEdit= "update lens_profile set PROFILE={PROFILE}, DEFPERMS={DEFPERMS}, SEQ={SEQ} where PROFILE={PROFILE}";




# Modify the samples to create your own stored procedures. Note: spNew does not include defaultLens values 
# $this->spNew = "spnew({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spNew = "insert into lens_profile(PROFILE, DEFPERMS, SEQ) values ({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spEdit = "spedit({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spEdit= "update lens_profile set PROFILE={PROFILE}, DEFPERMS={DEFPERMS}, SEQ={SEQ} where PROFILE={PROFILE}";

//-----------------
// Generate HTML

$lens->Render();
$lens->Close();
?>
<br>
<?php

//////////////////

$lens = PHPLensPConnect('profstd',"select * from lens_profile where profile like '*%' order by seq",'mysql','localhost','root','','xphplens_2');
if (! $lens) die('PHPLens 740556d5 failed to start');
//-----------------------------------------------------
// to disable dynamic editing, uncomment the line below
//$lens->dynEdit = 0;

//----------------------------------------------------------
// Define Lens properties which cannot be defined through UI
$lens->password = '';	// Password to modify everything, including SQL
$lens->menuHide = 'ALL';	// Which menu items to hide. Eg. menuHide="ALL;NAV;FILTER" to hide ALL, NAV=hide next/prev btns, FILTER=hide search 
$lens->canEdit = false;	// Show Edit Button
$lens->canNew = false;	// Show New Record Button
$lens->canDelete = false;	// Show Delete Button

//--------------------------------------------------------
// Define Lens properties which can be set through the UI


$lens->keyTable = 'lens_profile';	// Save Data Table
$lens->keyCol = 'PROFILE';	// Primary Key of Save Data Table
$lens->pageSize = 10;	// rows per page


# Modify the samples to create your own stored procedures. Note: spNew does not include defaultLens values 
# $this->spNew = "spnew({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spNew = "insert into lens_profile(PROFILE, DEFPERMS, SEQ) values ({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spEdit = "spedit({PROFILE}, {DEFPERMS}, {SEQ})";
# $this->spEdit= "update lens_profile set PROFILE={PROFILE}, DEFPERMS={DEFPERMS}, SEQ={SEQ} where PROFILE={PROFILE}";


//-----------------
// Generate HTML

$lens->Render();
$lens->Close();
?>
