Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Questions on database Sync

Posted on 2004-09-29
8
Medium Priority
?
232 Views
Last Modified: 2010-04-23
I have a questions reguarding upddating a local database from a server drive.  I have created an offline / online application.  When the app starts it verifies if it can get to the server, yes - online, no- offline,  I copy of a 485mb database is loaded from cd at start.  What are my options to update the local database when the user knows they are online, and send only changes.

Thanks,

MJ
0
Comment
Question by:malanois
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 

Expert Comment

by:DimYanChatelAsDataSet
ID: 12179425
you want to update records or the whole database?
0
 

Author Comment

by:malanois
ID: 12179481
Update the records.
0
 

Expert Comment

by:DimYanChatelAsDataSet
ID: 12179540
ok, then wich sql tool are you using? sql server? access? oracle?

if you use oracle or sql server or any sql tool that can use stored procedure,  you can just create a stored procedure that takes parameters representing all field you want to update.

you can also use directly the update statements from your program to the server.

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:DimYanChatelAsDataSet
ID: 12179547
oh and the stored procedure has to old the update statement to ;-)
0
 

Author Comment

by:malanois
ID: 12179819
The databse is access.
0
 

Accepted Solution

by:
DimYanChatelAsDataSet earned 1000 total points
ID: 12179947
ok, then just  use the UPDATE statements trought your program, you know how to send sql trough vb?

the way of sending UPDATE is just as a regular SELECT statement.
0
 

Author Comment

by:malanois
ID: 12180732
Ok,

Is ther anyway to show how many rows were updated.

0
 

Expert Comment

by:DimYanChatelAsDataSet
ID: 12181791
actually, you can only update one row at a time but maybe my knowledge is not that advanced.

is this solution ok for you?
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question