Help [examples]

Open online help in the default browser
HELP
// 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


Column constraint to set the column description for the specified column
ALTER TABLE customer;
  ADD COLUMN dateref DATE;
  DEFAULT date();
  DESCRIPTION "Date Reference"

https://www.lianja.com/doc/index.php/DESCRIPTION_Column_Constraint


Column constraint to set the tooltip for the specified column
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


Column constraint to specify the autosuggestion headers for a column
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


Column constraint to specify the autosuggestions for a column
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


Display help information in a popup Help dialog
SHOWHELP

 

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

Advertisements