469,656 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,656 developers. It's quick & easy.

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 2971
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.

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***************@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.

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***************@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.

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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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
MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
>
>



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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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
MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
>
>



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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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
MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
>
>



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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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
MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
>
>



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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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
MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
>
>



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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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
MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
>
>



Jul 19 '05 #10
Jerry - hmmmm - I do it all the time with odbc drivers for mySql and Visual
FoxPro.
Other developers have done it with Access and odbc, even across the internet
..
You might have some issues with the mysql port at the remote server (port
3306)
but once you overcome that - you can make linked db's and views and sql
queries in access all day long.
To me - SSH is a secure version of Telnet - and they don't use the same
ports as mysql.

Sorry it took so long to get back to you .
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:BZ****************@newsread4.news.pas.earthli nk.net...
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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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 MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
> >
> >
>
>



Jul 19 '05 #11
Jerry - hmmmm - I do it all the time with odbc drivers for mySql and Visual
FoxPro.
Other developers have done it with Access and odbc, even across the internet
..
You might have some issues with the mysql port at the remote server (port
3306)
but once you overcome that - you can make linked db's and views and sql
queries in access all day long.
To me - SSH is a secure version of Telnet - and they don't use the same
ports as mysql.

Sorry it took so long to get back to you .
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:BZ****************@newsread4.news.pas.earthli nk.net...
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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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 MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
> >
> >
>
>



Jul 19 '05 #12
Jerry - hmmmm - I do it all the time with odbc drivers for mySql and Visual
FoxPro.
Other developers have done it with Access and odbc, even across the internet
..
You might have some issues with the mysql port at the remote server (port
3306)
but once you overcome that - you can make linked db's and views and sql
queries in access all day long.
To me - SSH is a secure version of Telnet - and they don't use the same
ports as mysql.

Sorry it took so long to get back to you .
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:BZ****************@newsread4.news.pas.earthli nk.net...
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**********@advmed.com> wrote in message
news:1q****************@newssvr24.news.prodigy.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**************@newsread4.news.pas.earthlink .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 MySQLControlCenter 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...select' 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**********@advmed.com> wrote in message
news:8M*********************@newssvr12.news.prodig y.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***************@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.
> >
> >
>
>



Jul 19 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jerry Weinstein | last post: by
6 posts views Thread by Charles Banas | last post: by
4 posts views Thread by Supa Hoopsa | last post: by
3 posts views Thread by Jerome Ranch | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.