Write down a function containing sqlite query

Assignment Help Visual Basic Programming

Reference no: EM132922169

MOBILE APPLICATION DEVELOPMENT

Assignment2: SQLite

Q1. Create a table called MyRide with the following Columns:
(you need to declare table and columns before creating table)

- Name of the rider: a varchar field
- Type of vehicle used for ride: a varchar field
- Distance (in minutes) from your house: an integer
- Date of your ride: a varchar field, interpreted as date
- Whether you like it or not: an integer interpreted as boolean

Q2. Write down a function containing SQLite query to fill information in above table.

Q3. Write a function call for the function mentioned in Q2.

Q4. Write a function containing SQLite query to return all the riders in your table.

Q5. Write a function containing SQLite query to return all riders with vehicle type "WagonR"

Q6. Write a function containing SQLite query that returns all riders whose ride you liked, but used the ride 3 weeks ago.

Reference no: EM132922169

Questions Cloud

Identify wells fargo and navy federal credit union : Identify Wells Fargo and navy federal credit union -or business function that interest you enough to possibly pursue more advanced business studies or career op

What are the set membership we can find out : Formulate a set of 5 potential set of questions that come to your mind that are worth adding in this Case Study to be explored.

Fundamentals of occupational safety and health : Most people have experienced a time at work when they were made to feel uncomfortable in some way.

Problem-based learning : What is PBL (problem-based learning)? What is Service Learning?

Write down a function containing sqlite query : Write a function call for the function mentioned in Q2 and Write a function containing SQLite query to return all the riders in your table

Lobbying essay policy essay : Discuss campaign finance reform policies, including the Lobbying Disclosure Act of 1995, the Bipartisan Campaign Reform Act of 2002

Crime prevention programs : Crime prevention programs: What are they? Are they successful? Link one or more criminology theory to the crime prevention proces

Code of ethics : Your analysis of the definitions of ethics and the importance of a project manager adhering to a "code of ethics"

Explain how the basic strategy of control is employed : Explain how the basic strategy of control is employed in a greenhouse system. What is the controlled variable or variables? What is the manipulated variable

User Account

All Pages