自动化数据输入 [英] automating data entry

问题描述

我知道存储过程，他们可以通过

SQL''insert''语句加速数据输入。


但是，这种方法的一个缺点是使用存储过程

仍然需要一个手动和单独输入每个记录

要插入在程序执行之前到数据库。


我想通过找到一种方法来使用VB

应用程序来提示用户要输入每个记录的数据

然后将它存储到表中。


这似乎更容易（有更简单的方法吗？）而不是创建一个文本文件

然后执行它。


想要的意见或评论，谢谢。

解决方案

Jerry -

mySql没有存储过程 - 所以你要做什么？


我在MS上使用了存储过程-SQL和Oracle在过去的5年中相当多 -

年 - 我认为我在插入记录方面的技巧与

你的技术略有不同。


我倾向于回避VB，因为它实际上不是用于操作数据的好语言。我是Visual FoxPro的忠实粉丝，并且每天都使用它来支付
mySql - 我已经用这两个小东西写了大约18个应用程序。

通常我的应用程序利用mySql odbc驱动程序，远程视图在
VFP中返回mySql表，sql通过编码技术和一个好的

错误处理程序进行数据插入。我从来没有听说过在mySql中使用

存储过程。我已经在VFP中编写了元存储过程，对于mySql表执行了
- 但它更多的是在vfp端进行评估的美化/存储的

sql代码集合然后在mySql端执行

.


如果你想用VB来操作mySql中的数据 - 这里有一些
$ b ADO / VB与SPT / VFP的$ b指标。


操作LOC / VB LOC / VFP

建立连接12 2

插入一条记录12 2

检索记录集18 2

删除记录12 2

让我知道你的想法？ mondo问候[比尔]

-

William Sanders /电子申请小组删除DOT BOB通过

电子邮件回复。

免费长距离 - > mailto：ex ******** @ efgroup.net

mySql / VFP / MS-SQL

" Jerry Weinstein" < JE ************* @ earthlink.net>在消息中写道

新闻：5W *************** @ newsread4.news.pas.earthlin k.net ...

我知道存储过程，并且他们可以通过$'$ b b'SQL''insert''声明来加速数据输入。

然而，这种方法的一个缺点是使用存储过程
仍需要手动和单独输入每个
记录，以便在执行程序之前插入数据库。

我想绕过这个通过找到一种方法来使用也可能是一个VB
应用程序，提示用户将数据输入每个
记录，然后将其存储到表中。

这似乎更容易（有更简单的方式吗？）而不是创建文本文件然后执行它。

想要的想法或评论，谢谢。

Jerry -

mySql没有存储过程 - 所以你要做什么？


在过去的5年中，我在MS-SQL和Oracle上使用了很多存储过程 - 我认为我插入记录的技术与
你的。


我倾向于回避VB，因为它实际上不是用于操作数据的好的语言。我是Visual FoxPro的忠实粉丝，并且每天都使用它来支付
mySql - 我已经用这两个小东西写了大约18个应用程序。

通常我的应用程序利用mySql odbc驱动程序，远程视图在
VFP中返回mySql表，sql通过编码技术和一个好的

错误处理程序进行数据插入。我从来没有听说过在mySql中使用

存储过程。我已经在VFP中编写了元存储过程，对于mySql表执行了
- 但它更多的是在vfp端进行评估的美化/存储的

sql代码集合然后在mySql端执行

.


如果你想用VB来操作mySql中的数据 - 这里有一些
$ b ADO / VB与SPT / VFP的$ b指标。


操作LOC / VB LOC / VFP

建立连接12 2

插入一条记录12 2

检索记录集18 2

删除记录12 2

让我知道你的想法？ mondo问候[比尔]

-

William Sanders /电子申请小组删除DOT BOB通过

电子邮件回复。

免费长距离 - > mailto：ex ******** @ efgroup.net

mySql / VFP / MS-SQL

" Jerry Weinstein" < JE ************* @ earthlink.net>在消息中写道

新闻：5W *************** @ newsread4.news.pas.earthlin k.net ...

我知道存储过程，并且他们可以通过$'$ b b'SQL''insert''声明来加速数据输入。

然而，这种方法的一个缺点是使用存储过程
仍需要手动和单独输入每个
记录，以便在执行程序之前插入数据库。

我想绕过这个通过找到一种方法来使用也可能是一个VB
应用程序，提示用户将数据输入每个
记录，然后将其存储到表中。

这似乎更容易（有更简单的方式吗？）而不是创建文本文件然后执行它。

想要的想法或评论，谢谢。

Jerry -

mySql没有存储过程 - 所以你要做什么？


在过去的5年中，我在MS-SQL和Oracle上使用了很多存储过程 - 我认为我插入记录的技术与
你的。


我倾向于回避VB，因为它实际上不是用于操作数据的好的语言。我是Visual FoxPro的忠实粉丝，并且每天都使用它来支付
mySql - 我已经用这两个小东西写了大约18个应用程序。

通常我的应用程序利用mySql odbc驱动程序，远程视图在
VFP中返回mySql表，sql通过编码技术和一个好的

错误处理程序进行数据插入。我从来没有听说过在mySql中使用

存储过程。我已经在VFP中编写了元存储过程，对于mySql表执行了
- 但它更多的是在vfp端进行评估的美化/存储的

sql代码集合然后在mySql端执行

.


如果你想用VB来操作mySql中的数据 - 这里有一些
$ b ADO / VB与SPT / VFP的$ b指标。


操作LOC / VB LOC / VFP

建立连接12 2

插入一条记录12 2

检索记录集18 2

删除记录12 2

让我知道你的想法？ mondo问候[比尔]

-

William Sanders /电子申请小组删除DOT BOB通过

