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/s | Timo Maier | 12 Jul |