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...

Question

1.) Consider the problem of determining whether a DFA and a regular expression are equivalent. Express this problem as a language and show that it is decidable. ii) Let ALLDFA = {(A)| A is a DFA and L(A) = "}. Show that ALLDFA is decidable. iii) Let AECFG = {(G)| G is a CFG that generates &}. Show that AECFG is decidable. iv) Let ETM {(M)| M is a TM and L(M) = 0}. Show that ETM, the complement of Erm, is Turing-recognizable. Let X be the set {1, 2, 3, 4, 5} and Y be the set {6, 7, 8, 9, 10). We describe the functions f: XY and g: XY in the following tables. Answer each part and give a reason for each negative answer. n f(n) n g(n) 1 6 1 10 2 7 2 9 3 6 3 8 4 7 4 7 5 6 5 6 Aa. Is f one-to-one? b. Is fonto? c. Is fa correspondence? Ad. Is g one-to-one? e. Is g onto? f. Is g a correspondence? vi) Let B be the set of all infinite sequences over {0,1}. Show that B is uncountable using a proof by diagonalization.

Answer 1

Expert Solution & Answer

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...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

1.) Consider the problem of determining whether a DFA and a regular expression are equivalent. Express this problem as a language and show that it is decidable. ii) Let ALLDFA = {(A)| A is a DFA and L(A) = "}. Show that ALLDFA is decidable. iii) Let AECFG = {(G)| G is a CFG that generates &}. Show that AECFG is decidable. iv) Let ETM {(M)| M is a TM and L(M) = 0}. Show that ETM, the complement of Erm, is Turing-recognizable. Let X be the set {1, 2, 3, 4, 5} and Y be the set {6, 7, 8, 9, 10). We describe the functions f: XY and g: XY in the following tables. Answer each part and give a reason for each negative answer. n f(n) n g(n) 1 6 1 10 2 7 2 9 3 6 3 8 4 7 4 7 5 6 5 6 Aa. Is f one-to-one? b. Is fonto? c. Is fa correspondence? Ad. Is g one-to-one? e. Is g onto? f. Is g a correspondence? vi) Let B be the set of all infinite sequences over {0,1}. Show that B is uncountable using a proof by diagonalization.

Can you find the least amount of different numbers to pick from positive numbers (integers) that are at most 100 to confirm two numbers that add up to 101 when each number can be picked at most two times?

Can you find the formula for an that satisfies the provided recursive definition? Please show all steps and justification

Answer 2

Expert Solution & Answer

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...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 3

Expert Solution & Answer

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...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 4

Expert Solution & Answer

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...

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

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...

Answer 8

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...

Answer 9

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...

Answer 10

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...

Answer 11

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...

Answer 12

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...

Answer 13

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...

Answer 14

Expert Solution & Answer

Answer 15

Expert Solution & Answer

Answer 16

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 17

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 18

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 19

Trending nowThis is a popular solution!

Answer 20

Trending nowThis is a popular solution!

Answer 21

Trending nowThis is a popular solution!

Answer 22

Trending now

Answer 23

This is a popular solution!

Answer 24

See solution

Check out sample textbook solution

Answer 25

Ch. 8 - Prob. 1RQ Ch. 8 - Prob. 2RQ Ch. 8 - Prob. 3RQ Ch. 8 - Prob. 4RQ Ch. 8 - Prob. 5RQ Ch. 8 - Prob. 6RQ Ch. 8 - Prob. 7RQ Ch. 8 - Prob. 8RQ Ch. 8 - Prob. 9RQ Ch. 8 - In PL/SQL, how do you assign variables the same...

Solution Summary: The author explains how to run a Query to view the contents in the table before updating value.

Explanation of Solution

Explanation of Solution

Explanation of Solution

Chapter 8 Solutions