PDA

View Full Version : dbget()


ABC123

Mike Thomson
09-14-2005, 11:36 PM
function dbget as C (dbName as C, dbindex as C, dbKey as C, dbField as C)

Here is usefull function that you can use in your code
It is useful when you simply want to look up the value of a field from another table, according to a key value and index.

Example:
EmployeeName=dbget("Employees","Empno","1001","Name")
Returns the name of employee from employee tabler, wheree employee number is "1001", and there is an index called "Empno"

Parameters
1. dbname - The name of the table
2. dbfield - The name on the Index (Tag name)
3. dbkey - The value of the Index key to search for
4. The field value to be returned