I am using ODBC 4.51 and mySQL 4.0.1-NT. I have an app that is written in
vb6 with msAccess 2000 that was converted to mySQL. Everything is working
great except for one thing.
I have a grid of information (using TrueGrid v7) and I need the grid to
update with the newest data.
In msAccess (ADO) I used the adUseServer Cursor / Dynamic Recordset and then
all I had to do was do a tdbgrid1.refresh to get the latest data.
Everything was working just as I wanted.
In mySQL(ADO) when I use the adUseServer, I get no data returned to the
grid, and if I debug the data, it is there, but it doesn't refresh (in the
debug window). Changing to adUseClient puts the data in the grid, but
obviously doesn't refresh either.
The grid will have varying number of records depending on the query, but in
general it will have a couple of hundred records (with about 30 showing at
one time). What I need to be able to do, as an example, is to page down so
that records 60-90 are showing and refresh any new data that is coming in
without moving grid. I can do this programmatically, but was wondering if
anyone knew away around this. It worked perfectly with the msAccess engine.
BTW the options I have on the ODBC are 18475
2  2502 
Sorry ODBC 3.51
"David Codding" <dc******@saicorporate.com> wrote in message
news:10*************@corp.supernews.com... I am using ODBC 4.51 and mySQL 4.0.1-NT. I have an app that is written
in vb6 with msAccess 2000 that was converted to mySQL. Everything is working
great except for one thing.
I have a grid of information (using TrueGrid v7) and I need the grid to
update with the newest data.
In msAccess (ADO) I used the adUseServer Cursor / Dynamic Recordset and
then all I had to do was do a tdbgrid1.refresh to get the latest data.
Everything was working just as I wanted.
In mySQL(ADO) when I use the adUseServer, I get no data returned to the
grid, and if I debug the data, it is there, but it doesn't refresh (in the
debug window). Changing to adUseClient puts the data in the grid, but
obviously doesn't refresh either.
The grid will have varying number of records depending on the query, but
in general it will have a couple of hundred records (with about 30 showing
at one time). What I need to be able to do, as an example, is to page down
so that records 60-90 are showing and refresh any new data that is coming in
without moving grid. I can do this programmatically, but was wondering
if anyone knew away around this. It worked perfectly with the msAccess
engine.
BTW the options I have on the ODBC are 18475
Sorry ODBC 3.51
"David Codding" <dc******@saicorporate.com> wrote in message
news:10*************@corp.supernews.com... I am using ODBC 4.51 and mySQL 4.0.1-NT. I have an app that is written
in vb6 with msAccess 2000 that was converted to mySQL. Everything is working
great except for one thing.
I have a grid of information (using TrueGrid v7) and I need the grid to
update with the newest data.
In msAccess (ADO) I used the adUseServer Cursor / Dynamic Recordset and
then all I had to do was do a tdbgrid1.refresh to get the latest data.
Everything was working just as I wanted.
In mySQL(ADO) when I use the adUseServer, I get no data returned to the
grid, and if I debug the data, it is there, but it doesn't refresh (in the
debug window). Changing to adUseClient puts the data in the grid, but
obviously doesn't refresh either.
The grid will have varying number of records depending on the query, but
in general it will have a couple of hundred records (with about 30 showing
at one time). What I need to be able to do, as an example, is to page down
so that records 60-90 are showing and refresh any new data that is coming in
without moving grid. I can do this programmatically, but was wondering
if anyone knew away around this. It worked perfectly with the msAccess
engine.
BTW the options I have on the ODBC are 18475
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Chris |
last post by:
Hello,
I posted a while back about a newbie database question and got a
lot of great help here. My script that I am creating has come a long way
(For me!) and almost does what I need it too. I...
|
by: Fatt Shin |
last post by:
Hi,
I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB
Connector 3.51.
I'm facing a problem where whenever I issue a SELECT COUNT(*) statement
from PowerBuilder, I always get SQL...
|
by: DJJ |
last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time...
|
by: zaphod |
last post by:
Using MySQL Connector/ODBC 3.51, I set the port to a non-default value
(3309), under 'Connection Options' to connect to a remote machine running 2
versions of MySQL. 'Test' is successful but when I...
|
by: Eric E |
last post by:
Two questions regarding ODBC.
1) I am connecting to a MySQL database using the following code:
Function LoginToMySQL(sUsername As String, sPW As String) As Boolean
Dim dbMySQL As Database
Dim...
|
by: Travis |
last post by:
I am trying to display a query like this in my windows form:
SELECT workordernumber, date, firstname, lastname FROM customer_db;
I am using a rich text box to display the data but it only...
|
by: Maileen |
last post by:
Hi,
I'm writing a VC++.net 2005 application and i would like to use the ODBC
connector.
I would like to allow user to choose the DB he wants to have (MS SQL,
PostgreSQl, MySQL, Oracle,...) by...
|
by: Josema |
last post by:
Good Day to everyone.. please help me how to connect to MYSQL 5.0. I am using
the connection string.
I installed the ODBC MySQL Connector/ODBC v5.
my connecstring
------------------...
|
by: Mogens |
last post by:
My webhotel has tonight without warning blocked for all access to the
MySQL databases via odbc connector. This is a major problem because all
my routines such as packing lists and invoices that I...
|
by: dlitty |
last post by:
I'm new to MySql and have just installed it on my local machine. I've installed it on the "I" drive and everything went ok. Then I downloaded the MySql connector 3.51.12. It's setup file is on...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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,...
| |
