使用vb6.0编码的批量更新记录 [英] Bulk Update Records using vb6.0 coding

问题描述

嗨
1]我正在使用vb6.0和ms-access 2003数据库进行一个项目.我有
一个表名[segment transaction]，它有1000多个记录
我想更新此表中的一两个列的批量记录.单条记录更新没问题，但是多条记录更新对我来说很复杂.请帮助我
我会期待您的好解决方案.

例如:

段名段引号sorno status
------------- ----- --------- ----- ------
AAAA 1 2349879
BBBB 19 3564788
CCCC 34 3243424
............
.......
我想基于Excel工作表中的"QUOTATION"更新[sorno和status]列中的1000多个记录.

2]我上面提到的项目正在运行网络(多用户环境)，有些
图像文件存储在服务器中.我通过vb6.0编码打印此图像.但是此图像文件未保存在我的本地计算机中吗?
请帮助我


谢谢

sathik
[e-mail]

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
[e-mail]

推荐答案

到目前为止，有关记录的批量更新只是对查询没有任何限制，即

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

这将更新所有记录的Col1和Col2列.

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

1)更新查询

1)the update query

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

Mr .Rod Kamp(Answer1)错过了where子句

2)使用通用对话框控件进行图像保存操作.然后，如果您提到有关图像保存操作的错误详细信息，那我就只能猜测无法解决，那就没问题了.

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.

这篇关于使用vb6.0编码的批量更新记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！