DataTabSheet: Difference between revisions
Yadasampati (talk | contribs) No edit summary |
Yadasampati (talk | contribs) No edit summary |
||
| Line 9: | Line 9: | ||
! until | ! until | ||
! style="padding:5px; font-weight:bold"| Id | ! style="padding:5px; font-weight:bold"| Id | ||
! style="padding:5px; font-weight:bold"| Vers | |||
! style="padding:5px; font-weight:bold"| Text {{#for_external_table:<nowiki /> | ! style="padding:5px; font-weight:bold"| Text {{#for_external_table:<nowiki /> | ||
{{!}}- | {{!}}- | ||
Revision as of 19:11, 13 February 2023
The query SELECT tran.tran_id,tran_text,vers_ref,trpr_from,trpr_until FROM `tran`,`trpr`,`vers` WHERE tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and and prop_id = {{{1}}} is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and prop_id = {{{1}}}' at line 1 Function: EDConnectorRdbms::fetch Query: SELECT tran.tran_id,tran_text,vers_ref,trpr_from,trpr_until FROM `tran`,`trpr`,`vers` WHERE tran.tran_id=trpr.tran_id and tran.vers_id=vers.vers_id and and prop_id = {{{1}}} ).
| from | until | Id | Vers | Text |
|---|