Hello,

This is just a suggestion to build two Procudures/Functions that would allow a user to read a value from one single field and write/update value one single field.

Where it can be useful. For example when a user is creating an invoice and the user selects a product/item and we need to fetch its price (only nothing else) from another table generally will have to create a query for this particular operation or write a set of hreadseek, etc.

Instead of that it would be better to call a procedure that would fetch the required value from any table thrown to it.

According to me the parameters of such a Procedure/Function would be for example:

GetAnyFieldValue(sTableName is String, sFieldName is String, sWhereClause is String)

Here one has to give name of table from which data has to be fetched and field name whose value needs to be fetched and the where clause is just that the criteria according to which data is fetched.

One condition here should that the where clause should only return one single record but if the number of records returned are more than one we have to fetch the value from the first row and return it, ignoring the rest.

Again just my thoughts....

Yogi Yang