473,714 Members | 2,580 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

automating data entry

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.
Jul 19 '05 #1
12 3226
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******** *******@newsrea d4.news.pas.ear thlink.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.

Jul 19 '05 #2
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******** *******@newsrea d4.news.pas.ear thlink.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.

Jul 19 '05 #3
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******** *******@newsrea d4.news.pas.ear thlink.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.

Jul 19 '05 #4
Bob,
I DID say EASIER!
Thanks, and I'll check on the distro CD for QT and VFP 6.

Jerry

"swdev1" <ws**********@a dvmed.com> wrote in message
news:1q******** ********@newssv r24.news.prodig y.com...
Jerry - ah - you are really NOT doing anything with odbc and VB, then ?
its not a BAD choice, if its available to you ... Just really not my
personal preference.
Java and mysql is doable - but oh so tedious.

Have you looked into QT ?? its on the linux distro CD's ...
r u sure you don't have VFP? You got Visual Studio 6 Enterprise Edition
floating around anywhere?
VFP 6 is on CD #1.

as to java and mysql - there should be a jdbc driver for mysql somewhere
[works similar to the odbc driver, but is NOT odbc]. Developing
data-centric apps with JAVA, again IMO, is tedious process - lots o coding.
hoping this finds you well, and well rested.
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:c9******** ******@newsread 4.news.pas.eart hlink.net...
Hi Bob,

My setup is MySQL server on Linux Mandrake 9.1
My database files are of course also residing on Linux machine.
So far, from local and remote Windows PC's I am using putty + ssh and also
MySQLControlCen ter which is nice, however not in the
way I want to develop this scenario.
I don't own a copy of VFP so it would be an investment for me to go that
route.
Just last night I found a way to insert multiple repeat record entries using
MYSql with the 'insert...selec t' syntax.
It WILL do what I need, however, I still envision only embedding it into
say, Java.
How does that sound.

Also, under my current scenario (Java + embedded MySQL) do you know if

Linux
has ODBC or do I even need to
use it?

That's about it for now.

Appreciate your expertise, thanks.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:8M******** *************@n ewssvr12.news.p rodigy.com...
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******** *******@newsrea d4.news.pas.ear thlink.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.
>
>



Jul 19 '05 #5
Bob,
I DID say EASIER!
Thanks, and I'll check on the distro CD for QT and VFP 6.

Jerry

"swdev1" <ws**********@a dvmed.com> wrote in message
news:1q******** ********@newssv r24.news.prodig y.com...
Jerry - ah - you are really NOT doing anything with odbc and VB, then ?
its not a BAD choice, if its available to you ... Just really not my
personal preference.
Java and mysql is doable - but oh so tedious.

Have you looked into QT ?? its on the linux distro CD's ...
r u sure you don't have VFP? You got Visual Studio 6 Enterprise Edition
floating around anywhere?
VFP 6 is on CD #1.

as to java and mysql - there should be a jdbc driver for mysql somewhere
[works similar to the odbc driver, but is NOT odbc]. Developing
data-centric apps with JAVA, again IMO, is tedious process - lots o coding.
hoping this finds you well, and well rested.
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:c9******** ******@newsread 4.news.pas.eart hlink.net...
Hi Bob,

My setup is MySQL server on Linux Mandrake 9.1
My database files are of course also residing on Linux machine.
So far, from local and remote Windows PC's I am using putty + ssh and also
MySQLControlCen ter which is nice, however not in the
way I want to develop this scenario.
I don't own a copy of VFP so it would be an investment for me to go that
route.
Just last night I found a way to insert multiple repeat record entries using
MYSql with the 'insert...selec t' syntax.
It WILL do what I need, however, I still envision only embedding it into
say, Java.
How does that sound.

Also, under my current scenario (Java + embedded MySQL) do you know if

Linux
has ODBC or do I even need to
use it?

That's about it for now.

