List:MySQL ODBC« Previous MessageNext Message »
From:Timo Maier Date:July 12 1999 2:05pm
Subject:myQDBC and Delph 4c/s
View as plain text  
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.....
</server.logfile>

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

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

-- 
Ciao ... TAM


Thread
myQDBC and Delph 4c/sTimo Maier12 Jul