BorlandTalk.com

Uncle Potato · Guest

I have a simple form having some DBEdit & a TQuery
To get a live record for edit, I do a

select * from MyTable where ID=:ID

For adding a new record, I usually put a string, which don't likely to
exists, into :ID, and open the query. Though it select an empty set,
this add new method works as expected.
This leaves my Form no different for EDIT and NEW.

But I think selecting something don't exist is a waste of time.
What is the better approach to do ?

Bill Todd · Guest

There is nothing wrong with that approach as long as the column in the
WHERE clause is indexed.

There is something wrong with using TQuery since that means you are
using the BDE. The BDE driver for InterBase only partially supports
dialect 3 databases and is deprecated. If you are going to work with
Firebird use FIBPlus or IBO.

--
Bill Todd (TeamB)