Appreciate your expertise, thanks.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:8M******** *************@n ewssvr12.news.p rodigy.com...
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******** *******@newsrea d4.news.pas.ear thlink.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.
>
>



Jul 19 '05 #6
Bob,
I DID say EASIER!
Thanks, and I'll check on the distro CD for QT and VFP 6.

Jerry

"swdev1" <ws**********@a dvmed.com> wrote in message
news:1q******** ********@newssv r24.news.prodig y.com...
Jerry - ah - you are really NOT doing anything with odbc and VB, then ?
its not a BAD choice, if its available to you ... Just really not my
personal preference.
Java and mysql is doable - but oh so tedious.

Have you looked into QT ?? its on the linux distro CD's ...
r u sure you don't have VFP? You got Visual Studio 6 Enterprise Edition
floating around anywhere?
VFP 6 is on CD #1.

as to java and mysql - there should be a jdbc driver for mysql somewhere
[works similar to the odbc driver, but is NOT odbc]. Developing
data-centric apps with JAVA, again IMO, is tedious process - lots o coding.
hoping this finds you well, and well rested.
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:c9******** ******@newsread 4.news.pas.eart hlink.net...
Hi Bob,

My setup is MySQL server on Linux Mandrake 9.1
My database files are of course also residing on Linux machine.
So far, from local and remote Windows PC's I am using putty + ssh and also
MySQLControlCen ter which is nice, however not in the
way I want to develop this scenario.
I don't own a copy of VFP so it would be an investment for me to go that
route.
Just last night I found a way to insert multiple repeat record entries using
MYSql with the 'insert...selec t' syntax.
It WILL do what I need, however, I still envision only embedding it into
say, Java.
How does that sound.

Also, under my current scenario (Java + embedded MySQL) do you know if

Linux
has ODBC or do I even need to
use it?

That's about it for now.

Appreciate your expertise, thanks.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:8M******** *************@n ewssvr12.news.p rodigy.com...
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******** *******@newsrea d4.news.pas.ear thlink.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.
>
>



Jul 19 '05 #7
I have another question if you don't mind.

That is, can MS Access open and manipulate MySQL data either locally or from
the Internet?

Is there a way to do this with some kind of plug in?

There are two different filetypes aren't they (.mdb and .sql?)
It doesn't seem possible to me.

The reason I ask is that I am using SSH to connect to a MySQL database on a
Linux server with putty and MySQLCC
and they both work fine.

I'd like to use Access from any PC over the Internet to manipulate the MySQL
database but it would have to be SSH
capable as my server's SSH port is open and it would be the only way in to
access it from the Internet.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:1q******** ********@newssv r24.news.prodig y.com...
Jerry - ah - you are really NOT doing anything with odbc and VB, then ?
its not a BAD choice, if its available to you ... Just really not my
personal preference.
Java and mysql is doable - but oh so tedious.

Have you looked into QT ?? its on the linux distro CD's ...
r u sure you don't have VFP? You got Visual Studio 6 Enterprise Edition
floating around anywhere?
VFP 6 is on CD #1.

as to java and mysql - there should be a jdbc driver for mysql somewhere
[works similar to the odbc driver, but is NOT odbc]. Developing
data-centric apps with JAVA, again IMO, is tedious process - lots o coding.
hoping this finds you well, and well rested.
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:c9******** ******@newsread 4.news.pas.eart hlink.net...
Hi Bob,

My setup is MySQL server on Linux Mandrake 9.1
My database files are of course also residing on Linux machine.
So far, from local and remote Windows PC's I am using putty + ssh and also
MySQLControlCen ter which is nice, however not in the
way I want to develop this scenario.
I don't own a copy of VFP so it would be an investment for me to go that
route.
Just last night I found a way to insert multiple repeat record entries using
MYSql with the 'insert...selec t' syntax.
It WILL do what I need, however, I still envision only embedding it into
say, Java.
How does that sound.

Also, under my current scenario (Java + embedded MySQL) do you know if

Linux
has ODBC or do I even need to
use it?

That's about it for now.

Appreciate your expertise, thanks.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:8M******** *************@n ewssvr12.news.p rodigy.com...
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******** *******@newsrea d4.news.pas.ear thlink.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.
>
>



Jul 19 '05 #8
I have another question if you don't mind.

That is, can MS Access open and manipulate MySQL data either locally or from
the Internet?

Is there a way to do this with some kind of plug in?

There are two different filetypes aren't they (.mdb and .sql?)
It doesn't seem possible to me.

The reason I ask is that I am using SSH to connect to a MySQL database on a
Linux server with putty and MySQLCC
and they both work fine.

I'd like to use Access from any PC over the Internet to manipulate the MySQL
database but it would have to be SSH
capable as my server's SSH port is open and it would be the only way in to
access it from the Internet.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:1q******** ********@newssv r24.news.prodig y.com...
Jerry - ah - you are really NOT doing anything with odbc and VB, then ?
its not a BAD choice, if its available to you ... Just really not my
personal preference.
Java and mysql is doable - but oh so tedious.

Have you looked into QT ?? its on the linux distro CD's ...
r u sure you don't have VFP? You got Visual Studio 6 Enterprise Edition
floating around anywhere?
VFP 6 is on CD #1.

as to java and mysql - there should be a jdbc driver for mysql somewhere
[works similar to the odbc driver, but is NOT odbc]. Developing
data-centric apps with JAVA, again IMO, is tedious process - lots o coding.
hoping this finds you well, and well rested.
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:c9******** ******@newsread 4.news.pas.eart hlink.net...
Hi Bob,

My setup is MySQL server on Linux Mandrake 9.1
My database files are of course also residing on Linux machine.
So far, from local and remote Windows PC's I am using putty + ssh and also
MySQLControlCen ter which is nice, however not in the
way I want to develop this scenario.
I don't own a copy of VFP so it would be an investment for me to go that
route.
Just last night I found a way to insert multiple repeat record entries using
MYSql with the 'insert...selec t' syntax.
It WILL do what I need, however, I still envision only embedding it into
say, Java.
How does that sound.

Also, under my current scenario (Java + embedded MySQL) do you know if

Linux
has ODBC or do I even need to
use it?

That's about it for now.

Appreciate your expertise, thanks.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:8M******** *************@n ewssvr12.news.p rodigy.com...
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******** *******@newsrea d4.news.pas.ear thlink.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.
>
>



Jul 19 '05 #9
I have another question if you don't mind.

That is, can MS Access open and manipulate MySQL data either locally or from
the Internet?

Is there a way to do this with some kind of plug in?

There are two different filetypes aren't they (.mdb and .sql?)
It doesn't seem possible to me.

The reason I ask is that I am using SSH to connect to a MySQL database on a
Linux server with putty and MySQLCC
and they both work fine.

I'd like to use Access from any PC over the Internet to manipulate the MySQL
database but it would have to be SSH
capable as my server's SSH port is open and it would be the only way in to
access it from the Internet.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:1q******** ********@newssv r24.news.prodig y.com...
Jerry - ah - you are really NOT doing anything with odbc and VB, then ?
its not a BAD choice, if its available to you ... Just really not my
personal preference.
Java and mysql is doable - but oh so tedious.

Have you looked into QT ?? its on the linux distro CD's ...
r u sure you don't have VFP? You got Visual Studio 6 Enterprise Edition
floating around anywhere?
VFP 6 is on CD #1.

as to java and mysql - there should be a jdbc driver for mysql somewhere
[works similar to the odbc driver, but is NOT odbc]. Developing
data-centric apps with JAVA, again IMO, is tedious process - lots o coding.
hoping this finds you well, and well rested.
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:c9******** ******@newsread 4.news.pas.eart hlink.net...
Hi Bob,

