|
| Home | About SQeeL | Document | DownLoad | Mail |  |
|
||||||||||
|
 |
Home > Document > SQeeL Reference |
| ||||||||||||||||||||||||
|
A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | R | S | T | U | X | Y | |||
DescriptionSyntaxReturn Value| 1 | : | Success |
System Return Value| 0 | Success |
Example//[result example]
//
// Jan has 31 days
// Feb has 29 days
// Mar has 31 days
// Apr has 30 days
// May has 31 days
// Jun has 30 days
// Jul has 31 days
// Aug has 31 days
// Sep has 30 days
// Oct has 31 days
// Nov has 30 days
// Dec has 31 days
//
run()
exit
function run()
local data1 = { ' 1', ' 2', ' 3', ' 4', ' 5', ' 6', ' 7', ' 8' ,' 9', '10', '11', '12' }
local data2 = { 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec' }
local data3 = { '31', '29', '31', '30', '31', '30', '31', '31', '30', '31', '30', '31' }
local i, m_tab
xsql select m_num, m_name, m_days from array('m_num', data1, 'm_name', data2, 'm_days', data3);
m_tab = xfetch(0)
xclose()
loop i=0; i<count(m_tab); i++
print('${m_tab[i]["m_name"]} has ${m_tab[i]["m_days"]} days', stdout)
endloop
endfunction
DescriptionSyntaxParameters| fetchsize | : | Number of rows to fetch |
| direction | : | Method of storing the return value |
Return Value| 0 | : | Error | |
| 1 | : | Success |
System Return Value| 0 | Success | |
| 1 | Argument error |
Example
Topへ//[result example]
//
// Jan has 31 days
// Feb has 29 days
// Mar has 31 days
// Apr has 30 days
// May has 31 days
// Jun has 30 days
// Jul has 31 days
// Aug has 31 days
// Sep has 30 days
// Oct has 31 days
// Nov has 30 days
// Dec has 31 days
//
run()
exit
function run()
local data1 = { ' 1', ' 2', ' 3', ' 4', ' 5', ' 6', ' 7', ' 8' ,' 9', '10', '11', '12' }
local data2 = { 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec' }
local data3 = { '31', '29', '31', '30', '31', '30', '31', '31', '30', '31', '30', '31' }
local i, m_tab
xsql select m_num, m_name, m_days from array('m_num', data1, 'm_name', data2, 'm_days', data3);
m_tab = xfetch(0)
xclose()
loop i=0; i<count(m_tab); i++
print('${m_tab[i]["m_name"]} has ${m_tab[i]["m_days"]} days', stdout)
endloop
endfunction
DescriptionSyntaxReturn Value| 0 or more | : | Location in a file | |
| -1 | : | Error |
System Return Value| 0 | Success | |
| 10 | Fail |
See AlsoExampleDescriptionSyntaxParameters| position | : | Location in a file |
Return Value| 1 | : | Success | |
| 0 | : | Error |
System Return Value| 0 | Success | |
| 10 | xsql is not processed | |
| 11 | Invalid file status |
See AlsoExampleDescriptionSyntaxParameters| sql_statement | : | select statement |
Return Value| 1 | : | Success | |
| 0 | : | Error |
System Return Value| 0 | Success | |
| 11 | Argument error | |
| その他 | Returned value by the pseudo table |
Example//[result example]
//
// Jan has 31 days
// Feb has 29 days
// Mar has 31 days
// Apr has 30 days
// May has 31 days
// Jun has 30 days
// Jul has 31 days
// Aug has 31 days
// Sep has 30 days
// Oct has 31 days
// Nov has 30 days
// Dec has 31 days
//
run()
exit
function run()
local data1 = { ' 1', ' 2', ' 3', ' 4', ' 5', ' 6', ' 7', ' 8' ,' 9', '10', '11', '12' }
local data2 = { 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec' }
local data3 = { '31', '29', '31', '30', '31', '30', '31', '31', '30', '31', '30', '31' }
local i, m_tab
xsql select m_num, m_name, m_days from array('m_num', data1, 'm_name', data2, 'm_days', data3);
m_tab = xfetch(0)
xclose()
loop i=0; i<count(m_tab); i++
print('${m_tab[i]["m_name"]} has ${m_tab[i]["m_days"]} days', stdout)
endloop
endfunction
DescriptionRead / WriteTypeRequirementsDescriptionRead / WriteTypeinitial valueRequirementsDescriptionRead / WriteTypeinitial valueRequirementsDescriptionSyntaxReturn Value| document ID | : | Success |
RequirementsExampleDescriptionSyntaxParameters| filename | : | File name |
Return Value| document ID | : | Success |
RequirementsExampleDescriptionSyntaxParameters| string | : | XML-format character string |
Return Value| document ID | : | Success |
RequirementsExampleDescriptionSyntaxParameters| document_id | : | document ID |
Return Value| 0 | : | ||
| 0 or more | : | Fail |
RequirementsExampleDescriptionSyntaxParameters| document_id | : | document ID |
| filename | : | file name |
| string | : | character code |
| format_flag | : | Format Default: FALSE |
Return Value| saved string | : | Success | |
| negative value | : | Fail |
RequirementsExampleDescriptionSyntaxParameters| document_id | : | document ID |
| format_flag | : | Format |
Return Value| XML string | : | Success |
RequirementsExampleDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| string | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| string | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
| string | : | character string |
Return Value| 0 | : | Success | |
| -1 | : | Fail |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| string | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| system constant | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| node ID array | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| document ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id1 | : | Parent node |
| node_id2 | : | new child node |
| node_id3 | : | old child node |
Return Value| replaced node ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id1 | : | Parent node |
| node_id2 | : | child node |
Return Value| deleted node ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id1 | : | Parent node |
| node_id2 | : | child node |
Return Value| added node ID | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
Return Value| TRUE | : | Child node exists | |
| FALSE | : | Child node does not exist |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
| flag | : | Boolean value |
Return Value| copied node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID |
| emelent_name | : | Element name |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID |
| string | : | text content |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID |
| string | : | Text content |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID |
| string | : | CDATASection content |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID |
| string | : | Target name |
| string | : | Data |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID |
| string | : | Reference entity name |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID or Element ID |
| string | : | Tag name |
Return Value| node ID array | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Document ID or Element ID |
| string | : | ID name |
Return Value| node ID | : | Success |
RequirementsDescriptionSyntaxParameters| element_id | : | Element ID |
Return Value| string | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Element ID |
| string | : | attribute name |
Return Value| string | : | Success |
RequirementsDescriptionSyntaxParameters| document_id | : | Element ID |
| string | : | attribute name |
| string | : | Attribute value |
RequirementsDescriptionSyntaxParameters| document_id | : | Element ID |
| string | : | attribute name |
RequirementsDescriptionSyntaxParameters| document_id | : | Node ID |
| string | : | Xpath character string |
Return Value| node ID array, string, numeric value, authentic value | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Node ID |
RequirementsDescriptionSyntaxParameters| node_id | : | Document ID |
| node_id | : | Root element name |
| node_id | : | Public ID |
| node_id | : | System ID |
Return Value| 0 | : | Success | |
| 1 | : | Fail because internal DTD already exists. | |
| negative value | : | Error |
RequirementsDescriptionSyntaxParameters| node_id | : | Document ID |
| node_id | : | Entity name |
| node_id | : | Entity value |
Return Value| 0 | : | Success | |
| 1 | : | Fail because the same entity alreasy exists. | |
| 2 | : | Fail because internal DTD is not defined | |
| negative value | : | Error |
RequirementsDescriptionSyntaxParameters| node_id | : | Document ID |
| node_id | : | Entity name |
| node_id | : | Public ID |
| node_id | : | System ID |
Return Value| 0 | : | Success | |
| 1 | : | Fail because the same entity alreasy exists. | |
| negative value | : | Error |
RequirementsDescriptionSyntaxParameters| node_id | : | Document ID |
| node_id | : | Entity name |
Return Value| entity value(string) | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Document ID |
| node_id | : | Entity name |
Return Value| system ID(string) | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Document ID |
| node_id | : | Entity name |
Return Value| public ID(string) | : | Success |
RequirementsDescriptionSyntaxParameters| node_id | : | Document ID |
Return Value| entity name array | : | Success |
Requirements