Re: SQL Theory/performance

In article <3248C8E3.D36_at_interlog.com>, spo_at_interlog.com says...
>
>Regarding Delphi, I've heard a lot about using TQuery over TTable for
>C/S apps but the idea of inserting record then having to close that
>query and go back to find the new one scares the crap out of me.
>

If you are open to not using the BDE check out http://www.adam.co.za.

They make ODBCExpress. You can do POSITIONED updates with their tools, including their grid.

Drawbacks - you don't get live design time data.

Plus - It's fast ODBC programming. They did some tests which showed it to be 10 - 15% faster then using Delphi (before the updated drivers came out) with the BDE.

Bye.

--
Greg Carter, Electrical Engineer
CRYPTOCard Corporation
gregc_at_cryptocard.com