MySQLTalk.org Forum Index MySQLTalk.org
MYSQL discussions groups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

myQDBC and Delph 4c/s

 
Post new topic   Reply to topic    MySQLTalk.org Forum Index -> MySQL ODBC
View previous topic :: View next topic  
Author Message
Timo Maier
Guest





PostPosted: Mon Jul 12, 1999 2:05 pm    Post subject: myQDBC and Delph 4c/s Reply with quote



Hi!

We're using myODBC (latest release for Win) on NT4/W95 to connect to our
OS/2
mySQL server in our Netware net.

a simply example for Delphi

Create a new form
add a TDataSource,TQuery and a TDBGrid

If I set the RequestLive property of TQuery to true (the result of the
query
has read AND write access) myODBC produces a "select * from table" query
first

<server.logfile>
990712 14:26:16 10 Connect tam@tam on diotec
10 Query show tables like 'kunden'
10 Query SELECT * FROM kunden <-----------HERE!!
990712 14:26:18 10 Query SELECT KundenID, KundenTyp, Kurz,
Name1.....

This takes a long time, because this table is very large.

How can we avoid the first select (SELECT * FROM kunden)?

--
Ciao ... TAM


Back to top
Display posts from previous:   
Post new topic   Reply to topic    MySQLTalk.org Forum Index -> MySQL ODBC All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.