| Subject | The actual code. |
|---|---|
| Author | dogrocket2003 |
| Post date | 2008-10-09T22:29:09Z |
Figured I would go ahead and submit the code, just to get that out of
way. Should work if change to your example database in php4delpi
. Sorry when saying in previous post it was dbnavigator its actually
dbpaginator. let me know what you think... thanks
<?php
//Includes
//require_once("masterpage.php");
require_once("vcl.inc.php");
use_unit("menus.inc.php");
use_unit("dbctrls.inc.php");
use_unit("db.inc.php");
use_unit("dbtables.inc.php");
use_unit("forms.inc.php");
use_unit("extctrls.inc.php");
use_unit("stdctrls.inc.php");
//Class definition
class JobsForm extends Page
{
public $Noidlabel = null;
public $FetchId = null;
public $FetchQuery = null;
public $FetchButton = null;
public $Memo1 = null;
public $edButton = null;
public $Label17 = null;
public $DBPaginator1 = null;
public $lbMessages = null;
public $btnAdd = null;
public $Label2 = null;
public $dsproducts1 = null;
public $tbproducts1 = null;
public $appsdatabase = null;
public $Panel1 = null;
public $Label16 = null;
public $Edit17 = null;
public $Label13 = null;
public $ComboBox2 = null;
public $ComboBox1 = null;
public $CheckBox7 = null;
public $CheckBox6 = null;
public $CheckBox5 = null;
public $CheckBox4 = null;
public $CheckBox3 = null;
public $CheckBox2 = null;
public $CheckBox1 = null;
public $Label26 = null;
public $Label25 = null;
public $Label24 = null;
public $Label23 = null;
public $Label22 = null;
public $Label21 = null;
public $Label20 = null;
public $Label19 = null;
public $Edit16 = null;
public $Edit15 = null;
public $Edit14 = null;
public $Edit13 = null;
public $Edit12 = null;
public $Edit11 = null;
public $Edit10 = null;
public $Edit9 = null;
public $Edit7 = null;
public $Edit4 = null;
public $Label18 = null;
public $Label7 = null;
public $Edit8 = null;
public $Label15 = null;
public $Label14 = null;
public $Label12 = null;
public $Label11 = null;
public $Label10 = null;
public $Label9 = null;
public $Label8 = null;
public $Label6 = null;
public $Label5 = null;
public $Label4 = null;
public $Label3 = null;
public $Edit6 = null;
public $Edit5 = null;
public $Edit2 = null;
public $Edit1 = null;
public $Label1 = null;
public $btnPost = null;
public $modind = null;
// search dataset for matching JOB ID, usng Paginator actions to move
thru records.
// this makes it sequentially correct to user, after a successfull
record search,
// user can then navigate thru dataset from that point...
function FetchButtonClick($sender, $params)
{
$recfound = null;
//start at first record...
$this->DBPaginator1->linkClick('first');
do {
// fetchId is editbox entry user entered...
if ($this->FetchId->Text == $this->FetchQuery->Fields["I_JOBID"])
{$recfound = 1; break;}
// no match at that record.. goto next rec
$this->DBPaginator1->linkClick('next');
} while (!$this->FetchQuery->EOF);
// show warning label if no record / data match.......
if( $recfound != 1 )
{$this->DBPaginator1->linkClick('first');$this->Noidlabel->Visible =
true; return false;}
}
function Edit17JSChange($sender, $params)
{
// $this->tbproducts1->Cancel();
// ?>
//Add your javascript code here
// return;
// <?php
}
// public $modind = null;
function edButtonClick($sender, $params)
{
//
$this->btnPost->Visible = true;
$this->btnAdd->Enabled = False;
$this->FetchQuery->edit();
// $this->tbproducts1->refresh();
$modind = 3;
$this->Label14->Caption = "Modify Job";
}
function DBPaginator1Click($sender, $params)
{
$this->btnPost->Visible = false;
$modind = 1;
// $this->FetchQuery->SQL = "SELECT * JOBS ";
}
function dbEMPLOYEE1CustomConnect($sender, $params)
{
$sender->_connection->dialect = 3;
}
function btnAddClick($sender, $params)
{
//Cancel any pending change
$this->FetchQuery->Cancel();
//Append a new record
$this->FetchQuery->Append();
$dline[] = " ";
$this->Memo1->Lines = $dline;
$this->Memo1->Visible = true;
$this->Label14->Caption = "Add new Job";
$this->btnPost->Visible = true;
$this->btnAdd->Enabled = False;
//Prompt the user for info
$this->Panel1->Visible = true;
$modind = 2;
}
function JobsFormBeforeShow($sender, $params)
{
//Make the panel visible
$this->Panel1->Visible = true;
// $this->FetchQuery->SQL = "SELECT * FROM JOBS" ;
}
function btnPostClick($sender, $params)
{
//Just post the modified contents so get stored
if ($modind == 2) $this->FetchQuery->Post();
$this->lbMessages->Caption = "Record saved succesfully";
$this->lbMessages->Visible = true;
$modind = 1;
$this->btnPost->Visible = false;
$this->btnAdd->Enabled = true;
$this->Panel1->Visible = true;
$this->Label14->Caption != "View Jobs";
$this->Noidlabel->Visible = False;
}
function JobsFormStartBody($sender, $params)
{
// had my custom stylesheet info, removed for space
}
}
global $application;
global $JobsForm;
//Creates the form
$JobsForm = new JobsForm($application);
//Read from resource file
$JobsForm->loadResource(__FILE__);
//Shows the form
$JobsForm->show();
?>
heres the xml component file
jobstry2.xml.php
<?php
<object class="JobsForm" name="JobsForm" baseclass="page">
<property name="Background"></property>
<property name="Caption">Title of website</property>
<property name="DocType">dtXHTML_1_0_Transitional</property>
<property name="Height">600</property>
<property name="IsMaster">0</property>
<property name="Layout">
<property name="Type">XY_LAYOUT</property>
</property>
<property name="Name">JobsForm</property>
<property name="Width">800</property>
<property name="OnBeforeShowHeader">JobsFormBeforeShow</property>
<property name="OnStartBody">JobsFormStartBody</property>
<object class="Panel" name="Panel1" >
<property name="BorderColor">#008080</property>
<property name="BorderWidth">2</property>
<property name="Caption">Panel1</property>
<property name="Dynamic"></property>
<property name="Height">504</property>
<property name="Layout">
<property name="Type">XY_LAYOUT</property>
</property>
<property name="Left">252</property>
<property name="Name">Panel1</property>
<property name="Top">48</property>
<property name="Visible">0</property>
<property name="Width">432</property>
<object class="Button" name="btnPost" >
<property name="Caption">Save</property>
<property name="Height">25</property>
<property name="Left">168</property>
<property name="Name">btnPost</property>
<property name="Top">464</property>
<property name="Width">99</property>
<property name="OnClick">btnPostClick</property>
</object>
<object class="Label" name="Label1" >
<property name="Caption">products_id</property>
<property name="DataField">I_JOBID</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">14</property>
<property name="Left">60</property>
<property name="Name">Label1</property>
<property name="Top">32</property>
<property name="Width">200</property>
</object>
<object class="Edit" name="Edit1" >
<property name="DataField">COMPANY</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">101</property>
<property name="MaxLength">50</property>
<property name="Name">Edit1</property>
<property name="Text">products_quantity</property>
<property name="Top">61</property>
<property name="Width">272</property>
</object>
<object class="Edit" name="Edit2" >
<property name="DataField">JOB_NAME</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">101</property>
<property name="Name">Edit2</property>
<property name="TabOrder">2</property>
<property name="Text">1</property>
<property name="Top">134</property>
<property name="Width">272</property>
</object>
<object class="Edit" name="Edit5" >
<property name="DataField">POSITION_TERM</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">128</property>
<property name="Name">Edit5</property>
<property name="TabOrder">3</property>
<property name="Text">products_last_modified</property>
<property name="Top">233</property>
<property name="Width">272</property>
</object>
<object class="Edit" name="Edit6" >
<property name="DataField">PAY</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">128</property>
<property name="Name">Edit6</property>
<property name="TabOrder">4</property>
<property name="Text">products_date_available</property>
<property name="Top">270</property>
<property name="Width">80</property>
</object>
<object class="Label" name="Label3" >
<property name="Caption">ID:</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label3</property>
<property name="Top">32</property>
<property name="Width">31</property>
</object>
<object class="Label" name="Label4" >
<property name="Caption">Company</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label4</property>
<property name="Top">65</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label5" >
<property name="Caption">Job Title</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label5</property>
<property name="Top">138</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label6" >
<property name="Caption">Description</property>
<property name="Height">13</property>
<property name="Left">3</property>
<property name="Name">Label6</property>
<property name="Top">191</property>
<property name="Width">63</property>
</object>
<object class="Label" name="Label8" >
<property name="Caption">Position Term</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label8</property>
<property name="Top">237</property>
<property name="Width">96</property>
</object>
<object class="Label" name="Label9" >
<property name="Caption">Pay Rate HR</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label9</property>
<property name="Top">274</property>
<property name="Width">96</property>
</object>
<object class="Label" name="Label10" >
<property name="Caption">Start Date</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label10</property>
<property name="Top">311</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label11" >
<property name="Caption">End Date</property>
<property name="Height">13</property>
<property name="Left">212</property>
<property name="Name">Label11</property>
<property name="Top">311</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label12" >
<property name="Caption">Days Needed</property>
<property name="Height">13</property>
<property name="Left">168</property>
<property name="Name">Label12</property>
<property name="Top">377</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label14" >
<property name="Caption"><![CDATA[<P><FONT
style="BACKGROUND-COLOR: #c0c0c0">Jobs
Listing</FONT></P>]]></property>
<property name="Font">
<property name="Weight">bold</property>
</property>
<property name="Height">13</property>
<property name="Left">27</property>
<property name="Name">Label14</property>
<property name="ParentFont">0</property>
<property name="Top">6</property>
<property name="Width">229</property>
</object>
<object class="Label" name="Label15" >
<property name="Caption">Contact</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label15</property>
<property name="Top">98</property>
<property name="Width">75</property>
</object>
<object class="Edit" name="Edit8" >
<property name="DataField">CONTACT</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">101</property>
<property name="MaxLength">50</property>
<property name="Name">Edit8</property>
<property name="TabOrder">1</property>
<property name="Text">products_price</property>
<property name="Top">94</property>
<property name="Width">272</property>
</object>
<object class="Label" name="Label7" >
<property name="Caption">Start Time</property>
<property name="Height">13</property>
<property name="Left">10</property>
<property name="Name">Label7</property>
<property name="Top">343</property>
<property name="Width">62</property>
</object>
<object class="Label" name="Label18" >
<property name="Caption">End Time</property>
<property name="Height">13</property>
<property name="Left">212</property>
<property name="Name">Label18</property>
<property name="Top">343</property>
<property name="Width">75</property>
</object>
<object class="Edit" name="Edit4" >
<property name="DataField">BEGIN_MONTH</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">90</property>
<property name="MaxLength">2</property>
<property name="Name">Edit4</property>
<property name="TabOrder">5</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit7" >
<property name="DataField">BEGIN_DAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">128</property>
<property name="MaxLength">2</property>
<property name="Name">Edit7</property>
<property name="TabOrder">6</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit9" >
<property name="DataField">BEGIN_YEAR</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">168</property>
<property name="MaxLength">2</property>
<property name="Name">Edit9</property>
<property name="TabOrder">7</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit10" >
<property name="DataField">END_MONTH</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">276</property>
<property name="MaxLength">2</property>
<property name="Name">Edit10</property>
<property name="TabOrder">8</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit11" >
<property name="DataField">END_DAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">316</property>
<property name="MaxLength">2</property>
<property name="Name">Edit11</property>
<property name="TabOrder">9</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit12" >
<property name="DataField">END_YEAR</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">360</property>
<property name="MaxLength">2</property>
<property name="Name">Edit12</property>
<property name="TabOrder">10</property>
<property name="Top">307</property>
<property name="Width">27</property>
</object>
<object class="Edit" name="Edit13" >
<property name="DataField">HOUR_START</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">74</property>
<property name="MaxLength">2</property>
<property name="Name">Edit13</property>
<property name="TabOrder">11</property>
<property name="Top">339</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit14" >
<property name="DataField">MINUTE_START</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">114</property>
<property name="MaxLength">2</property>
<property name="Name">Edit14</property>
<property name="TabOrder">12</property>
<property name="Top">339</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit15" >
<property name="DataField">HOUR_QUIT</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">272</property>
<property name="MaxLength">2</property>
<property name="Name">Edit15</property>
<property name="TabOrder">13</property>
<property name="Top">339</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit16" >
<property name="DataField">MINUTE_QUIT</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">316</property>
<property name="MaxLength">2</property>
<property name="Name">Edit16</property>
<property name="Top">339</property>
<property name="Width">25</property>
</object>
<object class="Label" name="Label19" >
<property name="Caption">/</property>
<property name="Height">13</property>
<property name="Left">120</property>
<property name="Name">Label19</property>
<property name="Top">311</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label20" >
<property name="Caption">/</property>
<property name="Height">13</property>
<property name="Left">158</property>
<property name="Name">Label20</property>
<property name="Top">311</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label21" >
<property name="Caption">/</property>
<property name="Height">13</property>
<property name="Left">309</property>
<property name="Name">Label21</property>
<property name="Top">311</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label22" >
<property name="Caption">/</property>
<property name="Height">13</property>
<property name="Left">352</property>
<property name="Name">Label22</property>
<property name="Top">311</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label23" >
<property name="Caption">:</property>
<property name="Height">13</property>
<property name="Left">101</property>
<property name="Name">Label23</property>
<property name="Top">343</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label24" >
<property name="Caption">:</property>
<property name="Height">13</property>
<property name="Left">142</property>
<property name="Name">Label24</property>
<property name="Top">343</property>
<property name="Width">11</property>
</object>
<object class="Label" name="Label25" >
<property name="Caption">:</property>
<property name="Height">13</property>
<property name="Left">304</property>
<property name="Name">Label25</property>
<property name="Top">343</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label26" >
<property name="Caption">:</property>
<property name="Height">13</property>
<property name="Left">344</property>
<property name="Name">Label26</property>
<property name="Top">343</property>
<property name="Width">9</property>
</object>
<object class="CheckBox" name="CheckBox1" >
<property name="Caption">Mon.</property>
<property name="DataField">MONDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">10</property>
<property name="Name">CheckBox1</property>
<property name="Top">392</property>
<property name="Width">49</property>
</object>
<object class="CheckBox" name="CheckBox2" >
<property name="Caption">Tues.</property>
<property name="DataField">TUESDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">74</property>
<property name="Name">CheckBox2</property>
<property name="Top">392</property>
<property name="Width">57</property>
</object>
<object class="CheckBox" name="CheckBox3" >
<property name="Caption">Wen.</property>
<property name="DataField">WENSDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">135</property>
<property name="Name">CheckBox3</property>
<property name="Top">392</property>
<property name="Width">49</property>
</object>
<object class="CheckBox" name="CheckBox4" >
<property name="Caption">Thu.</property>
<property name="DataField">THURSDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">194</property>
<property name="Name">CheckBox4</property>
<property name="Top">392</property>
<property name="Width">49</property>
</object>
<object class="CheckBox" name="CheckBox5" >
<property name="Caption">Fri.</property>
<property name="DataField">FRIDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">246</property>
<property name="Name">CheckBox5</property>
<property name="Top">392</property>
<property name="Width">41</property>
</object>
<object class="CheckBox" name="CheckBox6" >
<property name="Caption">Sat.</property>
<property name="DataField">SATURDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">295</property>
<property name="Name">CheckBox6</property>
<property name="Top">392</property>
<property name="Width">48</property>
</object>
<object class="CheckBox" name="CheckBox7" >
<property name="Caption">Sun.</property>
<property name="DataField">SUNDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">352</property>
<property name="Name">CheckBox7</property>
<property name="Top">392</property>
<property name="Width">49</property>
</object>
<object class="ComboBox" name="ComboBox1" >
<property name="DataField">AMPM_START</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">25</property>
<property
name="Items"><![CDATA[a:2:{s:2:"AM";s:2:"AM";s:2:"PM";s:2:"PM";}]]></property>
<property name="Left">157</property>
<property name="Name">ComboBox1</property>
<property name="Top">339</property>
<property name="Width">41</property>
</object>
<object class="ComboBox" name="ComboBox2" >
<property name="DataField">AMPM_QUIT</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">25</property>
<property
name="Items"><![CDATA[a:2:{s:2:"AM";s:2:"AM";s:2:"PM";s:2:"PM";}]]></property>
<property name="Left">356</property>
<property name="Name">ComboBox2</property>
<property name="Top">339</property>
<property name="Width">45</property>
</object>
<object class="Label" name="Label13" >
<property name="Caption">Vacancys</property>
<property name="Height">13</property>
<property name="Left">10</property>
<property name="Name">Label13</property>
<property name="Top">424</property>
<property name="Width">75</property>
</object>
<object class="Edit" name="Edit17" >
<property name="DataField">TOTAL_POSTIONS</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">68</property>
<property name="MaxLength">3</property>
<property name="Name">Edit17</property>
<property name="Top">420</property>
<property name="Width">37</property>
</object>
<object class="Label" name="Label16" >
<property name="Caption">Put 0 if you dont want job
listed</property>
<property name="Font">
<property name="Color">#0000FF</property>
</property>
<property name="Height">13</property>
<property name="Left">114</property>
<property name="Name">Label16</property>
<property name="ParentColor">0</property>
<property name="ParentFont">0</property>
<property name="Top">424</property>
<property name="Width">251</property>
</object>
<object class="Memo" name="Memo1" >
<property name="DataField">JOB_DESCRIPTION</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">57</property>
<property name="Left">101</property>
<property name="Lines">a:0:{}</property>
<property name="Name">Memo1</property>
<property name="TabOrder">3</property>
<property name="Top">169</property>
<property name="Width">293</property>
</object>
</object>
<object class="Label" name="Label2" >
<property name="Caption"><![CDATA[If you wish to modify an
existing Job, Click "Edit Job" first, or else any changes
you make wont take.]]></property>
<property name="Height">19</property>
<property name="Left">5</property>
<property name="Name">Label2</property>
<property name="Top">5</property>
<property name="Width">706</property>
</object>
<object class="Button" name="btnAdd" >
<property name="Caption">Add New</property>
<property name="Height">28</property>
<property name="Left">612</property>
<property name="Name">btnAdd</property>
<property name="Top">562</property>
<property name="Width">88</property>
<property name="OnClick">btnAddClick</property>
</object>
<object class="Label" name="lbMessages" >
<property name="Caption">lbMessages</property>
<property name="Font">
<property name="Color">#FF0000</property>
<property name="Weight">bold</property>
</property>
<property name="Height">13</property>
<property name="Left">252</property>
<property name="Name">lbMessages</property>
<property name="ParentFont">0</property>
<property name="Top">31</property>
<property name="Visible">0</property>
<property name="Width">356</property>
</object>
<object class="DBPaginator" name="DBPaginator1" >
<property name="DataSource">dsproducts1</property>
<property name="Font">
<property name="Size">14px</property>
</property>
<property name="Height">30</property>
<property name="Left">343</property>
<property name="Name">DBPaginator1</property>
<property name="ParentFont">0</property>
<property name="ShownRecordsCount">0</property>
<property name="Top">560</property>
<property name="Width">256</property>
<property name="OnClick">DBPaginator1Click</property>
</object>
<object class="Edit" name="FetchId" >
<property name="Font">
<property name="Size">14px</property>
</property>
<property name="Height">31</property>
<property name="Left">34</property>
<property name="Name">FetchId</property>
<property name="ParentFont">0</property>
<property name="Top">472</property>
<property name="Width">81</property>
</object>
<object class="Label" name="Label17" >
<property name="Caption">Retrieve Job Id</property>
<property name="Font">
<property name="Color">#0000A0</property>
<property name="Size">14px</property>
</property>
<property name="Height">21</property>
<property name="Left">17</property>
<property name="Name">Label17</property>
<property name="ParentFont">0</property>
<property name="Top">444</property>
<property name="Width">123</property>
</object>
<object class="Button" name="FetchButton" >
<property name="Caption">Fetch Record</property>
<property name="Height">30</property>
<property name="Left">17</property>
<property name="Name">FetchButton</property>
<property name="Top">512</property>
<property name="Width">115</property>
<property name="OnClick">FetchButtonClick</property>
</object>
<object class="Button" name="edButton" >
<property name="Caption">Edit Job</property>
<property name="Height">29</property>
<property name="Left">211</property>
<property name="Name">edButton</property>
<property name="Top">561</property>
<property name="Width">107</property>
<property name="OnClick">edButtonClick</property>
</object>
<object class="Label" name="Noidlabel" >
<property name="Caption">No Such Id! Try Again</property>
<property name="Color">#C0C0C0</property>
<property name="Font">
<property name="Color">#FF0000</property>
</property>
<property name="Height">29</property>
<property name="Left">8</property>
<property name="Name">Noidlabel</property>
<property name="ParentColor">0</property>
<property name="ParentFont">0</property>
<property name="Top">552</property>
<property name="Visible">0</property>
<property name="Width">163</property>
</object>
<object class="Database" name="appsdatabase" >
<property name="Left">31</property>
<property name="Top">223</property>
<property name="Connected">1</property>
<property
name="DatabaseName">localhost:C:\DWebsite\files\APPLY.FDB</property>
<property name="DriverName">borland_ibase</property>
<property name="Name">appsdatabase</property>
<property name="UserName">SYSDBA</property>
<property name="UserPassword">masterkey</property>
<property name="OnCustomConnect">dbEMPLOYEE1CustomConnect</property>
</object>
<object class="Table" name="tbproducts1" >
<property name="Left">119</property>
<property name="Top">223</property>
<property name="Database">appsdatabase</property>
<property name="MasterFields">a:0:{}</property>
<property name="MasterSource"></property>
<property name="Name">tbproducts1</property>
<property name="TableName">JOBS</property>
</object>
<object class="Datasource" name="dsproducts1" >
<property name="Left">31</property>
<property name="Top">287</property>
<property name="Dataset">FetchQuery</property>
<property name="Name">dsproducts1</property>
</object>
<object class="Query" name="FetchQuery" >
<property name="Left">112</property>
<property name="Top">312</property>
<property name="Active">1</property>
<property name="Database">appsdatabase</property>
<property name="LimitCount">-1</property>
<property name="LimitStart">-1</property>
<property name="Name">FetchQuery</property>
<property name="Order">desc</property>
<property name="Params">a:0:{}</property>
<property name="SQL"><![CDATA[a:1:{i:0;s:18:"Select * From
JOBS";}]]></property>
<property name="TableName">JOBS</property>
</object>
</object>
?>
way. Should work if change to your example database in php4delpi
. Sorry when saying in previous post it was dbnavigator its actually
dbpaginator. let me know what you think... thanks
<?php
//Includes
//require_once("masterpage.php");
require_once("vcl.inc.php");
use_unit("menus.inc.php");
use_unit("dbctrls.inc.php");
use_unit("db.inc.php");
use_unit("dbtables.inc.php");
use_unit("forms.inc.php");
use_unit("extctrls.inc.php");
use_unit("stdctrls.inc.php");
//Class definition
class JobsForm extends Page
{
public $Noidlabel = null;
public $FetchId = null;
public $FetchQuery = null;
public $FetchButton = null;
public $Memo1 = null;
public $edButton = null;
public $Label17 = null;
public $DBPaginator1 = null;
public $lbMessages = null;
public $btnAdd = null;
public $Label2 = null;
public $dsproducts1 = null;
public $tbproducts1 = null;
public $appsdatabase = null;
public $Panel1 = null;
public $Label16 = null;
public $Edit17 = null;
public $Label13 = null;
public $ComboBox2 = null;
public $ComboBox1 = null;
public $CheckBox7 = null;
public $CheckBox6 = null;
public $CheckBox5 = null;
public $CheckBox4 = null;
public $CheckBox3 = null;
public $CheckBox2 = null;
public $CheckBox1 = null;
public $Label26 = null;
public $Label25 = null;
public $Label24 = null;
public $Label23 = null;
public $Label22 = null;
public $Label21 = null;
public $Label20 = null;
public $Label19 = null;
public $Edit16 = null;
public $Edit15 = null;
public $Edit14 = null;
public $Edit13 = null;
public $Edit12 = null;
public $Edit11 = null;
public $Edit10 = null;
public $Edit9 = null;
public $Edit7 = null;
public $Edit4 = null;
public $Label18 = null;
public $Label7 = null;
public $Edit8 = null;
public $Label15 = null;
public $Label14 = null;
public $Label12 = null;
public $Label11 = null;
public $Label10 = null;
public $Label9 = null;
public $Label8 = null;
public $Label6 = null;
public $Label5 = null;
public $Label4 = null;
public $Label3 = null;
public $Edit6 = null;
public $Edit5 = null;
public $Edit2 = null;
public $Edit1 = null;
public $Label1 = null;
public $btnPost = null;
public $modind = null;
// search dataset for matching JOB ID, usng Paginator actions to move
thru records.
// this makes it sequentially correct to user, after a successfull
record search,
// user can then navigate thru dataset from that point...
function FetchButtonClick($sender, $params)
{
$recfound = null;
//start at first record...
$this->DBPaginator1->linkClick('first');
do {
// fetchId is editbox entry user entered...
if ($this->FetchId->Text == $this->FetchQuery->Fields["I_JOBID"])
{$recfound = 1; break;}
// no match at that record.. goto next rec
$this->DBPaginator1->linkClick('next');
} while (!$this->FetchQuery->EOF);
// show warning label if no record / data match.......
if( $recfound != 1 )
{$this->DBPaginator1->linkClick('first');$this->Noidlabel->Visible =
true; return false;}
}
function Edit17JSChange($sender, $params)
{
// $this->tbproducts1->Cancel();
// ?>
//Add your javascript code here
// return;
// <?php
}
// public $modind = null;
function edButtonClick($sender, $params)
{
//
$this->btnPost->Visible = true;
$this->btnAdd->Enabled = False;
$this->FetchQuery->edit();
// $this->tbproducts1->refresh();
$modind = 3;
$this->Label14->Caption = "Modify Job";
}
function DBPaginator1Click($sender, $params)
{
$this->btnPost->Visible = false;
$modind = 1;
// $this->FetchQuery->SQL = "SELECT * JOBS ";
}
function dbEMPLOYEE1CustomConnect($sender, $params)
{
$sender->_connection->dialect = 3;
}
function btnAddClick($sender, $params)
{
//Cancel any pending change
$this->FetchQuery->Cancel();
//Append a new record
$this->FetchQuery->Append();
$dline[] = " ";
$this->Memo1->Lines = $dline;
$this->Memo1->Visible = true;
$this->Label14->Caption = "Add new Job";
$this->btnPost->Visible = true;
$this->btnAdd->Enabled = False;
//Prompt the user for info
$this->Panel1->Visible = true;
$modind = 2;
}
function JobsFormBeforeShow($sender, $params)
{
//Make the panel visible
$this->Panel1->Visible = true;
// $this->FetchQuery->SQL = "SELECT * FROM JOBS" ;
}
function btnPostClick($sender, $params)
{
//Just post the modified contents so get stored
if ($modind == 2) $this->FetchQuery->Post();
$this->lbMessages->Caption = "Record saved succesfully";
$this->lbMessages->Visible = true;
$modind = 1;
$this->btnPost->Visible = false;
$this->btnAdd->Enabled = true;
$this->Panel1->Visible = true;
$this->Label14->Caption != "View Jobs";
$this->Noidlabel->Visible = False;
}
function JobsFormStartBody($sender, $params)
{
// had my custom stylesheet info, removed for space
}
}
global $application;
global $JobsForm;
//Creates the form
$JobsForm = new JobsForm($application);
//Read from resource file
$JobsForm->loadResource(__FILE__);
//Shows the form
$JobsForm->show();
?>
heres the xml component file
jobstry2.xml.php
<?php
<object class="JobsForm" name="JobsForm" baseclass="page">
<property name="Background"></property>
<property name="Caption">Title of website</property>
<property name="DocType">dtXHTML_1_0_Transitional</property>
<property name="Height">600</property>
<property name="IsMaster">0</property>
<property name="Layout">
<property name="Type">XY_LAYOUT</property>
</property>
<property name="Name">JobsForm</property>
<property name="Width">800</property>
<property name="OnBeforeShowHeader">JobsFormBeforeShow</property>
<property name="OnStartBody">JobsFormStartBody</property>
<object class="Panel" name="Panel1" >
<property name="BorderColor">#008080</property>
<property name="BorderWidth">2</property>
<property name="Caption">Panel1</property>
<property name="Dynamic"></property>
<property name="Height">504</property>
<property name="Layout">
<property name="Type">XY_LAYOUT</property>
</property>
<property name="Left">252</property>
<property name="Name">Panel1</property>
<property name="Top">48</property>
<property name="Visible">0</property>
<property name="Width">432</property>
<object class="Button" name="btnPost" >
<property name="Caption">Save</property>
<property name="Height">25</property>
<property name="Left">168</property>
<property name="Name">btnPost</property>
<property name="Top">464</property>
<property name="Width">99</property>
<property name="OnClick">btnPostClick</property>
</object>
<object class="Label" name="Label1" >
<property name="Caption">products_id</property>
<property name="DataField">I_JOBID</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">14</property>
<property name="Left">60</property>
<property name="Name">Label1</property>
<property name="Top">32</property>
<property name="Width">200</property>
</object>
<object class="Edit" name="Edit1" >
<property name="DataField">COMPANY</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">101</property>
<property name="MaxLength">50</property>
<property name="Name">Edit1</property>
<property name="Text">products_quantity</property>
<property name="Top">61</property>
<property name="Width">272</property>
</object>
<object class="Edit" name="Edit2" >
<property name="DataField">JOB_NAME</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">101</property>
<property name="Name">Edit2</property>
<property name="TabOrder">2</property>
<property name="Text">1</property>
<property name="Top">134</property>
<property name="Width">272</property>
</object>
<object class="Edit" name="Edit5" >
<property name="DataField">POSITION_TERM</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">128</property>
<property name="Name">Edit5</property>
<property name="TabOrder">3</property>
<property name="Text">products_last_modified</property>
<property name="Top">233</property>
<property name="Width">272</property>
</object>
<object class="Edit" name="Edit6" >
<property name="DataField">PAY</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">128</property>
<property name="Name">Edit6</property>
<property name="TabOrder">4</property>
<property name="Text">products_date_available</property>
<property name="Top">270</property>
<property name="Width">80</property>
</object>
<object class="Label" name="Label3" >
<property name="Caption">ID:</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label3</property>
<property name="Top">32</property>
<property name="Width">31</property>
</object>
<object class="Label" name="Label4" >
<property name="Caption">Company</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label4</property>
<property name="Top">65</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label5" >
<property name="Caption">Job Title</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label5</property>
<property name="Top">138</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label6" >
<property name="Caption">Description</property>
<property name="Height">13</property>
<property name="Left">3</property>
<property name="Name">Label6</property>
<property name="Top">191</property>
<property name="Width">63</property>
</object>
<object class="Label" name="Label8" >
<property name="Caption">Position Term</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label8</property>
<property name="Top">237</property>
<property name="Width">96</property>
</object>
<object class="Label" name="Label9" >
<property name="Caption">Pay Rate HR</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label9</property>
<property name="Top">274</property>
<property name="Width">96</property>
</object>
<object class="Label" name="Label10" >
<property name="Caption">Start Date</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label10</property>
<property name="Top">311</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label11" >
<property name="Caption">End Date</property>
<property name="Height">13</property>
<property name="Left">212</property>
<property name="Name">Label11</property>
<property name="Top">311</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label12" >
<property name="Caption">Days Needed</property>
<property name="Height">13</property>
<property name="Left">168</property>
<property name="Name">Label12</property>
<property name="Top">377</property>
<property name="Width">75</property>
</object>
<object class="Label" name="Label14" >
<property name="Caption"><![CDATA[<P><FONT
style="BACKGROUND-COLOR: #c0c0c0">Jobs
Listing</FONT></P>]]></property>
<property name="Font">
<property name="Weight">bold</property>
</property>
<property name="Height">13</property>
<property name="Left">27</property>
<property name="Name">Label14</property>
<property name="ParentFont">0</property>
<property name="Top">6</property>
<property name="Width">229</property>
</object>
<object class="Label" name="Label15" >
<property name="Caption">Contact</property>
<property name="Height">13</property>
<property name="Left">24</property>
<property name="Name">Label15</property>
<property name="Top">98</property>
<property name="Width">75</property>
</object>
<object class="Edit" name="Edit8" >
<property name="DataField">CONTACT</property>
<property name="Datasource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">101</property>
<property name="MaxLength">50</property>
<property name="Name">Edit8</property>
<property name="TabOrder">1</property>
<property name="Text">products_price</property>
<property name="Top">94</property>
<property name="Width">272</property>
</object>
<object class="Label" name="Label7" >
<property name="Caption">Start Time</property>
<property name="Height">13</property>
<property name="Left">10</property>
<property name="Name">Label7</property>
<property name="Top">343</property>
<property name="Width">62</property>
</object>
<object class="Label" name="Label18" >
<property name="Caption">End Time</property>
<property name="Height">13</property>
<property name="Left">212</property>
<property name="Name">Label18</property>
<property name="Top">343</property>
<property name="Width">75</property>
</object>
<object class="Edit" name="Edit4" >
<property name="DataField">BEGIN_MONTH</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">90</property>
<property name="MaxLength">2</property>
<property name="Name">Edit4</property>
<property name="TabOrder">5</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit7" >
<property name="DataField">BEGIN_DAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">128</property>
<property name="MaxLength">2</property>
<property name="Name">Edit7</property>
<property name="TabOrder">6</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit9" >
<property name="DataField">BEGIN_YEAR</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">168</property>
<property name="MaxLength">2</property>
<property name="Name">Edit9</property>
<property name="TabOrder">7</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit10" >
<property name="DataField">END_MONTH</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">276</property>
<property name="MaxLength">2</property>
<property name="Name">Edit10</property>
<property name="TabOrder">8</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit11" >
<property name="DataField">END_DAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">316</property>
<property name="MaxLength">2</property>
<property name="Name">Edit11</property>
<property name="TabOrder">9</property>
<property name="Top">307</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit12" >
<property name="DataField">END_YEAR</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">360</property>
<property name="MaxLength">2</property>
<property name="Name">Edit12</property>
<property name="TabOrder">10</property>
<property name="Top">307</property>
<property name="Width">27</property>
</object>
<object class="Edit" name="Edit13" >
<property name="DataField">HOUR_START</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">74</property>
<property name="MaxLength">2</property>
<property name="Name">Edit13</property>
<property name="TabOrder">11</property>
<property name="Top">339</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit14" >
<property name="DataField">MINUTE_START</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">114</property>
<property name="MaxLength">2</property>
<property name="Name">Edit14</property>
<property name="TabOrder">12</property>
<property name="Top">339</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit15" >
<property name="DataField">HOUR_QUIT</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">272</property>
<property name="MaxLength">2</property>
<property name="Name">Edit15</property>
<property name="TabOrder">13</property>
<property name="Top">339</property>
<property name="Width">25</property>
</object>
<object class="Edit" name="Edit16" >
<property name="DataField">MINUTE_QUIT</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">316</property>
<property name="MaxLength">2</property>
<property name="Name">Edit16</property>
<property name="Top">339</property>
<property name="Width">25</property>
</object>
<object class="Label" name="Label19" >
<property name="Caption">/</property>
<property name="Height">13</property>
<property name="Left">120</property>
<property name="Name">Label19</property>
<property name="Top">311</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label20" >
<property name="Caption">/</property>
<property name="Height">13</property>
<property name="Left">158</property>
<property name="Name">Label20</property>
<property name="Top">311</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label21" >
<property name="Caption">/</property>
<property name="Height">13</property>
<property name="Left">309</property>
<property name="Name">Label21</property>
<property name="Top">311</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label22" >
<property name="Caption">/</property>
<property name="Height">13</property>
<property name="Left">352</property>
<property name="Name">Label22</property>
<property name="Top">311</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label23" >
<property name="Caption">:</property>
<property name="Height">13</property>
<property name="Left">101</property>
<property name="Name">Label23</property>
<property name="Top">343</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label24" >
<property name="Caption">:</property>
<property name="Height">13</property>
<property name="Left">142</property>
<property name="Name">Label24</property>
<property name="Top">343</property>
<property name="Width">11</property>
</object>
<object class="Label" name="Label25" >
<property name="Caption">:</property>
<property name="Height">13</property>
<property name="Left">304</property>
<property name="Name">Label25</property>
<property name="Top">343</property>
<property name="Width">19</property>
</object>
<object class="Label" name="Label26" >
<property name="Caption">:</property>
<property name="Height">13</property>
<property name="Left">344</property>
<property name="Name">Label26</property>
<property name="Top">343</property>
<property name="Width">9</property>
</object>
<object class="CheckBox" name="CheckBox1" >
<property name="Caption">Mon.</property>
<property name="DataField">MONDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">10</property>
<property name="Name">CheckBox1</property>
<property name="Top">392</property>
<property name="Width">49</property>
</object>
<object class="CheckBox" name="CheckBox2" >
<property name="Caption">Tues.</property>
<property name="DataField">TUESDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">74</property>
<property name="Name">CheckBox2</property>
<property name="Top">392</property>
<property name="Width">57</property>
</object>
<object class="CheckBox" name="CheckBox3" >
<property name="Caption">Wen.</property>
<property name="DataField">WENSDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">135</property>
<property name="Name">CheckBox3</property>
<property name="Top">392</property>
<property name="Width">49</property>
</object>
<object class="CheckBox" name="CheckBox4" >
<property name="Caption">Thu.</property>
<property name="DataField">THURSDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">194</property>
<property name="Name">CheckBox4</property>
<property name="Top">392</property>
<property name="Width">49</property>
</object>
<object class="CheckBox" name="CheckBox5" >
<property name="Caption">Fri.</property>
<property name="DataField">FRIDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">246</property>
<property name="Name">CheckBox5</property>
<property name="Top">392</property>
<property name="Width">41</property>
</object>
<object class="CheckBox" name="CheckBox6" >
<property name="Caption">Sat.</property>
<property name="DataField">SATURDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">295</property>
<property name="Name">CheckBox6</property>
<property name="Top">392</property>
<property name="Width">48</property>
</object>
<object class="CheckBox" name="CheckBox7" >
<property name="Caption">Sun.</property>
<property name="DataField">SUNDAY</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">352</property>
<property name="Name">CheckBox7</property>
<property name="Top">392</property>
<property name="Width">49</property>
</object>
<object class="ComboBox" name="ComboBox1" >
<property name="DataField">AMPM_START</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">25</property>
<property
name="Items"><![CDATA[a:2:{s:2:"AM";s:2:"AM";s:2:"PM";s:2:"PM";}]]></property>
<property name="Left">157</property>
<property name="Name">ComboBox1</property>
<property name="Top">339</property>
<property name="Width">41</property>
</object>
<object class="ComboBox" name="ComboBox2" >
<property name="DataField">AMPM_QUIT</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">25</property>
<property
name="Items"><![CDATA[a:2:{s:2:"AM";s:2:"AM";s:2:"PM";s:2:"PM";}]]></property>
<property name="Left">356</property>
<property name="Name">ComboBox2</property>
<property name="Top">339</property>
<property name="Width">45</property>
</object>
<object class="Label" name="Label13" >
<property name="Caption">Vacancys</property>
<property name="Height">13</property>
<property name="Left">10</property>
<property name="Name">Label13</property>
<property name="Top">424</property>
<property name="Width">75</property>
</object>
<object class="Edit" name="Edit17" >
<property name="DataField">TOTAL_POSTIONS</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">21</property>
<property name="Left">68</property>
<property name="MaxLength">3</property>
<property name="Name">Edit17</property>
<property name="Top">420</property>
<property name="Width">37</property>
</object>
<object class="Label" name="Label16" >
<property name="Caption">Put 0 if you dont want job
listed</property>
<property name="Font">
<property name="Color">#0000FF</property>
</property>
<property name="Height">13</property>
<property name="Left">114</property>
<property name="Name">Label16</property>
<property name="ParentColor">0</property>
<property name="ParentFont">0</property>
<property name="Top">424</property>
<property name="Width">251</property>
</object>
<object class="Memo" name="Memo1" >
<property name="DataField">JOB_DESCRIPTION</property>
<property name="DataSource">dsproducts1</property>
<property name="Height">57</property>
<property name="Left">101</property>
<property name="Lines">a:0:{}</property>
<property name="Name">Memo1</property>
<property name="TabOrder">3</property>
<property name="Top">169</property>
<property name="Width">293</property>
</object>
</object>
<object class="Label" name="Label2" >
<property name="Caption"><![CDATA[If you wish to modify an
existing Job, Click "Edit Job" first, or else any changes
you make wont take.]]></property>
<property name="Height">19</property>
<property name="Left">5</property>
<property name="Name">Label2</property>
<property name="Top">5</property>
<property name="Width">706</property>
</object>
<object class="Button" name="btnAdd" >
<property name="Caption">Add New</property>
<property name="Height">28</property>
<property name="Left">612</property>
<property name="Name">btnAdd</property>
<property name="Top">562</property>
<property name="Width">88</property>
<property name="OnClick">btnAddClick</property>
</object>
<object class="Label" name="lbMessages" >
<property name="Caption">lbMessages</property>
<property name="Font">
<property name="Color">#FF0000</property>
<property name="Weight">bold</property>
</property>
<property name="Height">13</property>
<property name="Left">252</property>
<property name="Name">lbMessages</property>
<property name="ParentFont">0</property>
<property name="Top">31</property>
<property name="Visible">0</property>
<property name="Width">356</property>
</object>
<object class="DBPaginator" name="DBPaginator1" >
<property name="DataSource">dsproducts1</property>
<property name="Font">
<property name="Size">14px</property>
</property>
<property name="Height">30</property>
<property name="Left">343</property>
<property name="Name">DBPaginator1</property>
<property name="ParentFont">0</property>
<property name="ShownRecordsCount">0</property>
<property name="Top">560</property>
<property name="Width">256</property>
<property name="OnClick">DBPaginator1Click</property>
</object>
<object class="Edit" name="FetchId" >
<property name="Font">
<property name="Size">14px</property>
</property>
<property name="Height">31</property>
<property name="Left">34</property>
<property name="Name">FetchId</property>
<property name="ParentFont">0</property>
<property name="Top">472</property>
<property name="Width">81</property>
</object>
<object class="Label" name="Label17" >
<property name="Caption">Retrieve Job Id</property>
<property name="Font">
<property name="Color">#0000A0</property>
<property name="Size">14px</property>
</property>
<property name="Height">21</property>
<property name="Left">17</property>
<property name="Name">Label17</property>
<property name="ParentFont">0</property>
<property name="Top">444</property>
<property name="Width">123</property>
</object>
<object class="Button" name="FetchButton" >
<property name="Caption">Fetch Record</property>
<property name="Height">30</property>
<property name="Left">17</property>
<property name="Name">FetchButton</property>
<property name="Top">512</property>
<property name="Width">115</property>
<property name="OnClick">FetchButtonClick</property>
</object>
<object class="Button" name="edButton" >
<property name="Caption">Edit Job</property>
<property name="Height">29</property>
<property name="Left">211</property>
<property name="Name">edButton</property>
<property name="Top">561</property>
<property name="Width">107</property>
<property name="OnClick">edButtonClick</property>
</object>
<object class="Label" name="Noidlabel" >
<property name="Caption">No Such Id! Try Again</property>
<property name="Color">#C0C0C0</property>
<property name="Font">
<property name="Color">#FF0000</property>
</property>
<property name="Height">29</property>
<property name="Left">8</property>
<property name="Name">Noidlabel</property>
<property name="ParentColor">0</property>
<property name="ParentFont">0</property>
<property name="Top">552</property>
<property name="Visible">0</property>
<property name="Width">163</property>
</object>
<object class="Database" name="appsdatabase" >
<property name="Left">31</property>
<property name="Top">223</property>
<property name="Connected">1</property>
<property
name="DatabaseName">localhost:C:\DWebsite\files\APPLY.FDB</property>
<property name="DriverName">borland_ibase</property>
<property name="Name">appsdatabase</property>
<property name="UserName">SYSDBA</property>
<property name="UserPassword">masterkey</property>
<property name="OnCustomConnect">dbEMPLOYEE1CustomConnect</property>
</object>
<object class="Table" name="tbproducts1" >
<property name="Left">119</property>
<property name="Top">223</property>
<property name="Database">appsdatabase</property>
<property name="MasterFields">a:0:{}</property>
<property name="MasterSource"></property>
<property name="Name">tbproducts1</property>
<property name="TableName">JOBS</property>
</object>
<object class="Datasource" name="dsproducts1" >
<property name="Left">31</property>
<property name="Top">287</property>
<property name="Dataset">FetchQuery</property>
<property name="Name">dsproducts1</property>
</object>
<object class="Query" name="FetchQuery" >
<property name="Left">112</property>
<property name="Top">312</property>
<property name="Active">1</property>
<property name="Database">appsdatabase</property>
<property name="LimitCount">-1</property>
<property name="LimitStart">-1</property>
<property name="Name">FetchQuery</property>
<property name="Order">desc</property>
<property name="Params">a:0:{}</property>
<property name="SQL"><![CDATA[a:1:{i:0;s:18:"Select * From
JOBS";}]]></property>
<property name="TableName">JOBS</property>
</object>
</object>
?>