电子邮件回复。

免费长距离 - > mailto：ex ******** @ efgroup.net

mySql / VFP / MS-SQL

" Jerry Weinstein" < JE ************* @ earthlink.net>在消息中写道

新闻：5W *************** @ newsread4.news.pas.earthlin k.net ...

我知道存储过程，并且他们可以通过$'$ b b'SQL''insert''声明来加速数据输入。

然而，这种方法的一个缺点是使用存储过程
仍需要手动和单独输入每个
记录，以便在执行程序之前插入数据库。

我想绕过这个通过找到一种方法来使用也可能是一个VB
应用程序，提示用户将数据输入每个
记录，然后将其存储到表中。

这似乎更容易（有更简单的方式吗？）而不是创建文本文件然后执行它。

想要的想法或评论，谢谢。

Hi,
I know about stored procedures and that they can speed up data entry via the
SQL ''insert '' statement.

However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every record
to be inserted to the database before the procedure is executed.

I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be entered into each record
and then stores it to the table.

This seems easier (is there an even EASIER way?) than creating a text file
and then executing it.

Thoughts or comments desired, thanks.

解决方案

Jerry -
mySql does not have stored procedures - so what are you going on about?

I have used stored procedures on MS-SQL and Oracle quite a lot in the past 5
years - I think my techniques on inserting records are a bit different than
yours.

I tend to shy away from VB, as it really is not a good language for the
manipulation of data. I am a big fan of Visual FoxPro and use it daily with
mySql - I''ve written about 18 applications now with these two beasties.
Typically my apps take advantage of the mySql odbc driver, remote views in
VFP back to mySql tables, sql pass through coding techniques and a good
error handler for the data inserts. I''ve never ever heard of utilizing
stored procedures in mySql. I have written meta stored procs in VFP that
execute against a mySql table - but its more of a glorified/stored
collection of sql code that gets evaluated on the vfp side, then executed on
the mySql side .

If you are thinking of using VB to manipulate data in mySql - here are some
metrics for ADO/VB vs SPT/VFP.

operation LOC/VB LOC/VFP
establish connection 12 2
insert a record 12 2
retrieve a record set 18 2
delete a record 12 2
let me know your thoughts? mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Jerry Weinstein" <je*************@earthlink.net> wrote in message
news:5W***************@newsread4.news.pas.earthlin k.net...

Hi,
I know about stored procedures and that they can speed up data entry via the SQL ''insert '' statement.

However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every record to be inserted to the database before the procedure is executed.

I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be entered into each record and then stores it to the table.

This seems easier (is there an even EASIER way?) than creating a text file
and then executing it.

Thoughts or comments desired, thanks.

Jerry -
mySql does not have stored procedures - so what are you going on about?

I have used stored procedures on MS-SQL and Oracle quite a lot in the past 5
years - I think my techniques on inserting records are a bit different than
yours.

I tend to shy away from VB, as it really is not a good language for the
manipulation of data. I am a big fan of Visual FoxPro and use it daily with
mySql - I''ve written about 18 applications now with these two beasties.
Typically my apps take advantage of the mySql odbc driver, remote views in
VFP back to mySql tables, sql pass through coding techniques and a good
error handler for the data inserts. I''ve never ever heard of utilizing
stored procedures in mySql. I have written meta stored procs in VFP that
execute against a mySql table - but its more of a glorified/stored
collection of sql code that gets evaluated on the vfp side, then executed on
the mySql side .

If you are thinking of using VB to manipulate data in mySql - here are some
metrics for ADO/VB vs SPT/VFP.

operation LOC/VB LOC/VFP
establish connection 12 2
insert a record 12 2
retrieve a record set 18 2
delete a record 12 2
let me know your thoughts? mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Jerry Weinstein" <je*************@earthlink.net> wrote in message
news:5W***************@newsread4.news.pas.earthlin k.net...

Hi,
I know about stored procedures and that they can speed up data entry via the SQL ''insert '' statement.

However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every record to be inserted to the database before the procedure is executed.

I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be entered into each record and then stores it to the table.

This seems easier (is there an even EASIER way?) than creating a text file
and then executing it.

Thoughts or comments desired, thanks.

Jerry -
mySql does not have stored procedures - so what are you going on about?

I have used stored procedures on MS-SQL and Oracle quite a lot in the past 5
years - I think my techniques on inserting records are a bit different than
yours.

I tend to shy away from VB, as it really is not a good language for the
manipulation of data. I am a big fan of Visual FoxPro and use it daily with
mySql - I''ve written about 18 applications now with these two beasties.
Typically my apps take advantage of the mySql odbc driver, remote views in
VFP back to mySql tables, sql pass through coding techniques and a good
error handler for the data inserts. I''ve never ever heard of utilizing
stored procedures in mySql. I have written meta stored procs in VFP that
execute against a mySql table - but its more of a glorified/stored
collection of sql code that gets evaluated on the vfp side, then executed on
the mySql side .

If you are thinking of using VB to manipulate data in mySql - here are some
metrics for ADO/VB vs SPT/VFP.

operation LOC/VB LOC/VFP
establish connection 12 2
insert a record 12 2
retrieve a record set 18 2
delete a record 12 2
let me know your thoughts? mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Jerry Weinstein" <je*************@earthlink.net> wrote in message
news:5W***************@newsread4.news.pas.earthlin k.net...

Hi,
I know about stored procedures and that they can speed up data entry via the SQL ''insert '' statement.

However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every record to be inserted to the database before the procedure is executed.

I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be entered into each record and then stores it to the table.

This seems easier (is there an even EASIER way?) than creating a text file
and then executing it.

Thoughts or comments desired, thanks.

这篇关于自动化数据输入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！