This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1— Section header —
1.1Button [1.1 Properties] Set the panel colour to yellow Set the font style to italic
1.2Button [1.2 Leave month Extract month name / month index from cmbQ1_2 Check IF (sMonth = 'June'\
1.3Button [1.3 Calculate Extract A and
0.5ower (do not accept hard coding\ Pi or 22/7 or 3.14
1.4Button [1.4 Marks] Initialise counter and total Input mark Start conditional loop to test mark <>
1.5Button [1.5 Anagram] If length of two word strings are equal Loop from 1 to length of word 1 string Use character at index
Q2— Section header —
2.1SQL statements
2.1.1Button [2.1.1 Bloemfontein clients SELECT * FROM tblClients WHERE City = "Bloemfontein" ORDER BY
2.1.2Button [2.1.2 First month] SELECT Col lectionID, CollectionDate, Number OfCans FROM tblCanCollection WHERE Month
2.1.3Button [2.1.3 Search SELECT FROM tblC lients WHERE ClientID LIKE
2.1.4Button [2.1.4 Client earnings] SELECT ClientName, FORMAT(SUM (Number OfCans /7
2.1.5Button [2.1.5 Update] UPDATE tblCanCollection SET Number OfCans = 250 , Paid = False WHERE CollectionID = "C003"
Q2— Section header —
2.2DATABASE MANIPULATION using Delphi code
2.2.1Button [2.2.1 Insert] Insert/append mode Assign to correct field names Using the correct values for each field Post tblClients.Insert;
2.2.2Button [2.2.2 Percentage] Display the name and surname of the client selected Initialise variables Go to the fi st record in the tblCanCollection table
Q3— Section header —
3.1.1Constructor Create Con tructor heading
3.1.2procedure incNumOfPanels rocedure heading with integer parameter fNumberOfPanels := fNumberOfPanels parameter
3.1.3procedure setSeason procedure heading with string type
3.1.4function alculate Capacity function heading with real data type Test if fSeason = 'Summer' hours = 10 else
3.1.5function toString Function declared with string as return data type All attributes part of string to return
Q3— Section header —
3.2.1Button [3.2.1 Instantiate object] Extract the data from the components converted to
3.2.2Button [3.2.2 Increase panels] Call incNumOfPanels method using value from the spin edit as an argument Display plant code using
3.2.3Button [3.2.3 Update season] Call setSeason method using the season selected from the combo box as an argument Display information in the rich edit using toString method
3.2.4Button [3.2. Calculate] isplay a suitable description including the season
Q4— Section header —
4.1Button [4.1 Display] Outer loop from 1 to length of array Or 10 Start output string with name[
4.2Button [4.2 Calculate] Initialise Max variable to 0 Outer loop from 1 to length of arrNames (10\ Initialise amount paid to 0 Inner loop
4.3Button [4.3 Add item] Test if name OR item are NOT selected Display message if name or item not selected Extract item from component Extract OR determine row(index\ of name
Q1— Section header —
Q2— Section header —
Q3— Section header —
Q4— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q1— Section header —
Q2— Section header —
Q2— Section header —
Q2— Section header —
Q2— Section header —
Q2— Section header —
Q2— Section header —
2.1.3// Provided code sLetter := InputBox('','En ter first letter of ClientID',' '\ sSQL3 := SELECT * FROM tblClients ' +
Q2— Section header —
Q2— Section header —
Q2— Section header —
Q2— Section header —
Q2— Section header —
Q2— Section header —
Q2— Section header —
2.2.2redQ2_2_2.Lines.Add(tblClients['ClientName']+' '+tblClients['ClientSurname']+#13\ iCompanyTotal := 0; iClientTotal := 0; tblCanCollection.First; while NOT (tblCanCollection.Eof\ begin if sYear = IntToStr(Y
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q3— Section header —
Q4— Section header —
Q4— Section header —
Q4— Section header —
Q4— Section header —
Q4— Section header —
Q4— Section header —
Q4— Section header —