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.
Multiplefield at the same time. Database/Acquisition 2 for the use of the product.

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 "data to be retrieved" will be the result.
argument (e.g. function, program, programme)

table	field
Fruit and Vegetable Table	Name

additional parameter

Search field	terms	Comparison value
ID	=	2

Data to be obtained

Name
green bell pepper

parameter

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

table	Specify the target table.
field	Specify the target field.
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

numeric data character string data Date & Time Data video data binary data
Returns a value retrieved from the database.

<前 0906_バイナリーデータ/文字列変換>

<次 1002_データベース/取得2>