A GUIDE TO SQL
A GUIDE TO SQL
9th Edition
ISBN: 9781305897397
Author: Pratt
Publisher: CENGAGE L
Expert Solution & Answer
Book Icon
Chapter 8, Problem 6CAT

Explanation of Solution

a.

Deleting query in the table “GUIDE”:

Public Function GuideDelete(I_GUIDE_NUM)

    Dim strSQL As String

    strSQL = "DELETE FROM GUIDE WHERE GUIDE_NUM = '"

    strSQL = strSQL & I_GUIDE_NUM

    strSQL = strSQL & "'"

    DoCmd.RunSQL strSQL

 End Function

 Explanation:

  • Create a function named as “GuideDelete” and pass an argument “I_GUIDE_NUM”.
  • Set the “strSQL” string variable to “DELETE FROM GUIDE WHERE GUIDE_NUM = '” and makes everything necessary in the command up to and including the single quotation mark preceding the order number.
  • The next command will concatenated previous value with the value in “I_GUIDE_NUM”.
  • The final command is used to set “strSQL” to the output of the value already created, concatenated with a single quotation mark...

Explanation of Solution

b.

Updating query:

Public Function GuideUpdate(I_GUIDE_NUM, I_LAST_NAME)

    Dim strSQL As String

    strSQL = "UPDATE GUIDE SET LAST_NAME = '"

    strSQL = strSQL + I_LAST_NAME

    strSQL = strSQL + "' WHERE GUIDE_NUM = '"

    strSQL = strSQL & I_GUIDE_NUM

    strSQL = strSQL & "'"

    DoCmd.RunSQL strSQL

End Function

 Explanation:

  • Create a function named as “GuideUpdate” and pass the arguments “I_GUIDE_NUM” and “I_ LAST_NAME”.
  • Set the “strSQL” string variable to “UPDATE GUIDE SET LAST_NAME = '” and makes everything necessary in the command up to and including the single quotation mark preceding the order number.
  • Here, the user pass two arguments, so there are two portions of the construction of the SQL command that involve variables...

Explanation of Solution

c.

Retrieving the list in the table “RESERVATION”:

Public Function FindReservations(I_CUSTOMER_NUM)

    Dim rs As New ADODB.Recordset

    Dim cnn As ADODB.Connection

    Dim strSQL As String

    Set cnn = CurrentProject.Connection

    strSQL = "SELECT RESERVATION_ID, TRIP_ID, NUM_PERSONS, TRIP_PRICE FROM RESERVATION WHERE CUSTOMER_NUM = '"

    strSQL = strSQL & I_CUSTOMER_NUM

    strSQL = strSQL & "'"

    rs.Open strSQL, cnn, adOpenStatic, , adCmdText

    Do Until rs.EOF

        Debug.Print (rs!RESERVATION_ID)

        Debug.Print (rs!TRIP_ID)

        Debug.Print (rs!NUM_PERSONS)

        Debug.Print (rs!TRIP_PRICE)

        rs.MoveNext

    Loop

End Function

 Explanation:

  • Create a function named as “Find_Reservations” and pass an argument “I_CUSTOMER_NUM”.
  • The “rs” and “cnn” is used to processing the “Recordset” and “ADODB.Connection”.
  • Set the “strSQL” string variable to “SELECT RESERVATION_ID, TRIP_ID, NUM_PERSONS, TRIP_PRICE FROM RESERVATION WHERE CUSTOMER_NUM = '” and makes everything necessary in the command up to and including the single quotation mark preceding the order number...

Blurred answer
Students have asked these similar questions
Explian thiS C program #include<stdio.h> int countSetBits(int n) {    int count = 0;    while (n) {        count += n & 1;        n >>= 1;    }    return count;} int main() {    int num;    printf("Enter a number: ");    scanf("%d", &num);    printf("Output: %d units\n", countSetBits(num));    return 0;}
Please provide the Mathematica code
Explian this C program code. #include <stdio.h> void binary(unsigned int n) { if (n /2!=0) { binary(n /2); } printf("%d", n %2); } int main() { unsignedint number =33777; unsignedchar character ='X';   printf("Number: %u\n", number); printf("Binary: "); binary(number); printf("\nDecimal: %u\nHexadecimal: 0x%X\n\n", number, number);   printf("Character: %c\n", character); printf("ASCII Binary: "); binary(character); printf("\nASCII Decimal: %u\nASCII Hexadecimal: 0x%X\n", character, character);   return0; }
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning