Database: Lviews
Path: C:\VFE7\VFEDEVCON2K2-REPORTS&SECURITY\DATA\LVIEWS.DBC
Version: 10
Local View: Accountsreceivableview
Parameters: vp_dAsOf,'D';vp_cCustomer_Id,'C'
Update Type: Read-Only
SQL:
SELECT Customer.ccustomer_id, Customer.ccompany,;
Padr(trim(customer.cfirst_name) + " " +;
Customer.clast_name,40) As Cname, Customer.caddress,;
Padr(trim(customer.ccity) + ",;
" + Trim(customer.cregion) + " " + Trim(customer.cpostal_code) +;
" " + Customer.ccountry,60) As Clocation,;
Ordertotalsview.corder_id, Ordertotalsview.dordered,;
Sum(yfreight) As Yfreight, Sum(yamount) As Yamount,;
Sum(ypaid) As Ypaid, Sum(yamount + Yfreight - Ypaid) As Ybalance;
FROM Lviews!ordertotalsview;
Join Sample!customer;
ON Ordertotalsview.ccustomer_id = Customer.ccustomer_id;
GROUP BY 6;
ORDER BY 1, 7, 6;
HAVING Sum(yamount + Yfreight - Ypaid) > 0
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Index Tag |
Look Up Display Fields |
Look Up Update Expression |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
vp_ccustomer_id |
C(6) |
Vp Ccustomer Id View Parameter |
Customer Id |
Customer Id |
Customer Id |
Customer Id |
cid |
cname |
Customerlookupview.ccustomer_id |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_dasof |
D |
Vp Dasof View Parameter |
Asof |
Asof |
Asof |
Asof |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
ccustomer_id |
C(6) |
Customer # |
Customer # |
.T. |
Ccustomer Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CCUSTOMER_ID |
.F. |
Customer # |
3 |
Customer # |
Customer # |
Customer # |
|
ccompany |
C(40) |
Company |
Company |
.T. |
Ccompany Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CCOMPANY |
.T. |
Company |
2 |
Company |
Company |
Company |
|
cname |
C(40) |
Name |
Name |
.T. |
Cname Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CNAME |
.F. |
Name |
3 |
Name |
Name |
Name |
|
caddress |
C(60) |
Address |
Address |
.T. |
Caddress Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CADDRESS |
.T. |
Address |
4 |
Address |
Address |
Address |
|
clocation |
C(60) |
Location |
Location |
.T. |
Clocation Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CLOCATION |
.F. |
Location |
5 |
Location |
Location |
Location |
|
corder_id |
C(6) |
Order # |
Order # |
.T. |
Corder Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CORDER_ID |
.F. |
Order # |
1 |
Order # |
Order # |
Order # |
|
dordered |
D |
Ordered |
Ordered |
.T. |
Dordered Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
DORDERED |
.F. |
Date Ordered |
2 |
Ordered |
Ordered |
Ordered |
|
yfreight |
Y |
Freight |
Freight |
.T. |
Yfreight Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
YFREIGHT |
.F. |
Freight |
4 |
Freight |
Freight |
Freight |
|
yamount |
Y |
Amount |
Amount |
.T. |
Yamount Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
LVIEWS!ORDERTOTALSVIEW.YAMOUNT |
.T. |
Amount |
5 |
Amount |
Amount |
Amount |
|
ypaid |
Y |
Paid |
Paid |
.T. |
Ypaid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
LVIEWS!ORDERTOTALSVIEW.YPAID |
.T. |
Paid |
6 |
Paid |
Paid |
Paid |
|
ybalance |
Y |
Balance |
Balance |
.T. |
Ybalance Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
YBALANCE |
.F. |
Balance |
11 |
Balance |
Balance |
Balance |
Parameters: vp_startDAte,'D';vp_enddate,'D'
Update Type: Read-Only
SQL:
SELECT Calendar.tscheduled, Daysofmonth.gtemp As Gitem,;
Calendar.cuserid, Calendar.cdescription, Calendar.ctype,;
Space(40) As Ctypeicon;
FROM Sample!calendar;
Join Sample!daysofmonth;
ON Daysofmonth.nday = Day(calendar.tscheduled);
WHERE Between(ttod(calendar.tscheduled),?vp_startdate ,?vp_enddate);
ORDER BY 1
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
vp_enddate |
D |
Vp Enddate View Parameter |
To |
To |
To |
To |
[DEFAULT] |
iviewparameter |
ILIBS\idata.vcx |
itxtdate |
ILIBS\ISTDTXT.VCX |
|
vp_startdate |
D |
Vp Startdate View Parameter |
From |
From |
From |
From |
[DEFAULT] |
iviewparameter |
ILIBS\idata.vcx |
itxtdate |
ILIBS\ISTDTXT.VCX |
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
tscheduled |
T |
Scheduled |
Scheduled |
.T. |
Tscheduled Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.TSCHEDULED |
.T. |
Scheduled |
1 |
Scheduled |
Scheduled |
Scheduled |
|
gitem |
G |
Item |
Item |
.F. |
Gitem Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ioleboundcontrol |
ILIBS\ICONTRLS.VCX |
.F. |
None |
GITEM |
.F. |
Item |
5 |
Item |
Item |
Item |
|
cuserid |
C(40) |
Userid |
Userid |
.T. |
Cuserid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CUSERID |
.T. |
Userid |
6 |
Userid |
Userid |
Userid |
|
cdescription |
C(50) |
Description |
Description |
.T. |
Cdescription Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CDESCRIPTION |
.T. |
Description |
7 |
Description |
Description |
Description |
|
ctype |
C(3) |
Type |
Type |
.T. |
Ctype Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CTYPE |
.T. |
Type |
9 |
Type |
Type |
Type |
|
ctypeicon |
C(40) |
Typeicon |
Typeicon |
.T. |
Ctypeicon Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CTYPEICON |
.F. |
Typeicon |
6 |
Typeicon |
Typeicon |
Typeicon |
Update Type: Key Field
SQL:
SELECT Calendar.cpk_calendar, Calendar.tscheduled,;
Calendar.cuserid, Calendar.cdescription, Calendar.mcomments,;
Calendar.ctype;
FROM "sample!calendar"
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
cpk_calendar |
CB(16) |
Pk Calendar |
Pk Calendar |
.T. |
Cpk Calendar Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CPK_CALENDAR |
.T. |
Pk Calendar |
1 |
Pk Calendar |
Pk Calendar |
Pk Calendar |
|
tscheduled |
T |
Scheduled |
Scheduled |
.T. |
Tscheduled Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.TSCHEDULED |
.T. |
Scheduled |
2 |
Scheduled |
Scheduled |
Scheduled |
|
cuserid |
C(40) |
Userid |
Userid |
.T. |
Cuserid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CUSERID |
.T. |
Userid |
3 |
Userid |
Userid |
Userid |
|
cdescription |
C(50) |
Description |
Description |
.T. |
Cdescription Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CDESCRIPTION |
.T. |
Description |
4 |
Description |
Description |
Description |
|
mcomments |
M |
Comments |
Comments |
.F. |
Mcomments Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ieditbox |
ILIBS\ICONTRLS.VCX |
.F. |
None |
SAMPLE!CALENDAR.MCOMMENTS |
.T. |
Comments |
5 |
Comments |
Comments |
Comments |
|
ctype |
C(3) |
Type |
Type |
.T. |
Ctype Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CTYPE |
.T. |
Type |
6 |
Type |
Type |
Type |
Update Type: Key Field
SQL:
SELECT Calendar.cpk_calendar, Calendar.tscheduled, Calendar.cuserid,;
Calendar.cdescription, Calendar.ctype, Category.*;
FROM "sample!calendar";
Join Category;
ON .t.
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
cpk_calendar |
CB(16) |
Pk Calendar |
Pk Calendar |
.T. |
Cpk Calendar Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CPK_CALENDAR |
.T. |
Pk Calendar |
1 |
Pk Calendar |
Pk Calendar |
Pk Calendar |
|
tscheduled |
T |
Scheduled |
Scheduled |
.T. |
Tscheduled Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.TSCHEDULED |
.T. |
Scheduled |
2 |
Scheduled |
Scheduled |
Scheduled |
|
cuserid |
C(40) |
Userid |
Userid |
.T. |
Cuserid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CUSERID |
.T. |
Userid |
3 |
Userid |
Userid |
Userid |
|
cdescription |
C(50) |
Description |
Description |
.T. |
Cdescription Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CDESCRIPTION |
.T. |
Description |
4 |
Description |
Description |
Description |
|
ctype |
C(3) |
Type |
Type |
.T. |
Ctype Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CALENDAR.CTYPE |
.T. |
Type |
6 |
Type |
Type |
Type |
|
ccategoryid |
C(6) |
Categoryid |
Categoryid |
.T. |
Ccategoryid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CATEGORY.CCATEGORYID |
.F. |
Categoryid |
6 |
Categoryid |
Categoryid |
Categoryid |
|
cname |
C(25) |
Name |
Name |
.T. |
Cname Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CATEGORY.CNAME |
.T. |
Name |
7 |
Name |
Name |
Name |
|
mdescription |
M |
Description |
Description |
.F. |
Mdescription Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ieditbox |
ILIBS\ICONTRLS.VCX |
.F. |
None |
CATEGORY.MDESCRIPTION |
.T. |
Description |
8 |
Description |
Description |
Description |
|
gpicture |
G |
Picture |
Picture |
.F. |
Gpicture Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ioleboundcontrol |
ILIBS\ICONTRLS.VCX |
.F. |
None |
CATEGORY.GPICTURE |
.T. |
Picture |
9 |
Picture |
Picture |
Picture |
Update Type: Read-Only
SQL:
SELECT Category.ccategoryid, Category.cname;
FROM Sample!category;
ORDER BY Category.cname
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
ccategoryid |
C(6) |
Category Id |
Category Id |
.T. |
Ccategoryid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CATEGORY.CCATEGORYID |
.F. |
Category Id |
1 |
Category Id |
Category Id |
Category Id |
|
cname |
C(25) |
Name |
Name |
.T. |
Cname Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CATEGORY.CNAME |
.T. |
Name |
2 |
Name |
Name |
Name |
|
Tag |
Expression |
Display Order |
Tag Caption |
Description |
Display |
|
name (R) |
CNAME |
1 |
Name |
Name Index |
.T. |
Parameters: vp_cCategoryid,'C'
Update Type: Key and Modified
SQL:
SELECT Category.ccategoryid, Category.cname, Category.gpicture,;
Category.mdescription;
FROM Sample!category;
WHERE Category.ccategoryid Like ?vp_ccategoryid
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
vp_ccategoryid |
C(6) |
Vp Ccategoryid View Parameter |
Category Id |
Category Id |
Category Id |
Category Id |
[DEFAULT] |
categoryviewcategoryidparameter |
c:\vfe6\sample\libs\abhavior.vcx |
itextbox |
ILIBS\ICONTRLS.VCX |
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Search Index Tag |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
ccategoryid |
C(6) |
Category Id |
.F. |
Ccategoryid Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CATEGORY.CCATEGORYID |
.T. |
Category Id |
1 |
Category Id |
Category Id |
Category Id |
||
|
cname |
C(25) |
Name |
Name |
.T. |
Cname Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
name |
None |
SAMPLE!CATEGORY.CNAME |
.T. |
Name |
2 |
Name |
Name |
Name |
|
gpicture |
G |
Picture |
Picture |
.F. |
Gpicture Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ioleboundcontrol |
ILIBS\ICONTRLS.VCX |
.F. |
None |
SAMPLE!CATEGORY.GPICTURE |
.T. |
Picture |
4 |
Picture |
Picture |
Picture |
|
|
mdescription |
M |
Description |
Description |
.F. |
Mdescription Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ieditbox |
ILIBS\ICONTRLS.VCX |
.F. |
None |
SAMPLE!CATEGORY.MDESCRIPTION |
.T. |
Description |
3 |
Description |
Description |
Description |
|
Tag |
Expression |
Display Order |
Tag Caption |
Description |
Display |
|
name (R) |
UPPER(CNAME) |
1 |
Name |
Name Index |
.T. |
Local View: Currentlogins_view
Update Type: Key Field
SQL:
SELECT Currentlogins.cuserid, Currentlogins.tlogin,;
Currentlogins.tlogout, Currentlogins.cmachine, Currentlogins.cid;
FROM "sample!currentlogins";
WHERE Currentlogins.cuserid!=' '
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
cuserid |
C(30) |
Userid |
Userid |
.T. |
Cuserid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CURRENTLOGINS.CUSERID |
.T. |
Userid |
1 |
Userid |
Userid |
Userid |
|
tlogin |
T |
Login |
Login |
.T. |
Tlogin Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CURRENTLOGINS.TLOGIN |
.T. |
Login |
2 |
Login |
Login |
Login |
|
tlogout |
T |
Logout |
Logout |
.T. |
Tlogout Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CURRENTLOGINS.TLOGOUT |
.T. |
Logout |
3 |
Logout |
Logout |
Logout |
|
cmachine |
C(100) |
Machine |
Machine |
.T. |
Cmachine Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CURRENTLOGINS.CMACHINE |
.T. |
Machine |
4 |
Machine |
Machine |
Machine |
|
cid |
CB(16) |
Id |
Id |
.T. |
Cid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CURRENTLOGINS.CID |
.T. |
Id |
5 |
Id |
Id |
Id |
Local View: Customerlookupview
Update Type: Read-Only
SQL:
SELECT Customer.ccustomer_id,;
Iif(empty(customer.ccompany),trim(customer.clast_name) + "," +;
Customer.cfirst_name, Customer.ccompany) As Cname;
FROM Sample!customer
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Search Index Tag |
Default Type |
Update Name |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
ccustomer_id |
C(6) |
Customer Id |
Customer Id |
.T. |
Ccustomer Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
cid |
None |
SAMPLE!CUSTOMER.CCUSTOMER_ID |
Customer Id |
1 |
Customer Id |
Customer Id |
Customer Id |
|
cname |
C(40) |
Name |
Name |
.T. |
Cname Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
name |
None |
Name |
2 |
Name |
Name |
Name |
|
Tag |
Expression |
Display Order |
Tag Caption |
Description |
Display |
|
cid (R) |
UPPER(CCUSTOMER_ID) |
1 |
Id |
Cid Index |
.T. |
|
name (R) |
UPPER(CNAME) |
1 |
Name |
Name Index |
.T. |
Parameters: vp_cCompany,'C';vp_cLast_name,'C';vp_cCity,'C';vp_cRegion,'C';vp_cCountry,'C';vp_cPostal_Code,'C';vp_cCustomer_Id,'C'
Update Type: Key and Modified
SQL:
SELECT Customer.ccustomer_id, Customer.ccompany,;
Customer.cfirst_name, Customer.clast_name, Customer.ctitle,;
Customer.caddress, Customer.ccity, Customer.cregion,;
Customer.cpostal_code, Customer.ccountry, Customer.cphone,;
Customer.cfax, Customer.cemail, Customer.ymax_order_amt,;
Customer.ymin_order_amt, Customer.ndiscount,;
Customer.csales_region, Customer.ntype, Customer.mnotes,;
Customer.csecurityname;
FROM Sample!customer;
WHERE Customer.ccompany Like ?vp_ccompany And Customer.clast_name;
Like ?vp_clast_name And Customer.ccity Like ?vp_ccity And;
Customer.cregion Like ?vp_cregion And Customer.ccountry Like;
?vp_ccountry And Customer.cpostal_code = ?vp_cpostal_code And;
Customer.ccustomer_id Like ?vp_ccustomer_id
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
vp_ccity |
C(15) |
Vp Ccity View Parameter |
City |
City |
City |
City |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_ccompany |
C(40) |
Vp Ccompany View Parameter |
Company |
Company |
Company |
Company |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_ccountry |
C(15) |
Vp Ccountry View Parameter |
Country |
Country |
Country |
Country |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_ccustomer_id |
C(6) |
Vp Ccustomer Id View Parameter |
Customer Id |
Customer Id |
Customer Id |
Customer Id |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_clast_name |
C(20) |
Vp Clast Name View Parameter |
Last Name |
Last Name |
Last Name |
Last Name |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_cpostal_code |
C(10) |
Vp Cpostal Code View Parameter |
Postal Code |
Postal Code |
Postal Code |
Postal Code |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_cregion |
C(15) |
Vp Cregion View Parameter |
Region |
Region |
Region |
Region |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Update Expression |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Search Index Tag |
Default Expression |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Security Name |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
Look Up Type |
Look Up Display Fields |
Look Up Cursor |
Look Up Index Tag |
|
ccustomer_id |
C(6) |
Customer Id |
Customer Id |
.T. |
Ccustomer Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
cid |
None |
SAMPLE!CUSTOMER.CCUSTOMER_ID |
.T. |
Customer Id |
1 |
Customer Id |
Customer Id |
Customer Id |
None (Default) |
||||||
|
ccompany |
C(40) |
Company |
Company |
.T. |
Ccompany Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
company |
None |
SAMPLE!CUSTOMER.CCOMPANY |
.T. |
Company |
2 |
Company |
Company |
Company |
None (Default) |
||||||
|
cfirst_name |
C(20) |
First Name |
First Name |
.T. |
Cfirst Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CFIRST_NAME |
.T. |
First Name |
3 |
First Name |
First Name |
First Name |
None (Default) |
|||||||
|
clast_name |
C(20) |
Last Name |
Last Name |
.T. |
Clast Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
lastname |
None |
SAMPLE!CUSTOMER.CLAST_NAME |
.T. |
Last Name |
4 |
Last Name |
Last Name |
Last Name |
None (Default) |
||||||
|
ctitle |
C(40) |
Title |
Title |
.T. |
Ctitle Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CTITLE |
.T. |
Title |
5 |
Title |
Title |
Title |
None (Default) |
|||||||
|
caddress |
C(60) |
Address |
Address |
.T. |
Caddress Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CADDRESS |
.T. |
Address |
6 |
Address |
Address |
Address |
None (Default) |
|||||||
|
ccity |
C(15) |
City |
City |
.T. |
Ccity Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
city |
None |
SAMPLE!CUSTOMER.CCITY |
.T. |
City |
7 |
City |
City |
City |
None (Default) |
||||||
|
cregion |
C(15) |
Region |
Region |
.T. |
Cregion Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
region |
None |
SAMPLE!CUSTOMER.CREGION |
.T. |
Region |
8 |
Region |
Region |
Region |
None (Default) |
||||||
|
cpostal_code |
C(10) |
Postal Code |
Postal Code |
.T. |
Cpostal Code Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CPOSTAL_CODE |
.T. |
Postal Code |
9 |
Postal Code |
Postal Code |
Postal Code |
None (Default) |
|||||||
|
ccountry |
C(15) |
Country |
Country |
.T. |
Ccountry Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
country |
'USA' |
Expression |
SAMPLE!CUSTOMER.CCOUNTRY |
.T. |
Country |
10 |
Country |
Country |
Country |
None (Default) |
|||||
|
cphone |
C(24) |
Phone |
Phone |
.T. |
Cphone Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CPHONE |
.T. |
Phone |
VFE DevCon Example |
11 |
Phone |
Phone |
Phone |
None (Default) |
||||||
|
cfax |
C(24) |
Fax |
Fax |
.T. |
Cfax Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CFAX |
.T. |
Fax |
VFE DevCon Example |
12 |
Fax |
Fax |
Fax |
None (Default) |
||||||
|
cemail |
C(40) |
|
|
.T. |
Cemail Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CEMAIL |
.T. |
|
VFE DevCon Example |
13 |
|
|
|
None (Default) |
||||||
|
ymax_order_amt |
Y |
Max Order Amt |
Max Order Amt |
.T. |
Ymax Order Amt Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
5000.00 |
Expression |
SAMPLE!CUSTOMER.YMAX_ORDER_AMT |
.T. |
Max Order Amt |
Maximum Order Amount |
14 |
Max Order Amt |
Max Order Amt |
Max Order Amt |
None (Default) |
|||||
|
ymin_order_amt |
Y |
Min Order Amt |
Min Order Amt |
.T. |
Ymin Order Amt Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
500.00 |
Expression |
SAMPLE!CUSTOMER.YMIN_ORDER_AMT |
.T. |
Min Order Amt |
15 |
Min Order Amt |
Min Order Amt |
Min Order Amt |
None (Default) |
||||||
|
ndiscount |
N(2) |
Discount |
Discount |
.T. |
Ndiscount Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.NDISCOUNT |
.T. |
Discount |
16 |
Discount |
Discount |
Discount |
None (Default) |
|||||||
|
csales_region |
C(4) |
Sales Region |
Sales Region |
.T. |
Csales Region Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CSALES_REGION |
.T. |
Sales Region |
17 |
Sales Region |
Sales Region |
Sales Region |
None (Default) |
|||||||
|
ntype |
N(1) |
Type |
Type |
.T. |
Ntype Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.NTYPE |
.T. |
Type |
19 |
Type |
Type |
Type |
None (Default) |
|||||||
|
mnotes |
M |
Notes |
Notes |
.F. |
Mnotes Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ieditbox |
ILIBS\ICONTRLS.VCX |
.F. |
None |
SAMPLE!CUSTOMER.MNOTES |
.T. |
Notes |
18 |
Notes |
Notes |
Notes |
None (Default) |
|||||||
|
csecurityname |
C(40) |
Security |
Security |
.T. |
Csecurityname Field |
.T. |
Appnames.cname |
[NONE] |
iField |
ILIBS\IDATA.VCX |
icombobox |
ILIBS\icontrls.vcx |
.T. |
None |
SAMPLE!CUSTOMER.CSECURITYNAME |
.T. |
Security |
20 |
Security |
Security |
Security |
Field |
cname |
fesys!appnames |
cname |
|
Tag |
Expression |
Display Order |
Tag Caption |
Description |
Display |
|
cid (R) |
UPPER(CCUSTOMER_ID) |
1 |
Customer Id |
Cid Index |
.T. |
|
company (R) |
UPPER(CCOMPANY) |
1 |
Company |
Company Index |
.T. |
|
lastname (R) |
UPPER(CLAST_NAME) |
1 |
Last Name |
Lastname Index |
.T. |
|
city (R) |
UPPER(CCITY) |
1 |
City |
City Index |
.T. |
|
region (R) |
UPPER(CREGION) |
1 |
Region |
Region Index |
.T. |
|
country (R) |
UPPER(CCOUNTRY) |
1 |
Country |
Country Index |
.T. |
Local View: Customersview_devcon
Parameters: vp_cCompany,'C';vp_cLast_name,'C';vp_cCity,'C';vp_cRegion,'C';vp_cCountry,'C';vp_cPostal_Code,'C';vp_cCustomer_Id,'C'
Update Type: Key and Modified
SQL:
SELECT Customer.ccustomer_id, Customer.ccompany,;
Customer.cfirst_name, Customer.clast_name, Customer.ctitle,;
Customer.caddress, Customer.ccity, Customer.cregion,;
Customer.cpostal_code, Customer.ccountry, Customer.cphone,;
Customer.cfax, Customer.cemail, Customer.ymax_order_amt,;
Customer.ymin_order_amt, Customer.ndiscount,;
Customer.csales_region, Customer.ntype, Customer.mnotes,;
Customer.csecurityname;
FROM Sample!customer;
WHERE Customer.ccompany Like ?vp_ccompany And Customer.clast_name;
Like ?vp_clast_name And Customer.ccity Like ?vp_ccity And;
Customer.cregion Like ?vp_cregion And Customer.ccountry Like;
?vp_ccountry And Customer.cpostal_code = ?vp_cpostal_code And;
Customer.ccustomer_id Like ?vp_ccustomer_id
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
vp_ccity |
C(15) |
Vp Ccity View Parameter |
City |
City |
City |
City |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_ccompany |
C(40) |
Vp Ccompany View Parameter |
Company |
Company |
Company |
Company |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_ccountry |
C(15) |
Vp Ccountry View Parameter |
Country |
Country |
Country |
Country |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_ccustomer_id |
C(6) |
Vp Ccustomer Id View Parameter |
Customer Id |
Customer Id |
Customer Id |
Customer Id |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_clast_name |
C(20) |
Vp Clast Name View Parameter |
Last Name |
Last Name |
Last Name |
Last Name |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_cpostal_code |
C(10) |
Vp Cpostal Code View Parameter |
Postal Code |
Postal Code |
Postal Code |
Postal Code |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_cregion |
C(15) |
Vp Cregion View Parameter |
Region |
Region |
Region |
Region |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Update Expression |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Expression |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Security Name |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
Look Up Type |
Look Up Display Fields |
Look Up Cursor |
Look Up Index Tag |
|
ccustomer_id |
C(6) |
Customer Id |
Customer Id |
.T. |
Ccustomer Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CCUSTOMER_ID |
.T. |
Customer Id |
1 |
Customer Id |
Customer Id |
Customer Id |
None (Default) |
||||||
|
ccompany |
C(40) |
Company |
Company |
.T. |
Ccompany Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CCOMPANY |
.T. |
Company |
2 |
Company |
Company |
Company |
None (Default) |
||||||
|
cfirst_name |
C(20) |
First Name |
First Name |
.T. |
Cfirst Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CFIRST_NAME |
.T. |
First Name |
3 |
First Name |
First Name |
First Name |
None (Default) |
||||||
|
clast_name |
C(20) |
Last Name |
Last Name |
.T. |
Clast Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CLAST_NAME |
.T. |
Last Name |
4 |
Last Name |
Last Name |
Last Name |
None (Default) |
||||||
|
ctitle |
C(40) |
Title |
Title |
.T. |
Ctitle Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CTITLE |
.T. |
Title |
5 |
Title |
Title |
Title |
None (Default) |
||||||
|
caddress |
C(60) |
Address |
Address |
.T. |
Caddress Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CADDRESS |
.T. |
Address |
6 |
Address |
Address |
Address |
None (Default) |
||||||
|
ccity |
C(15) |
City |
City |
.T. |
Ccity Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CCITY |
.T. |
City |
7 |
City |
City |
City |
None (Default) |
||||||
|
cregion |
C(15) |
Region |
Region |
.T. |
Cregion Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CREGION |
.T. |
Region |
8 |
Region |
Region |
Region |
None (Default) |
||||||
|
cpostal_code |
C(10) |
Postal Code |
Postal Code |
.T. |
Cpostal Code Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CPOSTAL_CODE |
.T. |
Postal Code |
9 |
Postal Code |
Postal Code |
Postal Code |
None (Default) |
||||||
|
ccountry |
C(15) |
Country |
Country |
.T. |
Ccountry Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
'USA' |
Expression |
SAMPLE!CUSTOMER.CCOUNTRY |
.T. |
Country |
10 |
Country |
Country |
Country |
None (Default) |
|||||
|
cphone |
C(24) |
Phone |
Phone |
.T. |
Cphone Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CPHONE |
.T. |
Phone |
VFE DevCon Example |
11 |
Phone |
Phone |
Phone |
None (Default) |
|||||
|
cfax |
C(24) |
Fax |
Fax |
.T. |
Cfax Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CFAX |
.T. |
Fax |
VFE DevCon Example |
12 |
Fax |
Fax |
Fax |
None (Default) |
|||||
|
cemail |
C(40) |
|
|
.T. |
Cemail Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CEMAIL |
.T. |
|
VFE DevCon Example |
13 |
|
|
|
None (Default) |
|||||
|
ymax_order_amt |
Y |
Max Order Amt |
Max Order Amt |
.T. |
Ymax Order Amt Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
5000.00 |
Expression |
SAMPLE!CUSTOMER.YMAX_ORDER_AMT |
.T. |
Max Order Amt |
Maximum Order Amount |
14 |
Max Order Amt |
Max Order Amt |
Max Order Amt |
None (Default) |
||||
|
ymin_order_amt |
Y |
Min Order Amt |
Min Order Amt |
.T. |
Ymin Order Amt Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
500.00 |
Expression |
SAMPLE!CUSTOMER.YMIN_ORDER_AMT |
.T. |
Min Order Amt |
15 |
Min Order Amt |
Min Order Amt |
Min Order Amt |
None (Default) |
|||||
|
ndiscount |
N(2) |
Discount |
Discount |
.T. |
Ndiscount Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.NDISCOUNT |
.T. |
Discount |
16 |
Discount |
Discount |
Discount |
None (Default) |
||||||
|
csales_region |
C(4) |
Sales Region |
Sales Region |
.T. |
Csales Region Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CSALES_REGION |
.T. |
Sales Region |
17 |
Sales Region |
Sales Region |
Sales Region |
None (Default) |
||||||
|
ntype |
N(1) |
Type |
Type |
.T. |
Ntype Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.NTYPE |
.T. |
Type |
19 |
Type |
Type |
Type |
None (Default) |
||||||
|
mnotes |
M |
Notes |
Notes |
.F. |
Mnotes Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ieditbox |
ILIBS\ICONTRLS.VCX |
.F. |
None |
SAMPLE!CUSTOMER.MNOTES |
.T. |
Notes |
18 |
Notes |
Notes |
Notes |
None (Default) |
||||||
|
csecurityname |
C(40) |
Security |
Security |
.T. |
Csecurityname Field |
.T. |
Appnames.cname |
[NONE] |
iField |
ILIBS\IDATA.VCX |
icombobox |
ILIBS\icontrls.vcx |
.T. |
None |
SAMPLE!CUSTOMER.CSECURITYNAME |
.T. |
Security |
20 |
Security |
Security |
Security |
Field |
cname |
fesys!appnames |
cname |
Local View: Employeelookupview
Update Type: Read-Only
SQL:
SELECT Employee.cemployee_id, Padr(trim( Employee.clast_name) +", " +;
Employee.cfirst_name, 32) As Cname;
FROM Sample!employee;
ORDER BY 2
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
cemployee_id |
C(6) |
Employee Id |
Employee Id |
.T. |
Cemployee Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!EMPLOYEE.CEMPLOYEE_ID |
Employee Id |
1 |
Employee Id |
Employee Id |
Employee Id |
|
cname |
C(32) |
Name |
Name |
.T. |
Cname Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
Name |
2 |
Name |
Name |
Name |
Update Type: Key and Modified
SQL:
SELECT Employee.cemployee_id, Employee.clast_name,;
Employee.cfirst_name, Employee.ctitle, Employee.dbirth_date,;
Employee.dhire_date, Employee.caddress, Employee.ccity,;
Employee.cregion, Employee.cpostal_code, Employee.ccountry,;
Employee.chome_phone, Employee.cextension, Employee.csales_region,;
Employee.gphoto, Employee.mnotes;
FROM Sample!employee;
ORDER BY Employee.clast_name, Employee.cfirst_name
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Value Required |
Allow Quick Find |
Search Index Tag |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
cemployee_id |
C(6) |
Employee Id |
Employee Id |
.T. |
Cemployee Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
employeeid |
None |
SAMPLE!EMPLOYEE.CEMPLOYEE_ID |
.T. |
Employee Id |
1 |
Employee Id |
Employee Id |
Employee Id |
|
clast_name |
C(20) |
Last Name |
Last Name |
.T. |
Clast Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
.T. |
last_name |
None |
SAMPLE!EMPLOYEE.CLAST_NAME |
.T. |
Last Name |
2 |
Last Name |
Last Name |
Last Name |
|
cfirst_name |
C(10) |
First Name |
First Name |
.T. |
Cfirst Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
.T. |
first_name |
None |
SAMPLE!EMPLOYEE.CFIRST_NAME |
.T. |
First Name |
3 |
First Name |
First Name |
First Name |
|
ctitle |
C(30) |
Title |
Title |
.T. |
Ctitle Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
.T. |
None |
SAMPLE!EMPLOYEE.CTITLE |
.T. |
Title |
4 |
Title |
Title |
Title |
|
|
dbirth_date |
D |
Birth Date |
Birth Date |
.T. |
Dbirth Date Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.DBIRTH_DATE |
.T. |
Birth Date |
5 |
Birth Date |
Birth Date |
Birth Date |
|
|
dhire_date |
D |
Hire Date |
Hire Date |
.T. |
Dhire Date Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
.T. |
hiredate |
None |
SAMPLE!EMPLOYEE.DHIRE_DATE |
.T. |
Hire Date |
6 |
Hire Date |
Hire Date |
Hire Date |
|
caddress |
C(60) |
Address |
Address |
.T. |
Caddress Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.CADDRESS |
.T. |
Address |
7 |
Address |
Address |
Address |
|
|
ccity |
C(15) |
City |
City |
.T. |
Ccity Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.CCITY |
.T. |
City |
8 |
City |
City |
City |
|
|
cregion |
C(15) |
Region |
Region |
.T. |
Cregion Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.CREGION |
.T. |
Region |
9 |
Region |
Region |
Region |
|
|
cpostal_code |
C(10) |
Postal Code |
Postal Code |
.T. |
Cpostal Code Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.CPOSTAL_CODE |
.T. |
Postal Code |
10 |
Postal Code |
Postal Code |
Postal Code |
|
|
ccountry |
C(15) |
Country |
Country |
.T. |
Ccountry Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.CCOUNTRY |
.T. |
Country |
11 |
Country |
Country |
Country |
|
|
chome_phone |
C(24) |
Home Phone |
Home Phone |
.T. |
Chome Phone Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.CHOME_PHONE |
.T. |
Home Phone |
12 |
Home Phone |
Home Phone |
Home Phone |
|
|
cextension |
C(4) |
Extension |
Extension |
.T. |
Cextension Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.CEXTENSION |
.T. |
Extension |
13 |
Extension |
Extension |
Extension |
|
|
csales_region |
C(4) |
Sales Region |
Sales Region |
.T. |
Csales Region Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!EMPLOYEE.CSALES_REGION |
.T. |
Sales Region |
14 |
Sales Region |
Sales Region |
Sales Region |
|
|
gphoto |
G |
Photo |
Photo |
.F. |
Gphoto Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ioleboundcontrol |
ILIBS\ICONTRLS.VCX |
.F. |
.F. |
None |
SAMPLE!EMPLOYEE.GPHOTO |
.T. |
Photo |
16 |
Photo |
Photo |
Photo |
|
|
mnotes |
M |
Notes |
Notes |
.F. |
Mnotes Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ieditbox |
ILIBS\ICONTRLS.VCX |
.F. |
.F. |
None |
SAMPLE!EMPLOYEE.MNOTES |
.T. |
Notes |
15 |
Notes |
Notes |
Notes |
|
Tag |
Expression |
Display Order |
Tag Caption |
Description |
Display |
|
last_name (R) |
UPPER(CLAST_NAME) |
1 |
Last Name |
Last Name Index |
.T. |
|
first_name (R) |
UPPER(CFIRST_NAME) |
1 |
First Name |
First Name Index |
.T. |
|
employeeid (R) |
CEMPLOYEE_ID |
1 |
Employee Id |
Employeeid Index |
.T. |
|
hiredate (R) |
DHIRE_DATE |
1 |
Hire Date |
Hiredate Index |
.T. |
Update Type: Read-Only
SQL:
SELECT Aforms.ccaption, Aforms.cclass, Aforms.csecurity, Aforms.cicon;
FROM Sample!aforms;
ORDER BY Aforms.ccaption
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
ccaption |
C(50) |
Caption |
Caption |
.T. |
Ccaption Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!AFORMS.CCAPTION |
.T. |
Caption |
1 |
Caption |
Caption |
Caption |
|
cclass |
C(80) |
Class |
Class |
.T. |
Cclass Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!AFORMS.CCLASS |
.T. |
Class |
2 |
Class |
Class |
Class |
|
csecurity |
C(40) |
Security |
Security |
.T. |
Csecurity Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!AFORMS.CSECURITY |
.T. |
Security |
4 |
Security |
Security |
Security |
|
cicon |
C(20) |
Icon |
Icon |
.T. |
Cicon Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!AFORMS.CICON |
.T. |
Icon |
3 |
Icon |
Icon |
Icon |
Update Type: Read-Only
SQL:
SELECT Orders.corder_id, Orders.ccustomer_id, Orders.dordered,;
Orders.cship_to_name, Orders.cship_to_address,;
Padr( Trim(orders.cship_to_city) + ",;
" + Trim(orders.cship_to_region) + " " +;
Trim(orders.cship_to_postal_code) + " " +;
Orders.cship_to_country ,60) As Cship_to, Orders.ndiscount,;
Orders.yfreight, Orders.ddeliver_by, Customer.ccompany,;
Padr(trim(customer.cfirst_name) + " " +;
Customer.clast_name,40) As Cname, Customer.ctitle,;
Customer.caddress, Padr( Trim(customer.ccity) + ", " +;
Trim(customer.cregion) + " " + Trim(customer.cpostal_code) +;
" " + Customer.ccountry ,60) As Clocation,;
Order_line_items.cproduct_id, Products.cproduct_name,;
Order_line_items.nquantity, Order_line_items.yunit_price,;
Order_line_items.nquantity * Order_line_items.yunit_price As;
Nlinetotal, Shippers.ccompany_name;
FROM Sample!orders;
INNER JOIN Sample!customer;
ON Orders.ccustomer_id = Customer.ccustomer_id;
INNER JOIN Sample!order_line_items;
ON Orders.corder_id = Order_line_items.corder_id;
INNER JOIN Sample!shippers;
ON Orders.cshipper_id = Shippers.cshipper_id;
INNER JOIN Sample!products;
ON Products.cproduct_id = Order_line_items.cproduct_id;
WHERE Orders.corder_id = ?ordersview.corder_id
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
corder_id |
C(6) |
Order Id |
Order Id |
.T. |
Corder Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CORDER_ID |
.F. |
Order Id |
1 |
Order Id |
Order Id |
Order Id |
|
ccustomer_id |
C(6) |
Customer Id |
Customer Id |
.T. |
Ccustomer Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CCUSTOMER_ID |
.F. |
Customer Id |
2 |
Customer Id |
Customer Id |
Customer Id |
|
dordered |
D |
Ordered |
Ordered |
.T. |
Dordered Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.DORDERED |
.T. |
Ordered |
3 |
Ordered |
Ordered |
Ordered |
|
cship_to_name |
C(40) |
Ship To Name |
Ship To Name |
.T. |
Cship To Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_NAME |
.T. |
Ship To Name |
4 |
Ship To Name |
Ship To Name |
Ship To Name |
|
cship_to_address |
C(60) |
Ship To Address |
Ship To Address |
.T. |
Cship To Address Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_ADDRESS |
.T. |
Ship To Address |
5 |
Ship To Address |
Ship To Address |
Ship To Address |
|
cship_to |
C(60) |
Ship To |
Ship To |
.T. |
Cship To Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CSHIP_TO |
.F. |
Ship To |
6 |
Ship To |
Ship To |
Ship To |
|
ndiscount |
N(2) |
Discount |
Discount |
.T. |
Ndiscount Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
NDISCOUNT |
.F. |
Discount |
7 |
Discount |
Discount |
Discount |
|
yfreight |
Y |
Freight |
Freight |
.T. |
Yfreight Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.YFREIGHT |
.T. |
Freight |
8 |
Freight |
Freight |
Freight |
|
ddeliver_by |
D |
Deliver By |
Deliver By |
.T. |
Ddeliver By Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.DDELIVER_BY |
.T. |
Deliver By |
9 |
Deliver By |
Deliver By |
Deliver By |
|
ccompany |
C(40) |
Company |
Company |
.T. |
Ccompany Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CCOMPANY |
.T. |
Company |
10 |
Company |
Company |
Company |
|
cname |
C(40) |
Name |
Name |
.T. |
Cname Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CNAME |
.F. |
Name |
11 |
Name |
Name |
Name |
|
ctitle |
C(40) |
Title |
Title |
.T. |
Ctitle Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CTITLE |
.T. |
Title |
12 |
Title |
Title |
Title |
|
caddress |
C(60) |
Address |
Address |
.T. |
Caddress Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CADDRESS |
.T. |
Address |
13 |
Address |
Address |
Address |
|
clocation |
C(60) |
Location |
Location |
.T. |
Clocation Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CLOCATION |
.F. |
Location |
14 |
Location |
Location |
Location |
|
cproduct_id |
C(6) |
Product Id |
Product Id |
.T. |
Cproduct Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CPRODUCT_ID |
.F. |
Product Id |
15 |
Product Id |
Product Id |
Product Id |
|
cproduct_name |
C(40) |
Product Name |
Product Name |
.T. |
Cproduct Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CPRODUCT_NAME |
.F. |
Product Name |
16 |
Product Name |
Product Name |
Product Name |
|
nquantity |
N(6) |
Quantity |
Quantity |
.T. |
Nquantity Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
NQUANTITY |
.F. |
Quantity |
17 |
Quantity |
Quantity |
Quantity |
|
yunit_price |
Y |
Unit Price |
Unit Price |
.T. |
Yunit Price Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
YUNIT_PRICE |
.F. |
Unit Price |
18 |
Unit Price |
Unit Price |
Unit Price |
|
nlinetotal |
Y |
Linetotal |
Linetotal |
.T. |
Nlinetotal Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
NLINETOTAL |
.F. |
Linetotal |
19 |
Linetotal |
Linetotal |
Linetotal |
|
ccompany_name |
C(40) |
Company Name |
Company Name |
.T. |
Ccompany Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CCOMPANY_NAME |
.F. |
Company Name |
20 |
Company Name |
Company Name |
Company Name |
Local View: Invoiceview_devcon
Update Type: Read-Only
SQL:
SELECT Orders.corder_id, Orders.ccustomer_id, Orders.dordered,;
Orders.cship_to_name, Orders.cship_to_address,;
Padr( Trim(orders.cship_to_city) + "," +;
Trim(orders.cship_to_region) + " " +;
Trim(orders.cship_to_postal_code) + " " +;
Orders.cship_to_country ,60) As Cship_to, Orders.ndiscount,;
Orders.yfreight, Orders.ddeliver_by, Customer.ccompany,;
Padr(trim(customer.cfirst_name) + " " +;
Customer.clast_name,40) As Cname, Customer.ctitle,;
Customer.caddress, Padr( Trim(customer.ccity) + ", " +;
Trim(customer.cregion) + " " + Trim(customer.cpostal_code) + " " +;
Customer.ccountry ,60) As Clocation, Order_line_items.cproduct_id,;
Products.cproduct_name, Order_line_items.nquantity,;
Order_line_items.yunit_price, Orders.cshipper_id, Orders.mnotes,;
Orders.cemployee_id, Orders.nstatus, Customer.cphone,;
Customer.cfax, Customer.cemail, Customer.ymax_order_amt,;
Customer.ymin_order_amt, Customer.csales_region, Customer.ntype,;
Order_line_items.yunit_price*order_line_items.nquantity As;
Nlinetotal, Shippers.ccompany_name;
FROM Sample!orders;
INNER JOIN Sample!customer;
ON Orders.ccustomer_id = Customer.ccustomer_id;
INNER JOIN Sample!order_line_items;
ON Orders.corder_id = Order_line_items.corder_id;
INNER JOIN Sample!shippers;
ON Orders.cshipper_id = Shippers.cshipper_id;
INNER JOIN Sample!products;
ON Products.cproduct_id = Order_line_items.cproduct_id;
WHERE Between(val(orders.corder_id),10,20)
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
corder_id |
C(6) |
Order Id |
Order Id |
.T. |
Corder Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CORDER_ID |
.F. |
Order Id |
1 |
Order Id |
Order Id |
Order Id |
|
ccustomer_id |
C(6) |
Customer Id |
Customer Id |
.T. |
Ccustomer Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CCUSTOMER_ID |
.F. |
Customer Id |
2 |
Customer Id |
Customer Id |
Customer Id |
|
dordered |
D |
Ordered |
Ordered |
.T. |
Dordered Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.DORDERED |
.T. |
Ordered |
3 |
Ordered |
Ordered |
Ordered |
|
cship_to_name |
C(40) |
Ship To Name |
Ship To Name |
.T. |
Cship To Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_NAME |
.T. |
Ship To Name |
4 |
Ship To Name |
Ship To Name |
Ship To Name |
|
cship_to_address |
C(60) |
Ship To Address |
Ship To Address |
.T. |
Cship To Address Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_ADDRESS |
.T. |
Ship To Address |
5 |
Ship To Address |
Ship To Address |
Ship To Address |
|
cship_to |
C(60) |
Ship To |
Ship To |
.T. |
Cship To Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CSHIP_TO |
.F. |
Ship To |
6 |
Ship To |
Ship To |
Ship To |
|
ndiscount |
N(2) |
Discount |
Discount |
.T. |
Ndiscount Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
NDISCOUNT |
.F. |
Discount |
7 |
Discount |
Discount |
Discount |
|
yfreight |
Y |
Freight |
Freight |
.T. |
Yfreight Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.YFREIGHT |
.T. |
Freight |
8 |
Freight |
Freight |
Freight |
|
ddeliver_by |
D |
Deliver By |
Deliver By |
.T. |
Ddeliver By Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.DDELIVER_BY |
.T. |
Deliver By |
9 |
Deliver By |
Deliver By |
Deliver By |
|
ccompany |
C(40) |
Company |
Company |
.T. |
Ccompany Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CCOMPANY |
.T. |
Company |
10 |
Company |
Company |
Company |
|
cname |
C(40) |
Name |
Name |
.T. |
Cname Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CNAME |
.F. |
Name |
11 |
Name |
Name |
Name |
|
ctitle |
C(40) |
Title |
Title |
.T. |
Ctitle Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CTITLE |
.T. |
Title |
12 |
Title |
Title |
Title |
|
caddress |
C(60) |
Address |
Address |
.T. |
Caddress Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CADDRESS |
.T. |
Address |
13 |
Address |
Address |
Address |
|
clocation |
C(60) |
Location |
Location |
.T. |
Clocation Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CLOCATION |
.F. |
Location |
14 |
Location |
Location |
Location |
|
cproduct_id |
C(6) |
Product Id |
Product Id |
.T. |
Cproduct Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CPRODUCT_ID |
.F. |
Product Id |
15 |
Product Id |
Product Id |
Product Id |
|
cproduct_name |
C(40) |
Product Name |
Product Name |
.T. |
Cproduct Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CPRODUCT_NAME |
.F. |
Product Name |
16 |
Product Name |
Product Name |
Product Name |
|
nquantity |
N(6) |
Quantity |
Quantity |
.T. |
Nquantity Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
NQUANTITY |
.F. |
Quantity |
17 |
Quantity |
Quantity |
Quantity |
|
yunit_price |
Y |
Unit Price |
Unit Price |
.T. |
Yunit Price Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
YUNIT_PRICE |
.F. |
Unit Price |
18 |
Unit Price |
Unit Price |
Unit Price |
|
cshipper_id |
C(6) |
Shipper Id |
Shipper Id |
.T. |
Cshipper Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIPPER_ID |
.T. |
Shipper Id |
19 |
Shipper Id |
Shipper Id |
Shipper Id |
|
mnotes |
M |
Notes |
Notes |
.F. |
Mnotes Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ieditbox |
ILIBS\ICONTRLS.VCX |
.F. |
None |
MNOTES |
.F. |
Notes |
20 |
Notes |
Notes |
Notes |
|
cemployee_id |
C(6) |
Employee Id |
Employee Id |
.T. |
Cemployee Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CEMPLOYEE_ID |
.T. |
Employee Id |
21 |
Employee Id |
Employee Id |
Employee Id |
|
nstatus |
N(1) |
Status |
Status |
.T. |
Nstatus Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.NSTATUS |
.T. |
Status |
22 |
Status |
Status |
Status |
|
cphone |
C(24) |
Phone |
Phone |
.T. |
Cphone Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CPHONE |
.T. |
Phone |
23 |
Phone |
Phone |
Phone |
|
cfax |
C(24) |
Fax |
Fax |
.T. |
Cfax Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CFAX |
.T. |
Fax |
24 |
Fax |
Fax |
Fax |
|
cemail |
C(40) |
|
|
.T. |
Cemail Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CEMAIL |
.T. |
|
25 |
|
|
|
|
ymax_order_amt |
Y |
Max Order Amt |
Max Order Amt |
.T. |
Ymax Order Amt Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.YMAX_ORDER_AMT |
.T. |
Max Order Amt |
26 |
Max Order Amt |
Max Order Amt |
Max Order Amt |
|
ymin_order_amt |
Y |
Min Order Amt |
Min Order Amt |
.T. |
Ymin Order Amt Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.YMIN_ORDER_AMT |
.T. |
Min Order Amt |
27 |
Min Order Amt |
Min Order Amt |
Min Order Amt |
|
csales_region |
C(4) |
Sales Region |
Sales Region |
.T. |
Csales Region Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.CSALES_REGION |
.T. |
Sales Region |
28 |
Sales Region |
Sales Region |
Sales Region |
|
ntype |
N(1) |
Type |
Type |
.T. |
Ntype Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!CUSTOMER.NTYPE |
.T. |
Type |
29 |
Type |
Type |
Type |
|
nlinetotal |
Y |
Line Total |
Line Total |
.T. |
Nlinetotal Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
NLINETOTAL |
.F. |
Line Total |
19 |
Line Total |
Line Total |
Line Total |
|
ccompany_name |
C(40) |
Company Name |
Company Name |
.T. |
Ccompany Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
CCOMPANY_NAME |
.F. |
Company Name |
20 |
Company Name |
Company Name |
Company Name |
Parameters: cOrder_Id,'C'
Update Type: Key and Modified
SQL:
SELECT Order_line_items.corder_id, Order_line_items.nquantity,;
Products.cproduct_name, Products.cproduct_id,;
Products.nunits_in_stock;
FROM Sample!products;
INNER JOIN Sample!order_line_items;
ON Products.cproduct_id = Order_line_items.cproduct_id;
WHERE Order_line_items.corder_id = ?ordersview.corder_id
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
corder_id |
C(6) |
Corder Id View Parameter |
Order Id |
Order Id |
Order Id |
Order Id |
[DEFAULT] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
corder_id |
C(6) |
Order Id |
Order Id |
.T. |
Corder Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDER_LINE_ITEMS.CORDER_ID |
.F. |
Order Id |
1 |
Order Id |
Order Id |
Order Id |
|
nquantity |
N(6) |
Quantity |
Quantity |
.T. |
Nquantity Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDER_LINE_ITEMS.NQUANTITY |
.F. |
Quantity |
2 |
Quantity |
Quantity |
Quantity |
|
cproduct_name |
C(40) |
Product Name |
Product Name |
.T. |
Cproduct Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PRODUCTS.CPRODUCT_NAME |
.F. |
Product Name |
3 |
Product Name |
Product Name |
Product Name |
|
cproduct_id |
C(6) |
Product Id |
Product Id |
.T. |
Cproduct Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PRODUCTS.CPRODUCT_ID |
.F. |
Product Id |
4 |
Product Id |
Product Id |
Product Id |
|
nunits_in_stock |
N(12,3) |
Units In Stock |
Units In Stock |
.T. |
Nunits In Stock Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PRODUCTS.NUNITS_IN_STOCK |
.T. |
Units In Stock |
5 |
Units In Stock |
Units In Stock |
Units In Stock |
Update Type: Read-Only
SQL:
SELECT Products.cproduct_name, Products.cquantity_in_unit,;
Products.nunits_in_stock, Products.nunits_on_order,;
Products.nreorder_level, Supplier.ccompany_name;
FROM Sample!supplier;
INNER JOIN Sample!products;
ON Supplier.csupplier_id = Products.csupplier_id;
WHERE Products.nunits_in_stock < Products.nreorder_level;
ORDER BY Supplier.ccompany_name, Products.cproduct_name
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
cproduct_name |
C(40) |
Product Name |
Product Name |
.T. |
Cproduct Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PRODUCTS.CPRODUCT_NAME |
.T. |
Product Name |
1 |
Product Name |
Product Name |
Product Name |
|
cquantity_in_unit |
C(20) |
Quantity In Unit |
Quantity In Unit |
.T. |
Cquantity In Unit Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PRODUCTS.CQUANTITY_IN_UNIT |
.T. |
Quantity In Unit |
2 |
Quantity In Unit |
Quantity In Unit |
Quantity In Unit |
|
nunits_in_stock |
N(12,3) |
Units In Stock |
Units In Stock |
.T. |
Nunits In Stock Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PRODUCTS.NUNITS_IN_STOCK |
.T. |
Units In Stock |
3 |
Units In Stock |
Units In Stock |
Units In Stock |
|
nunits_on_order |
N(12,3) |
Units On Order |
Units On Order |
.T. |
Nunits On Order Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PRODUCTS.NUNITS_ON_ORDER |
.T. |
Units On Order |
4 |
Units On Order |
Units On Order |
Units On Order |
|
nreorder_level |
N(12,3) |
Reorder Level |
Reorder Level |
.T. |
Nreorder Level Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PRODUCTS.NREORDER_LEVEL |
.T. |
Reorder Level |
5 |
Reorder Level |
Reorder Level |
Reorder Level |
|
ccompany_name |
C(40) |
Company Name |
Company Name |
.T. |
Ccompany Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!SUPPLIER.CCOMPANY_NAME |
.T. |
Company Name |
6 |
Company Name |
Company Name |
Company Name |
Parameters: vp_cOrder_Id,'C'
Update Type: Key and Modified
SQL:
SELECT Order_line_items.clineid, Order_line_items.corder_id,;
Products.cproduct_name, Order_line_items.nquantity,;
Order_line_items.cproduct_id, Order_line_items.yunit_price,;
Order_line_items.nquantity*order_line_items.yunit_price As;
Nlinetotal;
FROM Sample!products;
RIGHT OUTER JOIN Sample!order_line_items;
ON Products.cproduct_id = Order_line_items.cproduct_id;
WHERE Order_line_items.corder_id = ?vp_corder_id;
ORDER BY Order_line_items.clineid
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
vp_corder_id |
C(6) |
Vp Corder Id View Parameter |
Order Id |
Order Id |
Order Id |
Order Id |
[DEFAULT] |
orderitemsorderidviewparameter |
c:\vfe6\new sample\libs\abhavior.vcx |
itextbox |
ILIBS\ICONTRLS.VCX |
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Update Expression |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Value Required |
Allow Quick Find |
Default Expression |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
Look Up Type |
Look Up Display Fields |
Look Up Cursor |
Look Up Index Tag |
|
clineid |
C(6) |
Line Id |
Line Id |
.T. |
Clineid Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!ORDER_LINE_ITEMS.CLINEID |
.T. |
Line Id |
1 |
Line Id |
Line Id |
Line Id |
None (Default) |
|||||
|
corder_id |
C(6) |
Order Id |
Order Id |
.T. |
Corder Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!ORDER_LINE_ITEMS.CORDER_ID |
.T. |
Order Id |
2 |
Order Id |
Order Id |
Order Id |
None (Default) |
|||||
|
cproduct_name |
C(40) |
Product Name |
Product Name |
.T. |
Cproduct Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!PRODUCTS.CPRODUCT_NAME |
.F. |
Product Name |
3 |
Product Name |
Product Name |
Product Name |
None (Default) |
|||||
|
nquantity |
N(6) |
Quantity |
Quantity |
.T. |
Nquantity Field |
.T. |
[DEFAULT] |
orderitemquantityfield |
c:\vfe6\sample\libs\abhavior.vcx |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
1 |
Expression |
SAMPLE!ORDER_LINE_ITEMS.NQUANTITY |
.T. |
Quantity |
4 |
Quantity |
Quantity |
Quantity |
None (Default) |
||||
|
cproduct_id |
C(6) |
Product |
Product |
.T. |
Cproduct Id Field |
.T. |
Productslookupview.cproduct_id |
[NONE] |
orderitemsproductidfield |
c:\vfe6\new sample\libs\abhavior.vcx |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
.T. |
None |
SAMPLE!ORDER_LINE_ITEMS.CPRODUCT_ID |
.T. |
Product |
5 |
Product |
Product |
Product |
Index Tag |
cproduct_name |
lviews!productslookupview |
productid |
|
|
yunit_price |
Y |
Unit Price |
Unit Price |
.T. |
Yunit Price Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
SAMPLE!ORDER_LINE_ITEMS.YUNIT_PRICE |
.T. |
Unit Price |
6 |
Unit Price |
Unit Price |
Unit Price |
None (Default) |
|||||
|
nlinetotal |
Y |
Line Total |
Line Total |
.T. |
Nlinetotal Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.F. |
.T. |
None |
ORDER_LINE_ITEMS.YUNIT_PRICE* |
.F. |
Line Total |
7 |
Line Total |
Line Total |
Line Total |
None (Default) |
Parameters: vp_cCustomer_Id,'C'
Update Type: Read-Only
SQL:
SELECT Orders.corder_id, Orders.dordered, Orders.ddeliver_by,;
Orders.cship_to_name, Iif(orders.nstatus=1,padr("on Order",10);
,iif(orders.nstatus=2,padr("shipped",10),padr("voided",10)));
As Cstatus, Orders.ccustomer_id;
FROM Sample!orders;
WHERE Orders.ccustomer_id = ?vp_ccustomer_id;
ORDER BY Orders.dordered, Orders.ddeliver_by, 5
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
vp_ccustomer_id |
C(10) |
Vp Ccustomer Id View Parameter |
Customer Id |
Customer Id |
Customer Id |
Customer Id |
[DEFAULT] |
customeridviewparameter |
c:\vfe6\sample\libs\abhavior.vcx |
itextbox |
ILIBS\ICONTRLS.VCX |
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Search Index Tag |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
corder_id |
C(6) |
Order Id |
Order Id |
.T. |
Corder Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
orderid |
None |
SAMPLE!ORDERS.CORDER_ID |
.F. |
Order Id |
1 |
Order Id |
Order Id |
Order Id |
|
dordered |
D |
Ordered |
Ordered |
.T. |
Dordered Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
dordered |
None |
SAMPLE!ORDERS.DORDERED |
.F. |
Ordered |
2 |
Ordered |
Ordered |
Ordered |
|
ddeliver_by |
D |
Deliver By |
Deliver By |
.T. |
Ddeliver By Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
deliver |
None |
SAMPLE!ORDERS.DDELIVER_BY |
.F. |
Deliver By |
3 |
Deliver By |
Deliver By |
Deliver By |
|
cship_to_name |
C(40) |
Ship To Name |
Ship To Name |
.T. |
Cship To Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_NAME |
.F. |
Ship To Name |
4 |
Ship To Name |
Ship To Name |
Ship To Name |
|
|
cstatus |
C(10) |
Status |
Status |
.T. |
Cstatus Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
ORDERS.CSHIP_TO_NAME* |
.F. |
Status |
5 |
Status |
Status |
Status |
|
|
ccustomer_id |
C(6) |
Customer Id |
Customer Id |
.T. |
Ccustomer Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CCUSTOMER_ID |
.T. |
Customer Id |
6 |
Customer Id |
Customer Id |
Customer Id |
|
Tag |
Expression |
Display Order |
Tag Caption |
Description |
Display |
|
orderid (R) |
CORDER_ID |
1 |
Order Id |
Orderid Index |
.T. |
|
dordered (R) |
DORDERED |
1 |
Date Ordered |
Dordered Index |
.T. |
|
deliver (R) |
DDELIVER_BY |
1 |
Deliver By Date |
Deliver Index |
.T. |
Update Type: Key and Modified
SQL:
SELECT Payments.cpayment_id, Payments.corder_id,;
Payments.dreceived, Payments.namount, Payments.cmethod,;
Payments.cexpires, Payments.caccount_no;
FROM Sample!payments;
WHERE Payments.corder_id = ?ordersview.corder_id;
ORDER BY Payments.dreceived
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Expression |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Value Is In List |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
cpayment_id |
C(6) |
Payment Id |
Payment Id |
.T. |
Cpayment Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PAYMENTS.CPAYMENT_ID |
.T. |
Payment Id |
1 |
Payment Id |
Payment Id |
Payment Id |
||
|
corder_id |
C(6) |
Order Id |
Order Id |
.T. |
Corder Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PAYMENTS.CORDER_ID |
.T. |
Order Id |
2 |
Order Id |
Order Id |
Order Id |
||
|
dreceived |
D |
Received |
Received |
.T. |
Dreceived Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
DATE() |
Expression |
SAMPLE!PAYMENTS.DRECEIVED |
.T. |
Received |
3 |
Received |
Received |
Received |
|
|
namount |
Y |
Amount |
Amount |
.T. |
Namount Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PAYMENTS.NAMOUNT |
.T. |
Amount |
4 |
Amount |
Amount |
Amount |
||
|
cmethod |
C(20) |
Method |
Method |
.T. |
Cmethod Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PAYMENTS.CMETHOD |
.T. |
Method |
"Check", "Cash", "Master Card", "Visa", "American Express" |
5 |
Method |
Method |
Method |
|
|
cexpires |
D |
Expires |
Expires |
.T. |
Cexpires Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PAYMENTS.CEXPIRES |
.T. |
Expires |
7 |
Expires |
Expires |
Expires |
||
|
caccount_no |
C(20) |
Account No |
Account No |
.T. |
Caccount No Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!PAYMENTS.CACCOUNT_NO |
.T. |
Account No |
6 |
Account No |
Account No |
Account No |
Local View: Ordersreport_devcon
Update Type: Key and Modified
SQL:
SELECT Orders.corder_id, Orders.ccustomer_id, Orders.cshipper_id,;
Orders.dordered, Orders.cship_to_name, Orders.cship_to_address,;
Orders.cship_to_city, Orders.cship_to_region,;
Orders.cship_to_postal_code, Orders.cship_to_country,;
Orders.ndiscount, Orders.yfreight, Orders.ddeliver_by,;
Orders.mnotes, Orders.nstatus, Orders.cemployee_id;
FROM Sample!orders;
ORDER BY Orders.ccustomer_id, Orders.dordered
|
Field Name |
Type |
Grid Caption |
Tooltip Text |
Searchable |
Description |
Filterable |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
Allow Quick Find |
Default Expression |
Default Type |
Update Name |
Updatable |
Dialog Caption |
Display Order |
Form Caption |
Report Caption |
Status Bar Text |
|
corder_id |
C(6) |
Order Id |
Order Id |
.T. |
Corder Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CORDER_ID |
.T. |
Order Id |
1 |
Order Id |
Order Id |
Order Id |
|
|
ccustomer_id |
C(6) |
Customer Id |
Customer Id |
.T. |
Ccustomer Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CCUSTOMER_ID |
.T. |
Customer Id |
2 |
Customer Id |
Customer Id |
Customer Id |
|
|
cshipper_id |
C(6) |
Shipper Id |
Shipper Id |
.T. |
Cshipper Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIPPER_ID |
.T. |
Shipper Id |
3 |
Shipper Id |
Shipper Id |
Shipper Id |
|
|
dordered |
D |
Ordered |
Ordered |
.T. |
Dordered Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itxtdate |
ILIBS\ISTDTXT.VCX |
.T. |
DATE() |
Expression |
SAMPLE!ORDERS.DORDERED |
.T. |
Ordered |
4 |
Ordered |
Ordered |
Ordered |
|
cship_to_name |
C(40) |
Ship To Name |
Ship To Name |
.T. |
Cship To Name Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_NAME |
.T. |
Ship To Name |
5 |
Ship To Name |
Ship To Name |
Ship To Name |
|
|
cship_to_address |
C(60) |
Ship To Address |
Ship To Address |
.T. |
Cship To Address Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_ADDRESS |
.T. |
Ship To Address |
6 |
Ship To Address |
Ship To Address |
Ship To Address |
|
|
cship_to_city |
C(15) |
Ship To City |
Ship To City |
.T. |
Cship To City Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_CITY |
.T. |
Ship To City |
7 |
Ship To City |
Ship To City |
Ship To City |
|
|
cship_to_region |
C(15) |
Ship To Region |
Ship To Region |
.T. |
Cship To Region Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_REGION |
.T. |
Ship To Region |
8 |
Ship To Region |
Ship To Region |
Ship To Region |
|
|
cship_to_postal_code |
C(10) |
Ship To Postal Code |
Ship To Postal Code |
.T. |
Cship To Postal Code Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_POSTAL_CODE |
.T. |
Ship To Postal Code |
9 |
Ship To Postal Code |
Ship To Postal Code |
Ship To Postal Code |
|
|
cship_to_country |
C(15) |
Ship To Country |
Ship To Country |
.T. |
Cship To Country Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CSHIP_TO_COUNTRY |
.T. |
Ship To Country |
10 |
Ship To Country |
Ship To Country |
Ship To Country |
|
|
ndiscount |
N(2) |
Discount |
Discount |
.T. |
Ndiscount Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.NDISCOUNT |
.T. |
Discount |
11 |
Discount |
Discount |
Discount |
|
|
yfreight |
Y |
Freight |
Freight |
.T. |
Yfreight Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.YFREIGHT |
.T. |
Freight |
12 |
Freight |
Freight |
Freight |
|
|
ddeliver_by |
D |
Deliver By |
Deliver By |
.T. |
Ddeliver By Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itxtdate |
ILIBS\ISTDTXT.VCX |
.T. |
DATE() + 7 |
Expression |
SAMPLE!ORDERS.DDELIVER_BY |
.T. |
Deliver By |
13 |
Deliver By |
Deliver By |
Deliver By |
|
mnotes |
M |
Notes |
Notes |
.F. |
Mnotes Field |
.F. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
ieditbox |
ILIBS\ICONTRLS.VCX |
.F. |
None |
SAMPLE!ORDERS.MNOTES |
.T. |
Notes |
14 |
Notes |
Notes |
Notes |
|
|
nstatus |
N(1) |
Status |
Status |
.T. |
Nstatus Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
1 |
Expression |
SAMPLE!ORDERS.NSTATUS |
.T. |
Status |
15 |
Status |
Status |
Status |
|
cemployee_id |
C(6) |
Employee Id |
Employee Id |
.T. |
Cemployee Id Field |
.T. |
[DEFAULT] |
iField |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
.T. |
None |
SAMPLE!ORDERS.CEMPLOYEE_ID |
.T. |
Employee Id |
16 |
Employee Id |
Employee Id |
Employee Id |
Parameters: vp_cCustomer_Id,'C';vp_dStart,'D';vp_dEnd,'D';vp_cEmployee_Id,'C';vp_cOrder_Id,'C';vp_nStatus,'N'
Update Type: Key and Modified
SQL:
SELECT Orders.corder_id, Orders.ccustomer_id, Orders.cshipper_id,;
Orders.dordered, Orders.cship_to_name, Orders.cship_to_address,;
Orders.cship_to_city, Orders.cship_to_region,;
Orders.cship_to_postal_code, Orders.cship_to_country,;
Orders.ndiscount, Orders.yfreight, Orders.ddeliver_by,;
Orders.mnotes, Orders.nstatus, Orders.cemployee_id,;
Customer.ccompany;
FROM Sample!orders;
LEFT OUTER JOIN Sample!customer;
ON Orders.ccustomer_id = Customer.ccustomer_id;
WHERE Orders.ccustomer_id Like ?vp_ccustomer_id And;
Orders.dordered >= ?vp_dstart And Orders.dordered <= ?vp_dend;
And Orders.cemployee_id Like ?vp_cemployee_id And Orders.corder_id;
Like ?vp_corder_id And Orders.nstatus = ?vp_nstatus;
ORDER BY Orders.ccustomer_id, Orders.dordered
Parameters
|
Parameter |
Type |
Description |
Form Caption |
Dialog Caption |
Tooltip Text |
Status Bar Text |
Look Up Index Tag |
Look Up Display Fields |
Look Up Update Expression |
Look Up Display Form |
Behavior Class |
Behavior Class Library |
User Interface Class |
User Interface Class Library |
|
vp_ccustomer_id |
C(6) |
Vp Ccustomer Id View Parameter |
Customer Id |
Customer Id |
Customer Id |
Customer Id |
ccustomer_id |
cname |
Customerlookupview.ccustomer_id |
[NONE] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_cemployee_id |
C(6) |
Vp Cemployee Id View Parameter |
Employee Id |
Employee Id |
Employee Id |
Employee Id |
cemployee_id |
cname |
Employeelookupview.cemployee_id |
[NONE] |
iViewParameter |
ILIBS\IDATA.VCX |
itextbox |
ILIBS\ICONTRLS.VCX |
|
vp_corder_id |
C(6) |
Vp Corder Id View Parameter |
Order Id |
Order Id |
Order Id |
Order Id |
[DEFAULT] |
iviewparameter |
ILIBS\idata.vcx |
itextbox |
ILIBS\ICONTRLS.VCX |
|||
|
vp_dend |
D |
Vp Dend View Parameter |
End |
End |
End |
End |
[DEFAULT] |