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

Program character array to a signed floating point number, Write a function...

Write a function that converts a character array to a signed floating point number. Function prototype must be as follows: int asciiToFloat( char *str, unsigned char* eflag) Follow

Prepare notes on the logical storage manager, Question: (i) Prepare bri...

Question: (i) Prepare brief notes on the Logical Storage Manager. (ii) Show benefits that can be achieve by using the LSM Manager. (iii) LSM organizes and optimizes disk

Identify the type of addressing, specify the function of the instruction an...

specify the function of the instruction and also specify whether its right or wrong-: (5) 1) MOV [BX],AX? Register Indirect addressing 2) MOV CX,[BX+DI]?Base plus index add

Create a linux shell, Create a linux shell (in other words, write a C/C++ p...

Create a linux shell (in other words, write a C/C++ program) that will recursively prompt for input from the user. The shell should prompt as yourRollNumber-currentDirector

Pascal, Problem Solving 1. Write Pascal code that accepts as input the nam...

Problem Solving 1. Write Pascal code that accepts as input the names of the students, course work score and exam score for a unspecified number of students who have taken a subjec

Selfcare project - strut frame work, Selfcare Project: Technology U...

Selfcare Project: Technology Used Strut Frame work, WAS 5.1, WPS 6.0, DB2, AJAX, Eclipse, Rational Application Developer 6 and DB2 Selfcare is a big umbrella under whic

Shell script to display system time in words, Normal 0 false ...

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

Find the cookies expiring, Your program can be invoked with option: -d date...

Your program can be invoked with option: -d date, where date is entered in dd/mm/yyyy format. In this case, it must only print the following string: Found cookies expiring bef

Design and create a new class, You are to design and create a new class cal...

You are to design and create a new class called SelectCallDataDialog, which opens by clicking browse buttons for selection of ringtones, vibrations or leds. Depending on which th

Explain the booch methodology, Problem 1 Explain the Booch Methodology ...

Problem 1 Explain the Booch Methodology 2 Why does every interaction diagram need a written description? Explain 3 Explain the five core workflows of the Unified Process

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