// Open online help in the default browser // Online help for the relevant language help // From Lianja/VFP Command Window: // Help command page (this page) help help // List of all ALTER ... commands help alter // CLEAR command page with a link to the list of all CLEAR ... commands help clear // AT() function page help at()
https://www.lianja.com/doc/index.php/HELP
ALTER TABLE customer; ADD COLUMN dateref DATE; DEFAULT date(); DESCRIPTION "Date Reference"
https://www.lianja.com/doc/index.php/DESCRIPTION_Column_Constraint
create table books; (title char(100) HELP "Enter the title",; authorlast char(100) HELP "Enter the author's surname") alter table "customers"; modify constraint (customerid HELP "Tooltip for Customer ID") alter table "customers"; modify constraint companyname set HELP "Tooltip for Company Name"
https://www.lianja.com/doc/index.php/HELP_Column_Constraint
open database southwind alter table "customers" modify constraint contacttitle set autosuggestions 'select distinct contacttitle,contactname from customers' alter table "customers" modify constraint contacttitle set autosuggestionheaders 'Title,Name'
https://www.lianja.com/doc/index.php/AUTOSUGGESTIONHEADERS_Column_Constraint
open database southwind
alter table "customers" modify constraint contacttitle;
set autosuggestions 'select distinct contacttitle,contactname from customers'
alter table "customers" modify constraint contacttitle;
set autosuggestionheaders 'Title,Name'
https://www.lianja.com/doc/index.php/AUTOSUGGESTIONS_Column_Constraint
open database southwind
showhelp("Help for Employees Page","lianjademo_help","page_employees",.T.)
https://www.lianja.com/doc/index.php/SHOWHELP()
Autosuggestion
Static lists are based on a comma-separated list of choices specified in the Autosuggestions attribute.
Autosuggestions: Buchanan,Callahan,Davolio,Dodsworth,Fuller,King,Leverling,Peacock,Suyama
Prefixing the list with ‘-‘ does not display the dropdown. Instead, it operates as an autocomplete.
Autosuggestions: -Buchanan,Callahan,Davolio,Dodsworth,Fuller,King,Leverling,Peacock,Suyama
A dynamic list is based on the evaluation of an expression from a specified table.
@,
Here the list is based on the current values of the lastname field from the employees table.
Autosuggestions: @employees,lastname
Here the list is based on the current values of the lastname field from the employees table.
Autosuggestions: select lastname from employees
The SQL Select statement can reference more than one column.
Autosuggestions: select lastname, firstname from employees
For multi-column SQL Select lists, the Autosuggestion headers attribute can be used to specify a comma separated list of column headers for the dropdown.
Autosuggestions: select lastname, firstname from employees
Autosuggestion headers: Surname,Firstname
Multi-column SQL Select with headers
The dropdown is displayed with column headers.
For multi-column SQL Select lists, the Autosuggestion column to search attribute can be used to specify the column to search.
Columns are numbered from 0. Here the lastname column is the search column.
Autosuggestions: select firstname, lastname from employees
Autosuggestion headers: Firstname,Surname
Autosuggestion column to search: 1
Multi-column SQL Select with headers and specified search column
The second column is the search column.
Clicking on a choice will load the value of the search column into the field.
Autosuggestions in the Web Client
From Lianja v4.1, SQL Select based autosuggestions are also supported in the Web client provided that they are set in the data dictionary and the section has the Inherit dictionary rules Attribute set to True.
Autosuggestions: select distinct contacttitle,contactname from customers
Autosuggestion headers: Title,Name
The Autosuggestions list can be based on the return value from a user defined function or procedure (Lianja/VFP scripting).
"{UserDefinedFunction()}"
The return value should be a comma-separated list. Here the list is based on the return value from the ‘getempname’ procedure defined in the App’s custom library.
Autosuggestions: "{getempname()}"
As in the other examples, it returns the lastname field values from the employees table.
proc getempname()
sqlvalues("select lastname from employees order by lastname")
creturn = astring(_sqlvalues)
return creturn
endproc
Lianja developer 