Returns the SQL statement which was sent to the database to form the resultset in the currently visible listbox of LinkedDataBox.
The SQL statement may contain more fields than the user has chosen to display in his listbox view.
Example of a returned string:
SELECT evt.id ID_TO$,evt.Linkbox LINKBOX$,lnk.id ID_LINK$,adr.id ID_FROM$,adr.Linkbox 'Name', evt.Linkbox 'Seminar', lnk.NumParticipants 'Pers', lnk.InvoiceNo 'Invoice No', lnk.InvoiceAmount 'Amount', lnk.InvCurrency 'Crcy', lnk.GroupPrice 'Price', lnk.TotalPaid 'Paid', lnk.InvoiceDate 'Invoice Date', lnk.PaymentDate 'Payment Date', lnk.Commentary 'Commentary', lnk.isrCodeLine 'Code Line' FROM im_addresses adr ,im_events evt ,im_link_adr_evt lnk WHERE adr.id=lnk.id_adr AND evt.id=lnk.id_evt AND lnk.id_adr IN (1436)
Returns:
|
Type |
Value |
Description |
|
String |
Sql statement |
SQL statement which was sent to the database to form the resultset in the currently visible listbox of LinkedDataBox |
Available in:
|
WindowMain |
WindowLink |
|
YES |
NO |
Used in:
|
XojoScript Name |
GUID |
|
Copy current SQL of LinkedDataBox |
88F7F397-76E8-4921-92A5-158084A7BB63 |
Example XojoScript:
// Copy SQL of LinkedDataBox from Scripts Menu
Dim sql As String = GetLinkedDataBoxSQL
If sql <> "" Then
SetClipboardText(sql)
MsgBox("SQL copied to clipoard!" + EOL + EOL + sql)
End If