UNDERSTAND REMOTE CLIENT
Inside server, you can use all functions VX+ support to design projects for remote client.
However, VX+ also support some more functions for remote client. Example following some function like:
Functions client used after do this steps Settings webserver on Server
and you need signup VX+ for created a Account and a Password.
This register permission for you can connect to server for extract get data or change data in server.
Suntax
html('<tag alias=[aliasname] ; fieldname=[list field] ; value=[=expression] ; q?=[expression condision]; record=[recno] ; >')
Where:
[aliasname]: alias of open table in server
[list field]: list field name of alias opened table in server, like: fieldname1,fieldname2,...
[=expression] : return expression value.
[expression condision]: scope record to extract data from alias opened table in server
[recno] - start [recnumber] to last record.
* Don't used mark " or ' in tag html.
Example following is true:
? html('<select alias=province;fieldlist=code,province,area;value?=code+province;q?=area>=0;>')
Example following is false:
? html('<select alias="province";fieldlist="code,province,area";value?=code+province;q?=area>=0;>')
* You need uses [quot] or " instead of mark ".
* Warning: & replaced with [amp], " repalced with [quot], % replaced with [perc], + with [plus] in javascript functions.
1. None database Function:
Display href :
? html( '< a href=function.htm; / >')
Run a expression (1+2) of VX+ on server:
? html('<src q?=1+2;/>')
3
* You can run any function VX+ in server from client by javascript and it return a value, like:
var result=commandLineA('=function','objectname')
Or
var result=commandLineA('=function','divname')
or functions html VX+, see HTML function.
2. Database Function:
2.1 Extract data from server
Get field value:
? html("<getfield alias=demo;fieldname=memo;/>")
or
? html("<getfield fieldname=demo.memo;/>")
Get value for tag select option html. It used tag select html
Following example will get [field value:code,provice,area] from table [province] start record [1] for condision [area>=0] :
? html('<select alias=province;fieldlist=code,province,area;value?=code+province;q?=area>=0;record=1;>')
<option value="24HA NOI CITY"> 24,HA NOI CITY,3300 </option>
<option value="28HO CHI MINH CITY"> 28,HO CHI MINH CITY,2000 </option>
<option value="272LONG AN"> 272,LONG AN ,4500 </option>
<option value="273TIEN GIANG"> 273,TIEN GIANG,2500 </option>
Get value text for tag jtext.
Following example will get [field value:code,provice,area] from table [province] all record for field [area>=0] :
? html('<jtext alias=province;fieldlist=code,province,area;q?=area>=3300;>')
24,HA NOI CITY,3300
272,LONG AN ,4500
Get value text for tag json.
Following example will get [field value:code,provice,area] from table [province] all record for field [area>=0] :
? html('<json alias=province;fieldlist=code,province,area;q?=area>=0;>')
{"PROVINCE":[{"CODE":"24","PROVINCE":"HA NOI CITY","AREA":"3300"},{"CODE":"272","PROVINCE":"LONG AN ","AREA":"4500"}]}
Get table html for tag jtable.
Following example will get [field value:code,provice,area] from table [province] all record for field [area>=0] :
? html('<jtable alias=province;fieldlist=code,province,area;value==code+province;q?=area>=0;>')
PROVINCE
| CODE | PROVINCE | AREA |
|---|
| 24 | HA NOI CITY | 3300 |
|---|
|
| 272 | LONG AN | 4500 |
|---|
|
To see more used html function in side remote client
Example used Functions inside client
Remote Javasvript function