Sql vb integration, computer programming, Programming Languages

Sql vb integration, computer programming, Programming Languages

Assignment Help:

I need an application that will gather data from one SQL Database and update another.
Data is contained in dbo.CallList with following fields: Customer_ID, AlreadyPickedUp, Phone_Number.
dbo.CallResults contains the following fields: Customer_ID, NumberOfCalls, Call_Successful.

I need a function that will gather data from dbo.CallList. Filters to see if AlreadyPickedUp is = 1, if so, update dbo.CallResults as Successful (matching the Customer_ID)

ElseIf AlreadyPickedUp is 0, then While dbo.CallList is not EOF, make a call (I will get this function done) and update dbo.CallResults with the appropriate amount of attempts. Should go through all of the items in the dbo.CallList table before making the second attempt. If the previous phone call attempt was to the same phone number then skip.

Let me know if you have any questions.

Related Discussions:- Sql vb integration, computer programming

Design and implement instantiable classes, Overview Goals: The goals for...

Overview Goals: The goals for this assignment are Design and implement instantiable classes. Use arrays of objects. Read from and write to files. Implement basic

Describe the term inter-process communication, UNIX Operating System 1....

UNIX Operating System 1. Explain all the layers present in a UNIX Architecture? List and explain each of them. 2. Describe the term Inter-Process Communication. What are var

Implement a lunar lander simulation, 1. Modify your solution to #8 so that ...

1. Modify your solution to #8 so that if an ellipse is touched by the mouse, it turns permanently green.Bonus (up to +5): a green ellipse stops moving, but recovers after 5 seconds

NETLOGO , THERE IS ANY1 COULD HELP ME WITH NETLOGO WORK

THERE IS ANY1 COULD HELP ME WITH NETLOGO WORK

Assembly language program, a program that enter an alphabet from the user a...

a program that enter an alphabet from the user and compare it is vowel or not?

Program for connect 4 game on a general board, The classical connect-4 game...

The classical connect-4 game is played on a 67 board, it can in fact be played in any nrRowsnrCols board. In your implementation, the user will specify the number of rows nrRows an

Shell script for combinations ncr, Normal 0 false false fal...

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Django template, i''ve a problem with rendering a page with django template...

i''ve a problem with rendering a page with django templates

Characteristics, object oriented programming

object oriented programming

What are relative urls, What are Relative URLS ? When a web browser re...

What are Relative URLS ? When a web browser reads an HTML document, it has a great deal of information about the document. This includes the protocol used to retrieve the docu

Write Your Message!

Name

Email id

Message

Verfication Code

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd