Is it done by web service? how?

Question

1.00/5 (1 vote)

See more:

i have two table Applicationtable and Officertable. I want to put officerid of Officer table to Applicationtable designationid field.But the condition is that value from one table to another will fill ,if remark column of Applicationtable is not fill within 7 days which is initially null .Is it done by web service? how?

Posted 22-Mar-13 1:41am

satpal 2

Updated 22-Mar-13 1:42am

ZurdoDev

v2

Add a Solution

Comments

joshrduncan2012 22-Mar-13 9:14am

Can you please show us your code as to what you are referring to?

Prasad Khandekar 22-Mar-13 11:31am

Hello Satpal,

In my opnion it's done via a scheduled task. Because from your description it appears that you want to update the id in application table if remark column is not filled from last 7 days. So if you run scheduled task every morning then you will fetch all those records from application tabale for which remark column is null and today - creation date is greater than 7. Hope this helps. You can use a web service which will have code to do this update and it may get invoked via a scheduled task (Windows Task Schedular).

satpal 2 23-Mar-13 2:51am

Good morning prasad.can you give me any egxample for that.

Prasad Khandekar 23-Mar-13 3:06am

Yes sure satpal. WIll post it right here

satpal 2 23-Mar-13 4:07am

have u done any post regarding my requet Prasad?

satpal 2 23-Mar-13 4:29am

Prasad thanks for your opinion. but tell me that how scheduled task run automatically? I want running it automatically.

Prasad Khandekar 23-Mar-13 4:45am

If you look at windows task scheduler you can specify from when this task should start running and at what time of the day and till what date. There are many options. Once configured the Task Scheduler will automatically run it at specified date/time.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)