Valdir,

V> 1. select * from sometable where id = :id
V> 2. select * from sometable where id = 10
V> 3. select * from sometable where id = 20
V> 4. SELECT * FROM sometable where id = :id
V> 5. select * from sometable where id = :id

V> It'll prepare every sql if sent in this order?

yes, unless you explicitly prepare statements on the client.
In other words, Firebird does not do statement caching (yet).

Ciao
--
Nando mailto:nandod@...