Starting Out With Visual Basic (8th Edition)
8th Edition
ISBN: 9780135204658
Author: Tony Gaddis, Kip R. Irvine
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 3.4, Problem 3.19CP
Explanation of Solution
Result:
- Cint is a function that is used to convert an expression to an integer.
- If the input value contains numbers after the decimal point then a special rounding known as banker’s rounding occurs...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Will this code work correctly?
DECLAREv_fname VARCHAR2(20);BEGIN
DECLARE
v_lname VARCHAR2(20);
BEGIN
v_fname:= 'Hassan';
v_lname:= 'Al Kathiri';
DBMS_OUTPUT.PUT_LINE (v_fname || ' ' || v_lname);
END;
DBMS_OUTPUT.PUT_LINE (v_fname || ' ' || v_lname);END;
Select one:
True
False
Create another application/class named EmployeeDatabase that allows you to store anarray that acts as a database of any number of Employee objects up to 25. While the userdecides to continue, offer three options: to add a record to the database, to delete a recordfrom the database, or to change a record in the database. Then proceed as follows:If the user selects the add option, issue an error message if the database is full.Otherwise, prompt the user for an Id. If the Id already exists in the database, issuean error message. Otherwise, prompt the user for rest of the inputs and add the newrecord to the database.If the user selects the delete option, issue an error message if the database is empty.Otherwise, prompt the user for an Id. If the Id does not exist, issue an error message.Otherwise, delete the record.If the user selects the change option, issue an error message if the database is empty.Otherwise, prompt the user for an Id. If the requested record does not exist, issuean…
Create a trigger that will prefix the values of item category with ‘dev-‘ when a new row insinserted. For example if the inserted category is ‘rdf’ then then the value should become ‘devrdf’. Below is the item tableCREATE TABLE Item (ItemID NUMBER PRIMARY KEY, category VARCHAR2(12));
Write in SQL
Chapter 3 Solutions
Starting Out With Visual Basic (8th Edition)
Ch. 3.1 - What TextBox control property holds text entered...Ch. 3.1 - Prob. 3.2CPCh. 3.1 - Prob. 3.3CPCh. 3.1 - Prob. 3.4CPCh. 3.2 - Prob. 3.5CPCh. 3.2 - Write a variable declaration for an Integer...Ch. 3.2 - Which of the following variable names are written...Ch. 3.2 - Prob. 3.8CPCh. 3.2 - What default value is assigned to each of the...Ch. 3.2 - Write a Date literal for the following date and...
Ch. 3.2 - Prob. 3.11CPCh. 3.3 - Prob. 3.12CPCh. 3.3 - Prob. 3.13CPCh. 3.3 - Prob. 3.14CPCh. 3.3 - What will be the final value of dblResult in the...Ch. 3.3 - What will be the final value of dblResult in the...Ch. 3.4 - Prob. 3.17CPCh. 3.4 - Prob. 3.18CPCh. 3.4 - Prob. 3.19CPCh. 3.4 - Will the following statement execute or cause a...Ch. 3.4 - Prob. 3.21CPCh. 3.4 - Assuming that intNumber is an integer variable,...Ch. 3.4 - Prob. 3.23CPCh. 3.4 - How would the following strings be converted by...Ch. 3.5 - Prob. 3.25CPCh. 3.5 - For each of the following numeric formats,...Ch. 3.5 - Prob. 3.27CPCh. 3.5 - In the following table, fill in the expected...Ch. 3.5 - Prob. 3.29CPCh. 3.5 - Prob. 3.30CPCh. 3.6 - Prob. 3.31CPCh. 3.6 - Where do you declare class-level variables?Ch. 3.7 - Prob. 3.33CPCh. 3.7 - Prob. 3.34CPCh. 3.7 - What kind of code does the try block of a...Ch. 3.7 - Prob. 3.36CPCh. 3.7 - Prob. 3.37CPCh. 3.7 - Prob. 3.38CPCh. 3.8 - Prob. 3.39CPCh. 3.8 - Prob. 3.40CPCh. 3.8 - Prob. 3.41CPCh. 3.8 - Prob. 3.42CPCh. 3.8 - Write a programming statement that gives the focus...Ch. 3.8 - Prob. 3.44CPCh. 3.8 - Prob. 3.45CPCh. 3.8 - Prob. 3.46CPCh. 3.8 - When a GroupBox control is deleted, what happens...Ch. 3.8 - Prob. 3.48CPCh. 3.8 - Prob. 3.49CPCh. 3.9 - Prob. 3.50CPCh. 3.9 - Prob. 3.51CPCh. 3.9 - Prob. 3.52CPCh. 3.9 - What Visual Basic function would you use to get...Ch. 3.9 - Prob. 3.54CPCh. 3.11 - Prob. 3.55CPCh. 3.11 - Prob. 3.56CPCh. 3.11 - What is the purpose of single-stepping through an...Ch. 3 - Prob. 1FIBCh. 3 - _____ is a commonly used prefix for TextBox...Ch. 3 - Prob. 3FIBCh. 3 - Prob. 4FIBCh. 3 - Prob. 5FIBCh. 3 - Prob. 6FIBCh. 3 - Prob. 7FIBCh. 3 - When Option Strict is set to ______ only widening...Ch. 3 - A(n) _____ is a specialized routine that performs...Ch. 3 - The _____ function converts an expression to an...Ch. 3 - Prob. 11FIBCh. 3 - Prob. 12FIBCh. 3 - When two operators share an operand, the operator...Ch. 3 - Prob. 14FIBCh. 3 - Prob. 15FIBCh. 3 - Prob. 16FIBCh. 3 - Prob. 17FIBCh. 3 - Prob. 18FIBCh. 3 - Prob. 19FIBCh. 3 - Prob. 20FIBCh. 3 - A(n) ______ is a container for other controls that...Ch. 3 - Prob. 22FIBCh. 3 - Prob. 23FIBCh. 3 - Prob. 24FIBCh. 3 - T F: The TextBox controls Text property holds the...Ch. 3 - Prob. 2TFCh. 3 - T F: The string concatenation operator...Ch. 3 - T F: A local variable may be accessed by any other...Ch. 3 - T F: When a string variable is created in memory,...Ch. 3 - T F: A variables scope is the time during which...Ch. 3 - T F: A variable declared inside a procedure is...Ch. 3 - Prob. 8TFCh. 3 - T F: If the CInt function cannot convert its...Ch. 3 - T F: The multiplication operator has higher...Ch. 3 - T F: A named constants value can be changed by a...Ch. 3 - T F: Only controls capable of receiving input,...Ch. 3 - Prob. 13TFCh. 3 - Prob. 14TFCh. 3 - Prob. 15TFCh. 3 - Prob. 16TFCh. 3 - Prob. 17TFCh. 3 - Prob. 18TFCh. 3 - Prob. 19TFCh. 3 - Prob. 20TFCh. 3 - Prob. 21TFCh. 3 - T F: While single-stepping through an applications...Ch. 3 - Prob. 1MCCh. 3 - Prob. 2MCCh. 3 - You declare a named constant with which keyword?...Ch. 3 - Prob. 4MCCh. 3 - Prob. 5MCCh. 3 - Prob. 6MCCh. 3 - Prob. 7MCCh. 3 - Prob. 8MCCh. 3 - Prob. 9MCCh. 3 - Prob. 10MCCh. 3 - Prob. 11MCCh. 3 - Prob. 12MCCh. 3 - Prob. 1SACh. 3 - How do you clear the contents of a TextBox...Ch. 3 - Prob. 3SACh. 3 - Create variable names that would be appropriate...Ch. 3 - Why should you always make sure that a String...Ch. 3 - Prob. 6SACh. 3 - How would the following strings be converted by...Ch. 3 - Prob. 8SACh. 3 - Prob. 9SACh. 3 - Assuming that the variable dblTest contains the...Ch. 3 - What is the focus when referring to a running...Ch. 3 - Prob. 12SACh. 3 - Prob. 13SACh. 3 - Prob. 14SACh. 3 - Prob. 15SACh. 3 - Prob. 16SACh. 3 - Prob. 17SACh. 3 - Describe three ways to set a breakpoint in an...Ch. 3 - Should a programming language automatically insert...Ch. 3 - Prob. 2WDTCh. 3 - Prob. 3WDTCh. 3 - Prob. 4WDTCh. 3 - Prob. 5WDTCh. 3 - Prob. 6WDTCh. 3 - Prob. 7WDTCh. 3 - Prob. 8WDTCh. 3 - How can you get your application to execute a...Ch. 3 - Prob. 10WDTCh. 3 - Prob. 11WDTCh. 3 - Prob. 1FTECh. 3 - Open the Chap3\ Error2\ Error2 project from the...Ch. 3 - Open the Chap3\ Error3\ Error3 project from the...Ch. 3 - Create a flowchart that shows the necessary steps...Ch. 3 - Prob. 2AWCh. 3 - Prob. 3AWCh. 3 - Prob. 4AWCh. 3 - Convert the flowchart you constructed in Exercise...Ch. 3 - Prob. 6AWCh. 3 - Prob. 7AWCh. 3 - The Miles per Gallon Calculator Problem Create an...Ch. 3 - There are three seating categories at a high...Ch. 3 - Prob. 3PCCh. 3 - A movie theater only keeps a percentage of the...Ch. 3 - Room Charge Calculator Error Display In the Room...Ch. 3 - Prob. 6PCCh. 3 - The Upper West View Yacht club sponsors sailboat...Ch. 3 - Create an application that converts Celsius to...Ch. 3 - Create an application that converts U.S. dollar...Ch. 3 - A retail company must file a monthly sales tax...Ch. 3 - A county collects property taxes on the assessment...Ch. 3 - Joe's Pizza Palace needs an application to...Ch. 3 - Assuming there are no accidents or delays, the...Ch. 3 - Create a VB application that lets the user enter...Ch. 3 - Many financial experts advise that property owners...Ch. 3 - Assume that a bag of cookies holds 40 cookies. The...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- public int readBalance(int acctId) throws SQLException { // TODO: Read balance from given account id using a PreparedStatement // Throw the following exception if the account is not found: // throw new SQLException("Account "+acctId+" not found."); // Use the con instance variable for the JDBC connection. // Make sure to commit() if success or rollback if exception or account is not // found. return 0; }arrow_forwardDetermine if the following front-end statement will call UpdateName when the text entered in the Entry control changes Take the following front-end: <VerticalStackLayout> <Label Text="Enter your Name: "/> <Entry Placeholder="Name" /> </VerticalStackLayout> Additionally, we have the following back-end: private void UpdateName(object sender, EventArgs e) { //will update the name in the backend when called. } This code will call UpdateName when the text entered in the Entry control changes.arrow_forwardIf the current record is the ninth record in a dataset that contains 10 records, which of the following statements will position the record pointer on the tenth record?a. TblEmployBindingSource.Position = 9b. TblEmployBindingSource.Position += 1c. TblEmployBindingSource.MoveLast()d. all of the abovearrow_forward
- which clause or statement in a create statement ensure a certain range of data? a) Set b) From c) Where d) checkarrow_forwardCreate an anonymous block to drop a student from a class. Save the block in a file called drop_student_from_class.sql. You will use the ENROLLMENTS table. Accept a STU_ID and CLASS_ID as input parameters. Include code to confirm the student and class ids of the drop. If no enrollments are dropped, display that instead.arrow_forwardWhich of the following statements shows the command used to input a char array with 30 members? Group of answer choices cin.getline(char_input, 30); cin.getstring(char_input, 30); getline (cin << char_input); getstring(cin << char_input);arrow_forward
- What happens if the following command is executed to manage the garbage files?find . "(" -name A -o -name B")" -exec rm {} \; Choose an answer A The garbage file with the name “A” will be removed. B The garbage files with the names “A” and “B” will be removed. C The garbage file with the name “A” will be located. D The garbage files with the names “A” and “B” will be located.arrow_forwardIn mySQL, the WHERE clause is not used in which types of statements?A. SELECT B. DELETEC. INSERTD. UPDATEarrow_forwardIn Chapter 11, you created the most recent version of the MarshallsRevenue program, which prompts the user for customer data for scheduled mural painting. Now, save all the entered data to a file that is closed when data entry is complete and then reopened and read in, allowing the user to view lists of customer orders for mural types.arrow_forward
- 1-Using SQLite, build an application that mimics the behaviour of an Email Application (in Kotlin) Inbox Sent Deleted Draft Archived Spam The Application should allow users to register and login The Application should allow an admin to manage all the users in the application Create Read Update Delete The Application should have the following tables in the database tblUsers tblMessages tblRanksarrow_forwardCreate Trigger for When a student marks are being inserted, if the marks that are inserted are greater than 50, allow the insertion, but update marks to 50. Marks(Id , Marks) -> Table Fill in the blanks: ___ triggerName Before ___ ON Marks REFERENCING _____ AS nrow FOR EACH ROW WHEN (nrow.marks>50) _____ nrow SET nrow.marks = 50;arrow_forwardUse My Guitar Shop Database Use Microsoft SQL Server Write a script that includes these statements coded as a transaction: INSERT Orders VALUES (3, GETDATE(), '10.00', '0.00', NULL, 4, 'American Express', '378282246310005', '04/2019', 4); SET @OrderID = @@IDENTITY; INSERT OrderItems VALUES (@OrderID, 6, '415.00', '161.85', 1); INSERT OrderItems VALUES (@OrderID, 1, '699.00', '209.70', 1); Here, the @@IDENTITY variable is used to get the order ID value that’s automatically generated when the first INSERT statement inserts an order. If these statements execute successfully, commit the changes. Otherwise, roll back the changes.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningMicrosoft Visual C#Computer ScienceISBN:9781337102100Author:Joyce, Farrell.Publisher:Cengage Learning,EBK JAVA PROGRAMMINGComputer ScienceISBN:9781337671385Author:FARRELLPublisher:CENGAGE LEARNING - CONSIGNMENT
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Microsoft Visual C#
Computer Science
ISBN:9781337102100
Author:Joyce, Farrell.
Publisher:Cengage Learning,
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT