Bulk Update Records using vb6.0 coding

Question

0.00/5 (No votes)

See more:

Hi
1] i am doing one project using vb6.0 with ms-access 2003 database. i have
one table name [segment transaction] , its have more than 1000 records
i want update one or two column's bulk records in this table. single record update its ok no problem but multiple records update is complicated to me. please help me
i will expect your good solution.

For example:

Segment name segid quotation sorno status
------------- ----- --------- ----- ------
AAAA 1 2349879
BBBB 19 3564788
CCCC 34 3243424
............
.......
i want update more than 1000 records in [sorno and status ] columns based on "QUOTATION" from excel sheet.

2] my above mentioned project running network(multiuser environment), some
image file stored in server. i print this image through vb6.0 coding. but this image file is not save in my local machine, is it possible?
please help me

Thank you

sathik
srbatcha@yahoo.co.in

Posted 16-Jan-10 21:57pm

srbatcha

Updated 17-Jan-10 0:58am

v3

Add a Solution

2 solutions

Add a Solution

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)

Rod Kemp · Answer 1 · 2010-01-16T23:08:00

Solution 1

As far a bulk update of records is concerned just don't put any restrictions on the query i.e.

UPDATE [segment transaction] SET Col1=val1 AND Col2=val2

This would update the Col1 and Col2 columns for ALL records.

Posted 16-Jan-10 23:08pm

Rod Kemp

thatraja · Answer 2 · 2010-01-17T09:10:00

1)the update query

SQL

UPDATE [segment transaction] SET sorno=val1 AND status=val2 WHERE quotation = val3

Mr.Rod Kamp(Answer1) missed the where clause

2) Use common dialog control for image save operation. Then it will be fine if you mention the ERROR details about the image save operation, with out that i can only guess not solve.