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
![](https://secure.gravatar.com/avatar/e7a85feabc1af7ccb6cd7227f94d0696?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
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.