Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsbasicshared03/gcf/units/?format=api&page=22
{ "count": 4173, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/units/?format=api&page=23", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/units/?format=api&page=21", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Properties" ], "previous_source": "", "target": [ "" ], "id_hash": 2558618142951932495, "content_hash": 2558618142951932495, "location": "sf_database.xhp", "context": "sf_database.xhp\nhd_id841587913266618\nhelp.text", "note": "EF9Lc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315175/?format=api", "priority": 100, "id": 111008975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=a38209a51685024f", "url": "https://translations.documentfoundation.org/api/units/111008975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.557268Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Name" ], "previous_source": "", "target": [ "" ], "id_hash": -1024355172897684507, "content_hash": -1024355172897684507, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id521587913266568\nhelp.text", "note": "x4Z5A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1052, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315184/?format=api", "priority": 100, "id": 111008979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=71c8c265c39983e5", "url": "https://translations.documentfoundation.org/api/units/111008979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.559123Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Readonly" ], "previous_source": "", "target": [ "" ], "id_hash": 6382439573515894090, "content_hash": 6382439573515894090, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id421587913266368\nhelp.text", "note": "QUrYT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315196/?format=api", "priority": 100, "id": 111008984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=d892faf9fbcf7d4a", "url": "https://translations.documentfoundation.org/api/units/111008984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.566818Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Type" ], "previous_source": "", "target": [ "" ], "id_hash": 6988644218996800360, "content_hash": 6988644218996800360, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id631587914939732\nhelp.text", "note": "3kQCm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1054, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315209/?format=api", "priority": 100, "id": 111008992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=e0fca6e3c6e43b68", "url": "https://translations.documentfoundation.org/api/units/111008992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.570131Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Description" ], "previous_source": "", "target": [ "" ], "id_hash": -7463737517843404268, "content_hash": -7463737517843404268, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id951587913266220\nhelp.text", "note": "RYuuo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1055, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315220/?format=api", "priority": 100, "id": 111008994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=186b7a45a8302a14", "url": "https://translations.documentfoundation.org/api/units/111008994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.572087Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": 3707804006823966376, "content_hash": 3707804006823966376, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id651587913266754\nhelp.text", "note": "BzLQb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1056, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315239/?format=api", "priority": 100, "id": 111008997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=b374c419738336a8", "url": "https://translations.documentfoundation.org/api/units/111008997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.573753Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Array of strings" ], "previous_source": "", "target": [ "" ], "id_hash": 6874446550414247422, "content_hash": 6874446550414247422, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id421587914989890\nhelp.text", "note": "up8WT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1057, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110315250/?format=api", "priority": 100, "id": 111009000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=df66f0b718d9c5fe", "url": "https://translations.documentfoundation.org/api/units/111009000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.575218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The list of stored queries." ], "previous_source": "", "target": [ "" ], "id_hash": -6029170855003679066, "content_hash": -6029170855003679066, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id351587913266349\nhelp.text", "note": "dGoYp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1058, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110315255/?format=api", "priority": 100, "id": 111009036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=2c54150d215e16a6", "url": "https://translations.documentfoundation.org/api/units/111009036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.855794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": -4787512321686226205, "content_hash": -4787512321686226205, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id931599409717463\nhelp.text", "note": "bfdLR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1059, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315257/?format=api", "priority": 100, "id": 111009045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=3d8f56e8a4163ae3", "url": "https://translations.documentfoundation.org/api/units/111009045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.861232Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Array of strings" ], "previous_source": "", "target": [ "" ], "id_hash": 3167374122562056857, "content_hash": 3167374122562056857, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id71599409717945\nhelp.text", "note": "2DDTs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1060, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110315263/?format=api", "priority": 100, "id": 111009056, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=abf4c5fba6137299", "url": "https://translations.documentfoundation.org/api/units/111009056/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:47.872677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The list of stored tables." ], "previous_source": "", "target": [ "" ], "id_hash": -2746091359252635800, "content_hash": -2746091359252635800, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id341599409717612\nhelp.text", "note": "rGTvw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1061, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110315301/?format=api", "priority": 100, "id": 111009062, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=59e3ec754afa1f68", "url": "https://translations.documentfoundation.org/api/units/111009062/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.018054Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": -8639237245016546306, "content_hash": -8639237245016546306, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id741599409777967\nhelp.text", "note": "u5YE4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1062, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315332/?format=api", "priority": 100, "id": 111009066, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=081b437f9076e3fe", "url": "https://translations.documentfoundation.org/api/units/111009066/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.021621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The UNO object representing the current database connection." ], "previous_source": "", "target": [ "" ], "id_hash": 2178779382469130927, "content_hash": 2178779382469130927, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id551599409777759\nhelp.text", "note": "evuSw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1063, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110315342/?format=api", "priority": 100, "id": 111009070, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=9e3c944e00047aaf", "url": "https://translations.documentfoundation.org/api/units/111009070/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.024213Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": 7242074428110287102, "content_hash": 7242074428110287102, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id271599409887585\nhelp.text", "note": "w9YZG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1064, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315353/?format=api", "priority": 100, "id": 111009072, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=e48104527c7430fe", "url": "https://translations.documentfoundation.org/api/units/111009072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.026406Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The UNO object representing the metadata describing the database system attributes." ], "previous_source": "", "target": [ "" ], "id_hash": 4706871438869749646, "content_hash": 4706871438869749646, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id861599409887284\nhelp.text", "note": "NeTGg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1065, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110315364/?format=api", "priority": 100, "id": 111009075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=c1522aa2b5435f8e", "url": "https://translations.documentfoundation.org/api/units/111009075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.028028Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "List of Methods in the Database Service" ], "previous_source": "", "target": [ "" ], "id_hash": 4015322983893273180, "content_hash": 4015322983893273180, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id231614360519973\nhelp.text", "note": "ApsdK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1066, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110315375/?format=api", "priority": 100, "id": 111009078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=b7b94afad16b8a5c", "url": "https://translations.documentfoundation.org/api/units/111009078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.029626Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Closes the current database connection." ], "previous_source": "", "target": [ "" ], "id_hash": 7042633241067681510, "content_hash": 7042633241067681510, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id201587913266596\nhelp.text", "note": "emrA2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1067, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110315377/?format=api", "priority": 100, "id": 111009089, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=e1bc759e893276e6", "url": "https://translations.documentfoundation.org/api/units/111009089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.403869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Commits all updates done since the previous <literal>Commit</literal> or <literal>Rollback</literal> call." ], "previous_source": "", "target": [ "" ], "id_hash": 5244603176257451156, "content_hash": 5244603176257451156, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id201587913264308\nhelp.text", "note": "xhv9F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1068, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110315379/?format=api", "priority": 100, "id": 111009092, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=c8c892cd3cb5f494", "url": "https://translations.documentfoundation.org/api/units/111009092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.407404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "This method is ignored if commits are done automatically after each SQL statement, i.e. the database is set to the default auto-commit mode." ], "previous_source": "", "target": [ "" ], "id_hash": 3622277481549208839, "content_hash": 3622277481549208839, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id391701355293522\nhelp.text", "note": "P4TEF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1069, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110315396/?format=api", "priority": 100, "id": 111009094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=b244ea2d85a31d07", "url": "https://translations.documentfoundation.org/api/units/111009094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.410527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Set the REPEATABLE_READ transaction level" ], "previous_source": "", "target": [ "" ], "id_hash": -5545983312272246502, "content_hash": -5545983312272246502, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id141701355821478\nhelp.text", "note": "DHATj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1070, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110315423/?format=api", "priority": 100, "id": 111009097, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=3308b58fb5c4b91a", "url": "https://translations.documentfoundation.org/api/units/111009097/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.414590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Test some condition before committing" ], "previous_source": "", "target": [ "" ], "id_hash": -3122915307201618239, "content_hash": -3122915307201618239, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id311701355662993\nhelp.text", "note": "2mfAJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1071, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110315446/?format=api", "priority": 100, "id": 111009100, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=54a92d12f29e1ec1", "url": "https://translations.documentfoundation.org/api/units/111009100/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.416726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Restore auto-commit mode" ], "previous_source": "", "target": [ "" ], "id_hash": -7027345816749945171, "content_hash": -7027345816749945171, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id711701355663208\nhelp.text", "note": "xNjdS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1072, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110315459/?format=api", "priority": 100, "id": 111009101, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=1e79da364ecacead", "url": "https://translations.documentfoundation.org/api/units/111009101/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.418541Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Creates a <literal>Dataset</literal> service instance based on a table, query or SQL <literal>SELECT</literal> statement." ], "previous_source": "", "target": [ "" ], "id_hash": 2164841578841432693, "content_hash": 2164841578841432693, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id41599488113502\nhelp.text", "note": "XigYX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1073, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315477/?format=api", "priority": 100, "id": 111009106, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=9e0b0ff235d6e275", "url": "https://translations.documentfoundation.org/api/units/111009106/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.424842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>sqlcommand</emph>: A table name, a query name or a valid SQL <literal>SELECT</literal> statement. Identifiers may be enclosed with square brackets. This argument is case-sensitive." ], "previous_source": "", "target": [ "" ], "id_hash": -2276020279883234172, "content_hash": -2276020279883234172, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id591701267115505\nhelp.text", "note": "MX6BM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1074, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110315492/?format=api", "priority": 100, "id": 111009109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=6069f39d43f98484", "url": "https://translations.documentfoundation.org/api/units/111009109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.426196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>directsql</emph>: Set this argument to <literal>True</literal> to send the statement directly to the database engine without preprocessing by %PRODUCTNAME (Default = <literal>False</literal>)." ], "previous_source": "", "target": [ "" ], "id_hash": 3028658484650172843, "content_hash": 3028658484650172843, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id841701267114060\nhelp.text", "note": "HSKm4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1075, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110315665/?format=api", "priority": 100, "id": 111009110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=aa07f4d8638be1ab", "url": "https://translations.documentfoundation.org/api/units/111009110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.427272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>filter</emph>: Specifies the condition that records must match to be included in the returned dataset. This argument is expressed as a SQL <literal>WHERE</literal> statement without the \"WHERE\" keyword." ], "previous_source": "", "target": [ "" ], "id_hash": -5336237315516567488, "content_hash": -5336237315516567488, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id241701267114527\nhelp.text", "note": "ZoWu5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1076, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110315678/?format=api", "priority": 100, "id": 111009112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=35f1e06f23737040", "url": "https://translations.documentfoundation.org/api/units/111009112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.479960Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>orderby</emph>: Specifies the ordering of the dataset as a SQL <literal>ORDER BY</literal> statement without the \"ORDER BY\" keyword." ], "previous_source": "", "target": [ "" ], "id_hash": 5643025730111777603, "content_hash": 5643025730111777603, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id471701267115093\nhelp.text", "note": "SGBKv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1077, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315688/?format=api", "priority": 100, "id": 111009115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=ce500e00e5b3ab43", "url": "https://translations.documentfoundation.org/api/units/111009115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.482938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The following examples in Basic and Python return a dataset with the records of a table named \"Customers\"." ], "previous_source": "", "target": [ "" ], "id_hash": 4064104474469736385, "content_hash": 4064104474469736385, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id941701267748877\nhelp.text", "note": "V8pDK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1078, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315698/?format=api", "priority": 100, "id": 111009117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=b866997caad81fc1", "url": "https://translations.documentfoundation.org/api/units/111009117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.486138Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "oDataset = myDatabase.CreateDataset(\"Customers\", Filter := \"[Name] LIKE 'A'\")" ], "previous_source": "", "target": [ "" ], "id_hash": 7571557130954659453, "content_hash": 7571557130954659453, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id241701267631273\nhelp.text", "note": "Ebnho", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1079, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110315709/?format=api", "priority": 100, "id": 111009119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=e91393184320d67d", "url": "https://translations.documentfoundation.org/api/units/111009119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.488290Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "dataset = myDatabase.CreateDataset(\"Customers\", Filter = \"[Name] LIKE 'A'\")" ], "previous_source": "", "target": [ "" ], "id_hash": -5451003037203448873, "content_hash": -5451003037203448873, "location": "sf_database.xhp", "context": "sf_database.xhp\npyc_id931701267696812\nhelp.text", "note": "h2NSq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1080, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110315711/?format=api", "priority": 100, "id": 111009121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=345a259e49e9bbd7", "url": "https://translations.documentfoundation.org/api/units/111009121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.490170Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Computes the given aggregate function on a field or expression belonging to a table." ], "previous_source": "", "target": [ "" ], "id_hash": -394164150598057819, "content_hash": -394164150598057819, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id13159655484952\nhelp.text", "note": "nwbSh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1081, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315713/?format=api", "priority": 100, "id": 111009124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=7a87a5cb1c68c0a5", "url": "https://translations.documentfoundation.org/api/units/111009124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.492077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Optionally, a SQL <literal>WHERE</literal> clause can be specified as a filter that will be applied prior to the aggregate function." ], "previous_source": "", "target": [ "" ], "id_hash": -6735777180227982965, "content_hash": -6735777180227982965, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id101615148468548\nhelp.text", "note": "E9LsG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1082, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110315714/?format=api", "priority": 100, "id": 111009127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=2285b6579e54298b", "url": "https://translations.documentfoundation.org/api/units/111009127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.493816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>expression</emph>: A SQL expression in which the field names are surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": 1472519472863268151, "content_hash": 1472519472863268151, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id441596554849949\nhelp.text", "note": "AKqei", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1083, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315732/?format=api", "priority": 100, "id": 111009131, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=946f70a8a8dc4d37", "url": "https://translations.documentfoundation.org/api/units/111009131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:48.495551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>tablename</emph>: A table name (without square brackets)." ], "previous_source": "", "target": [ "" ], "id_hash": 4289925557642658672, "content_hash": 4289925557642658672, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id381596554849698\nhelp.text", "note": "c2Rzq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1084, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110315753/?format=api", "priority": 100, "id": 111009138, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=bb88e090d0290370", "url": "https://translations.documentfoundation.org/api/units/111009138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.775835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>criteria</emph>: A <literal>WHERE</literal> clause without the \"WHERE\" keyword, in which field names are surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": 5542733523592601938, "content_hash": 5542733523592601938, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id521596554849185\nhelp.text", "note": "cjGPp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1085, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110315768/?format=api", "priority": 100, "id": 111009141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=ccebbec5e662e152", "url": "https://translations.documentfoundation.org/api/units/111009141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.779676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The example below assumes the file <literal>Employees.odb</literal> has a table named <literal>EmployeeData</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": -6188979905976865405, "content_hash": -6188979905976865405, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id781615150306678\nhelp.text", "note": "AGBFS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1086, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110315790/?format=api", "priority": 100, "id": 111009145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=2a1c5390ee37ed83", "url": "https://translations.documentfoundation.org/api/units/111009145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.781885Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Counts the number of employees in the table" ], "previous_source": "", "target": [ "" ], "id_hash": -8447375229691205009, "content_hash": -8447375229691205009, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id871615150277916\nhelp.text", "note": "KAqZB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1087, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110315817/?format=api", "priority": 100, "id": 111009147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=0ac4e4fc15d26a6f", "url": "https://translations.documentfoundation.org/api/units/111009147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.783798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Returns the sum of all salaries in the table" ], "previous_source": "", "target": [ "" ], "id_hash": 410635201929468043, "content_hash": 410635201929468043, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id291615150373387\nhelp.text", "note": "AVstM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1088, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110315824/?format=api", "priority": 100, "id": 111009153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=85b2de8a5f46d88b", "url": "https://translations.documentfoundation.org/api/units/111009153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.788015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "' Below are some examples of how tables can be filtered" ], "previous_source": "", "target": [ "" ], "id_hash": 216717035045705298, "content_hash": 216717035045705298, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id931615150423062\nhelp.text", "note": "cMiVJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1089, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110315826/?format=api", "priority": 100, "id": 111009162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=8301eefec2acd652", "url": "https://translations.documentfoundation.org/api/units/111009162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.792445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Computes a SQL expression on a single record returned by a <literal>WHERE</literal> clause defined by the <literal>Criteria</literal> parameter." ], "previous_source": "", "target": [ "" ], "id_hash": -296676254251143446, "content_hash": -296676254251143446, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id41599488113961\nhelp.text", "note": "kCmmv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1090, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315828/?format=api", "priority": 100, "id": 111009170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=7be1fe84c4112eea", "url": "https://translations.documentfoundation.org/api/units/111009170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.794601Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "If the query returns multiple records, only the first one is considered. Use the <literal>OrderClause</literal> parameter to determine how query results are sorted." ], "previous_source": "", "target": [ "" ], "id_hash": -2636970318474075453, "content_hash": -2636970318474075453, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id601615381471954\nhelp.text", "note": "8yUaz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1091, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110315831/?format=api", "priority": 100, "id": 111009175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=5b679977741aa2c3", "url": "https://translations.documentfoundation.org/api/units/111009175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.798445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>expression</emph>: A SQL expression in which the field names are surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": 8452656534688239251, "content_hash": 8452656534688239251, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id671599488113986\nhelp.text", "note": "tNnSe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1092, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315833/?format=api", "priority": 100, "id": 111009180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=f54dde558e7a0e93", "url": "https://translations.documentfoundation.org/api/units/111009180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.800430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>tablename</emph>: A table name (without square brackets)." ], "previous_source": "", "target": [ "" ], "id_hash": 353889189712419124, "content_hash": 353889189712419124, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id441599488113247\nhelp.text", "note": "eGbAr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1093, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110315835/?format=api", "priority": 100, "id": 111009185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=84e94457d2a8d934", "url": "https://translations.documentfoundation.org/api/units/111009185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.802100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>criteria</emph>: A <literal>WHERE</literal> clause without the \"WHERE\" keyword, in which field names are surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": -8457723585346991710, "content_hash": -8457723585346991710, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id40159948811316\nhelp.text", "note": "F9xaH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1094, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110315837/?format=api", "priority": 100, "id": 111009190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=0aa02135c6f309a2", "url": "https://translations.documentfoundation.org/api/units/111009190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.803803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>orderclause</emph>: An <literal>ORDER BY</literal> clause without the \"ORDER BY\" keywords. Field names should be surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": 1763450666600376156, "content_hash": 1763450666600376156, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id71599488689029\nhelp.text", "note": "SusUk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1095, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315863/?format=api", "priority": 100, "id": 111009195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=98790909c1a4275c", "url": "https://translations.documentfoundation.org/api/units/111009195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.806095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "Stores the contents of a table or the results of a <literal>SELECT</literal> query or of an SQL statement in a two-dimensional array. The first index in the array corresponds to the rows and the second index refers to the columns." ], "previous_source": "", "target": [ "" ], "id_hash": -8010518287784202902, "content_hash": -8010518287784202902, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id481599489278579\nhelp.text", "note": "CPoBx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1096, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110315907/?format=api", "priority": 100, "id": 111009199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=10d4ec0f0dda2d6a", "url": "https://translations.documentfoundation.org/api/units/111009199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.808083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "An upper limit can be specified to the number of returned rows. Optionally column names may be inserted in the first row of the array." ], "previous_source": "", "target": [ "" ], "id_hash": 7955536931485659761, "content_hash": 7955536931485659761, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id821615384762425\nhelp.text", "note": "GXji8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1097, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110315929/?format=api", "priority": 100, "id": 111009202, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=ee67beb05eb43271", "url": "https://translations.documentfoundation.org/api/units/111009202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.810036Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "The returned array will be empty if no rows are returned and the column headers are not required." ], "previous_source": "", "target": [ "" ], "id_hash": 1551240638000359276, "content_hash": 1551240638000359276, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id271599490209915\nhelp.text", "note": "gX7AY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1098, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315939/?format=api", "priority": 100, "id": 111009207, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=95871d243529676c", "url": "https://translations.documentfoundation.org/api/units/111009207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.812027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>sqlcommand</emph>: A table or query name (without square brackets) or a <literal>SELECT</literal> SQL statement." ], "previous_source": "", "target": [ "" ], "id_hash": 9076569138327269887, "content_hash": 9076569138327269887, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id451599489278429\nhelp.text", "note": "y5u8i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1099, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315949/?format=api", "priority": 100, "id": 111009213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=fdf6738aa54531ff", "url": "https://translations.documentfoundation.org/api/units/111009213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.813946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/gcf/?format=api", "source": [ "<emph>directsql</emph>: When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis. Default is <literal>False</literal>. This argument is ignored for tables. For queries, the applied option is the one set when the query was defined." ], "previous_source": "", "target": [ "" ], "id_hash": 8814331015989700384, "content_hash": 8814331015989700384, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id271599489278141\nhelp.text", "note": "xAbDx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110315963/?format=api", "priority": 100, "id": 111009218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/gcf/?checksum=fa52cb5bd4c62720", "url": "https://translations.documentfoundation.org/api/units/111009218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:30:53.816059Z" } ] }