My setup is MySQL server on Linux Mandrake 9.1
My database files are of course also residing on Linux machine.
So far, from local and remote Windows PC's I am using putty + ssh and also
MySQLControlCen ter which is nice, however not in the
way I want to develop this scenario.
I don't own a copy of VFP so it would be an investment for me to go that
route.
Just last night I found a way to insert multiple repeat record entries using
MYSql with the 'insert...selec t' syntax.
It WILL do what I need, however, I still envision only embedding it into
say, Java.
How does that sound.

Also, under my current scenario (Java + embedded MySQL) do you know if

Linux
has ODBC or do I even need to
use it?

That's about it for now.

Appreciate your expertise, thanks.
"swdev1" <ws**********@a dvmed.com> wrote in message
news:8M******** *************@n ewssvr12.news.p rodigy.com...
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******** *******@newsrea d4.news.pas.ear thlink.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.
>
>



Jul 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
428
by: Jerry Weinstein | last post by:
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...
6
4340
by: Charles Banas | last post by:
weird subject - i hope more than just one curious regular will hear me out. :) ok, i've got a bit of a big problem, and i need answers as soon as possible. i know this forum is meant for web developers, but is relevant discussion. i'm not OT here unless someone thinks i'm trolling (which i'm not, obviously). then i'll disappear and never show my face again. :P
7
2627
by: xzzy | last post by:
I need to automate a report in a different database (and thank yous to Terry Kreft for pointing me in the right direction). below is the code with the one line that does not work, marked: 'Does not Work' It appears that the type of object returned from the "AllReports" collection is not a report object. =>> I need it to be an object of type report.
4
3229
by: Supa Hoopsa | last post by:
I am in the process of rewriting an MS Access application (access front end with SQL 2k database) in VB.NET and one of the things I would like to do is link in to the compiled Access ADE so that I can use the reports that have already been created. I have somewhere in the region of 200 reports already created in MS Access and I really don't want to have to create new ones. I have successfully linked to the Access ADP, but would really like to...
3
1639
by: Jerome Ranch | last post by:
I collect information from people via an xls file...columns are fixed (name and number), rows are variable. It has validation rules for data entry in some fields. Currenty I just import the xls into access, and then append the records from the imported table into the main table. I'd like to "automate" this process..I'd appeciate your brainstorming sugestions. One route I was just thinking of this AM is to have the data entry
4
3197
by: attachmatey | last post by:
Greetings: I'm looking for some help in automating (what I thought would be) a simple procedure in Internet Explorer. I'm trying to put the following operation under a button click in an MS Access database form: 1. Navigate to URL and click button 2. Enter user name and password 3. Apply filters (enter criteria in text boxes) 4. Execute query (another button click) 5. Export results to network server 6. Data mining using Monarch...
1
1801
by: admin.offshoredataentry | last post by:
Data Entry Outsourcing provides time bound, cost effective and qualitative Data Entry also provides numeric data entry, textual data entry, image data entry, data format, data conversion and also online data entry, offline data entry with 99.98% accuracy and time bound. Data Entry Services also provides form data entry, data capture, HTML/ SGML coding, image scanning, file conversion with low cost,high quality, 99.98% accuracy and...
1
2186
by: Data Entry Outsourcing | last post by:
Data Entry plays vital role in every business area. Data Entry is one such aspects of any business that needs to be handled properly for expanding your business. Data Entry is one of the leading elements for running a business successfully. Now Days it's a trend to outsource Data Entry Work to reliable service provider who provides excellent output out of their work. Many Companies or Organization prefer to outsource data entry work to...
1
1125
by: smp331 | last post by:
Hello, I am somewhat new to Access and am having difficulty figuring out how to change a previous entry automatically when a new entry is created. My form contains tool#, datecalibrated, duedate, and complete fields. The way it is set up currently is I can query (monthly) the tool and due date in mm/yyyy format. My problem is trying to display past due or "incomplete" calibrations as well as the current ones. So if a tool is due...
0
8704
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9309
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9071
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7946
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6629
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5945
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4462
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4717
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3156
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.