functional overview

Retrieves values from the database.

Details of Functions

tablelocated infieldvalue.
If search criteria are added, the target records are narrowed down according to the specified criteria.

note

Fruit and Vegetable Table

ID	Name	Category
1	apple (fruit)	fruit
2	green bell pepper	vegetable
3	onion (edible plant, Allium cepa)	vegetable
4	grape	fruit
5	potato (Solanum tuberosum)	vegetable

If the following argument is specified, the "dictionary to be created" will be the result.
argument (e.g. function, program, programme)

table	field
Fruit and Vegetable Table	Name

additional parameter

field
category

Search field	terms	Comparison value
ID	=	2

Dictionary to be created

key	value
Name	green bell pepper
category	vegetable

argument (e.g. function, program, programme)

table	Specify the target table.
field	Specify the target field.
field	Specify the target field. (additional argument)
Search field	Specify fields to search. (additional argument)
terms	Specify conditions. (additional argument) >= <= > < ! = ! =
Comparison value	numeric data character string data Date & Time Data Search fieldand the value to be compared. (additional argument)

return value: Dictionary (associative array)
Returns a dictionary of converted values retrieved from the database.