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.
12  3184 
Jerry -
mySql does not have stored procedures - so what are you going on about?
I have used stored procedures on MS-SQL and Oracle quite a lot in the past 5
years - I think my techniques on inserting records are a bit different than
yours.
I tend to shy away from VB, as it really is not a good language for the
manipulation of data. I am a big fan of Visual FoxPro and use it daily with
mySql - I've written about 18 applications now with these two beasties.
Typically my apps take advantage of the mySql odbc driver, remote views in
VFP back to mySql tables, sql pass through coding techniques and a good
error handler for the data inserts. I've never ever heard of utilizing
stored procedures in mySql. I have written meta stored procs in VFP that
execute against a mySql table - but its more of a glorified/stored
collection of sql code that gets evaluated on the vfp side, then executed on
the mySql side .
If you are thinking of using VB to manipulate data in mySql - here are some
metrics for ADO/VB vs SPT/VFP.
operation LOC/VB LOC/VFP
establish connection 12 2
insert a record 12 2
retrieve a record set 18 2
delete a record 12 2
let me know your thoughts? mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Jerry Weinstein" <je*************@earthlink.net> wrote in message
news:5W***************@newsread4.news.pas.earthlin k.net... Hi,
I know about stored procedures and that they can speed up data entry via
the SQL 'insert ' statement.
However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every
record to be inserted to the database before the procedure is executed.
I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be entered into each
record and then stores it to the table.
This seems easier (is there an even EASIER way?) than creating a text file
and then executing it.
Thoughts or comments desired, thanks.
Jerry -
mySql does not have stored procedures - so what are you going on about?
I have used stored procedures on MS-SQL and Oracle quite a lot in the past 5
years - I think my techniques on inserting records are a bit different than
yours.
I tend to shy away from VB, as it really is not a good language for the
manipulation of data. I am a big fan of Visual FoxPro and use it daily with
mySql - I've written about 18 applications now with these two beasties.
Typically my apps take advantage of the mySql odbc driver, remote views in
VFP back to mySql tables, sql pass through coding techniques and a good
error handler for the data inserts. I've never ever heard of utilizing
stored procedures in mySql. I have written meta stored procs in VFP that
execute against a mySql table - but its more of a glorified/stored
collection of sql code that gets evaluated on the vfp side, then executed on
the mySql side .
If you are thinking of using VB to manipulate data in mySql - here are some
metrics for ADO/VB vs SPT/VFP.
operation LOC/VB LOC/VFP
establish connection 12 2
insert a record 12 2
retrieve a record set 18 2
delete a record 12 2
let me know your thoughts? mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Jerry Weinstein" <je*************@earthlink.net> wrote in message
news:5W***************@newsread4.news.pas.earthlin k.net... Hi,
I know about stored procedures and that they can speed up data entry via
the SQL 'insert ' statement.
However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every
record to be inserted to the database before the procedure is executed.
I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be entered into each
record and then stores it to the table.
This seems easier (is there an even EASIER way?) than creating a text file
and then executing it.
Thoughts or comments desired, thanks.
Jerry -
mySql does not have stored procedures - so what are you going on about?
I have used stored procedures on MS-SQL and Oracle quite a lot in the past 5
years - I think my techniques on inserting records are a bit different than
yours.
I tend to shy away from VB, as it really is not a good language for the
manipulation of data. I am a big fan of Visual FoxPro and use it daily with
mySql - I've written about 18 applications now with these two beasties.
Typically my apps take advantage of the mySql odbc driver, remote views in
VFP back to mySql tables, sql pass through coding techniques and a good
error handler for the data inserts. I've never ever heard of utilizing
stored procedures in mySql. I have written meta stored procs in VFP that
execute against a mySql table - but its more of a glorified/stored
collection of sql code that gets evaluated on the vfp side, then executed on
the mySql side .
If you are thinking of using VB to manipulate data in mySql - here are some
metrics for ADO/VB vs SPT/VFP.
operation LOC/VB LOC/VFP
establish connection 12 2
insert a record 12 2
retrieve a record set 18 2
delete a record 12 2
let me know your thoughts? mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
mySql / VFP / MS-SQL
"Jerry Weinstein" <je*************@earthlink.net> wrote in message
news:5W***************@newsread4.news.pas.earthlin k.net... Hi,
I know about stored procedures and that they can speed up data entry via
the SQL 'insert ' statement.
However, one drawback to this method is that using the stored procedure
still requires one to manually and individually enter each and every
record to be inserted to the database before the procedure is executed.
I want to circumvent this tedium by finding a way to use maybe a VB
application that prompts a user for the data to be entered into each
record and then stores it to the table.
This seems easier (is there an even EASIER way?) than creating a text file
and then executing it.
Thoughts or comments desired, thanks.
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.
>
>
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.
>
>
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.
>
>
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.
>
>
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.
>
>
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.
>
>
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.
> >
> >
>
>
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.
> >
> >
>
>
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.
> >
> >
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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,...
| |
