Try this on a nightly run through the task scheduler.
;******************************************************
message " Exporting data... "
{tools}{Exportimport}{Export}{ascii}{delimited}{table1}{table1}
if menuchoice() = "Cancel" then
{Replace}
endif...
So John, do you have any example code on how to "select" data from a MySQL database? Meaning how to connect to one, query it out and then displaying to a datagrid? I do have the ODBC drivers installed for MySQL. But I see hell coming down the road with a distributed application that...
Does someone have examples on how to connect to a MySQL database with a grid? I have VB 6 studio.
I installed the ODBC driver, but I believe it is too much trouble to setup and I believe that can be by-passed. Is this true? Basically I am wondering if someone has a code snipet that opens a...
How does one(me) determine the domain name of my server? I created a database and a table and through Mysql.exe loaded 47,000 records into the database and select * from mytable works like a charm.
Now I am trying to use VB to connect to it. I like the SQLOLEDB alternative but I see that the...
Thanks sleipnir214, you nailed my problem with the load data directive. I was able to LOAD DATA INFILE "C:/somefile.txt" INTO TABLE TEST without a hitch now.
Are you the developer? The reason I ask is that you may have a design issue. If your application opens up all the tables during a data entry session for instance, then Paradox sends copies of all the databases to the "slaves". This is poor design.
Here is what I have done for a 18...
How big are your databases? How(big?) much space is the file server? What does the application do? Does you application open all or most of the tables at startup?
Scott
I recently went to a local Borders store to look for NW6 books. But didn't see any. I also did a search on Amazon, I didn't see any there either. Does anyone know of any?
Scott
I noticed that this SQL engine when fiddling with a NW6 server the other day. I wanted to know if anyone had any comments on its usefullness or performance?
Scott
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.