Skip to content

Commit 3cc4975

Browse files
committed
Merge pull request livecode#3508 from marksmithhfx/patch-1
Community Docs: fixed misspelled command revDatabaseQuery
2 parents ecd5495 + 287428e commit 3cc4975

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/dictionary/function/revDataFromQuery.lcdoc

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@ Returns: The <revDataFromQuery> <function> returns the data in the <record|recor
3737
Description:
3838
Use the <revDataFromQuery> <function> when you want to use or display data from a database, but not continue to work with the <record|records> that contain it.
3939

40-
It is convenient to use the <revDataFromQuery> <function>, instead of revDatabaseQuery, when you want to obtain the data for use but don't need to retain a reference to the <record|records> that the data came from. The <revDataFromQuery> <function> executes the <SQLQuery>, gets the <record|records> found by the <SQL query|query>, closes the <record set (database cursor)|record set> created by the <SQL query|query>, and returns the data.
40+
It is convenient to use the <revDataFromQuery> <function>, instead of revQueryDatabase, when you want to obtain the data for use but don't need to retain a reference to the <record|records> that the data came from. The <revDataFromQuery> <function> executes the <SQLQuery>, gets the <record|records> found by the <SQL query|query>, closes the <record set (database cursor)|record set> created by the <SQL query|query>, and returns the data.
4141

4242
Important: The <revDataFromQuery> function should not be used if any of the data being retrieved is binary, doing so will probably produce unexpected results. If you wish to use this function to return things like image data, the data should be encoded before being stored in the database, this could for example be done with the <base64Encode function>. Also remember to specify a columDelim and <rowDelim> that will not appear in the data. Alternatively, both these problems can be avoided by using the <revQueryDatabase function> to generate a record set, then using <revDatabaseColumnNamed> to retrieve each field individually.
4343

0 commit comments

Comments
 (0)