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] |