Implement Connection.QueryValue()
FIBPlus have a great and simple way to quickly ask databse about value or set of values, this method is called QueryValue. If I want to ask database for only one row, I do not want to create a dataset for it. It causes a big overhead.
Instead I would like to ask for a value like this:
MyValue := Connection.QueryValue('SELECT TOP 1 USERNAME FROM USERS WHERE SURNAME = :SURNAME', [Surname])
5
votes
Wodzu
shared this idea
-
Dorin Marcoci
commented
Internally FibPlus create a query and runs your statement.
This functionality is useless at it can be done in a functions with 5 lines of code in your datamodule.