Views

NameComment
category listing 
customer listing 
employee listing 
order history 
order history line items 
orders view 
ordertotal 
product listing 
sales detail 
sales summary 
shipper listing 
supplier listing 
top25cust 

View: category listing
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!category listing
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT Category.category_name, Category.description, Category.picture FROM tastrade!category
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:category
KeyFieldList:
UpdatableFieldList:
UpdateNameList:category_name Category.category_name, description Category.description, picture Category.picture
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   category_name C 15 Field category listing is not binnary
2.   description M   Field category listing is not binnary
3.   picture G    

View: customer listing
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!customer listing
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT Customer.company_name, Customer.contact_name, Customer.phone FROM tastrade!customer ORDER BY Customer.company_name, Customer.contact_name
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:customer
KeyFieldList:
UpdatableFieldList:
UpdateNameList:company_name Customer.company_name, contact_name Customer.contact_name, phone Customer.phone
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   company_name C 40 Field customer listing is not binnary
2.   contact_name C 30 Field customer listing is not binnary
3.   phone C 24 Field customer listing is not binnary

View: employee listing
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!employee listing
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT Employee.title, Employee.last_name, Employee.first_name, Employee.extension, Employee.notes FROM tastrade!employee WHERE Employee.title = ?cTitle ORDER BY Employee.title, Employee.last_name, Employee.first_name, Employee.extension
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:employee
KeyFieldList:
UpdatableFieldList:
UpdateNameList:title Employee.title, last_name Employee.last_name, first_name Employee.first_name, extension Employee.extension, notes Employee.notes
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   title C 30 Field employee listing is not binnary
2.   last_name C 20 Field employee listing is not binnary
3.   first_name C 10 Field employee listing is not binnary
4.   extension C 4 Field employee listing is not binnary
5.   notes M   Field employee listing is not binnary

View: order history
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!order history
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT Orders.order_id, Orders.order_date, Orders.deliver_by, SUM(Orditems.unit_price*Orditems.quantity)-Orders.discount*0.01*SUM(Orditems.unit_price*Orditems.quantity)+Orders.freight AS ord_total, Orders.paid FROM tastrade!orders INNER JOIN tastrade!order_line_items Orditems ON Orders.order_id = Orditems.order_id WHERE Orders.customer_id = ?customer.customer_id GROUP BY Orditems.order_id ORDER BY Orders.order_date DESC
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) are included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:tastrade!orders
KeyFieldList:order_id
UpdatableFieldList:order_date, deliver_by, paid
UpdateNameList:order_id TASTRADE!ORDERS.order_id, order_date TASTRADE!ORDERS.order_date, deliver_by TASTRADE!ORDERS.deliver_by, ord_total Orders.deliver_by*, paid tastrade!orders.paid
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   order_id C 6 Field order history is not binnary
2.   order_date D    
3.   deliver_by D    
4.   ord_total Y    
5.   paid L    

View: order history line items
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!order history line items
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT .F., Products.product_name, Order_line_items.quantity, Order_line_items.unit_price, Order_line_items.unit_price*Order_line_items.quantity AS extension, Order_line_items.product_id FROM tastrade!order_line_items, tastrade!products WHERE Products.product_id = Order_line_items.product_id AND Order_line_items.order_id = ?orders.order_id
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) are included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:tastrade!order_line_items
KeyFieldList:
UpdatableFieldList:product_id
UpdateNameList:exp_1 exp_1, product_name Products.product_name, quantity Order_line_items.quantity, unit_price Order_line_items.unit_price, extension Order_line_items.unit_price*, product_id tastrade!order_line_items.product_id
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   exp_1 L    
2.   product_name C 40 Field order history line items is not binnary
3.   quantity N 12,3  
4.   unit_price Y    
5.   extension Y    
6.   product_id C 6 Field order history line items is not binnary

View: orders view
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!orders view
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT Orders.order_number, Orders.order_date, Orders.ship_to_name, Orders.ship_to_address, Orders.ship_to_city, Orders.ship_to_region, Orders.ship_to_postal_code, Orders.ship_to_country, Orders.discount, Orders.freight, Order_line_items.unit_price, Order_line_items.quantity, Customer.company_name, Customer.address, Customer.city, Customer.region, Customer.postal_code, Customer.country, Shippers.company_name, Products.product_name FROM tastrade!orders, tastrade!order_line_items, tastrade!customer, tastrade!shippers, tastrade!products WHERE Orders.order_id = Order_line_items.order_id AND Orders.customer_id = Customer.customer_id AND Orders.shipper_id = Shippers.shipper_id AND Order_line_items.product_id = Products.product_id AND Orders.order_date BETWEEN ?dDateFrom AND ?dDateTo ORDER BY Orders.order_date, Orders.order_number
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:orders,order_line_items,customer,shippers,products
KeyFieldList:
UpdatableFieldList:
UpdateNameList:order_number Orders.order_number, order_date Orders.order_date, ship_to_name Orders.ship_to_name, ship_to_address Orders.ship_to_address, ship_to_city Orders.ship_to_city, ship_to_region Orders.ship_to_region, ship_to_postal_code Orders.ship_to_postal_code, ship_to_country Orders.ship_to_country, discount Orders.discount, freight Orders.freight, unit_price Order_line_items.unit_price, quantity Order_line_items.quantity, company_name_a Customer.company_name, address Customer.address, city Customer.city, region Customer.region, postal_code Customer.postal_code, country Customer.country, company_name_b Shippers.company_name, product_name Products.product_name
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   order_number C 6 Field orders view is not binnary
2.   order_date D    
3.   ship_to_name C 40 Field orders view is not binnary
4.   ship_to_address C 60 Field orders view is not binnary
5.   ship_to_city C 15 Field orders view is not binnary
6.   ship_to_region C 15 Field orders view is not binnary
7.   ship_to_postal_code C 10 Field orders view is not binnary
8.   ship_to_country C 15 Field orders view is not binnary
9.   discount N 2  
10.   freight Y    
11.   unit_price Y    
12.   quantity N 12,3  
13.   company_name_a C 40 Field orders view is not binnary
14.   address C 60 Field orders view is not binnary
15.   city C 15 Field orders view is not binnary
16.   region C 15 Field orders view is not binnary
17.   postal_code C 10 Field orders view is not binnary
18.   country C 15 Field orders view is not binnary
19.   company_name_b C 40 Field orders view is not binnary
20.   product_name C 40 Field orders view is not binnary

View: ordertotal
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!ordertotal
Current Group:DIAF
File Group:16
SubType:Local
SQL SELECT:SELECT Orders.customer_id, SUM(Orditems.unit_price*Orditems.quantity-(0.01*Orders.discount*Orditems.unit_price*Orditems.quantity))+Orders.freight AS ordertotal FROM tastrade!orders INNER JOIN tastrade!order_line_items Orditems ON Orders.order_id = Orditems.order_id GROUP BY Orditems.order_id
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) are included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:
KeyFieldList:
UpdatableFieldList:
UpdateNameList:customer_id customer_id, ordertotal ordertotal
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   customer_id C 6 Field ordertotal is not binnary
2.   ordertotal Y    

View: product listing
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!product listing
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT Products.product_name, Products.quantity_in_unit, Products.unit_price, Products.unit_cost FROM tastrade!Products ORDER BY Products.product_name, Products.quantity_in_unit
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:
KeyFieldList:
UpdatableFieldList:
UpdateNameList:product_name PRODUCT_NAME, quantity_in_unit QUANTITY_IN_UNIT, unit_price UNIT_PRICE, unit_cost UNIT_COST
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   product_name C 40 Field product listing is not binnary
2.   quantity_in_unit C 20 Field product listing is not binnary
3.   unit_price Y    
4.   unit_cost Y    

View: sales detail
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!sales detail
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT STR(YEAR(Orders.order_date),4)+STR(MONTH(Orders.order_date),2), Orders.order_date, SUM(Order_line_items.unit_price) FROM tastrade!orders, tastrade!order_line_items WHERE Orders.order_id = Order_line_items.order_id GROUP BY 1, Orders.order_date
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:orders,order_line_items
KeyFieldList:
UpdatableFieldList:
UpdateNameList:exp_1 exp_1, order_date Orders.order_date, sum_unit_price sum_unit_price
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   exp_1 C 6 Field sales detail is not binnary
2.   order_date D    
3.   sum_unit_price Y    

View: sales summary
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!sales summary
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT STR(YEAR(Orders.order_date), 4) + STR(MONTH(Orders.order_date), 2), SUM(Order_line_items.unit_price) AS sum_unit_price FROM tastrade!Orders, tastrade!Order_Line_Items WHERE Orders.order_id = Order_line_items.order_id GROUP BY 1
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:rectclass
KeyFieldList:
UpdatableFieldList:
UpdateNameList:exp_1 exp_1, sum_unit_price sum_unit_price
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   exp_1 C 6 Field sales summary is not binnary
2.   sum_unit_price Y    

View: shipper listing
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!shipper listing
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT Shippers.company_name FROM tastrade!Shippers ORDER BY Shippers.company_name
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:
KeyFieldList:
UpdatableFieldList:
UpdateNameList:company_name COMPANY_NAME
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   company_name C 40 Field shipper listing is not binnary

View: supplier listing
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!supplier listing
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT Supplier.company_name, Supplier.contact_name, Supplier.phone FROM tastrade!supplier ORDER BY Supplier.company_name, Supplier.contact_name
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) aren't included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:supplier
KeyFieldList:
UpdatableFieldList:
UpdateNameList:company_name Supplier.company_name, contact_name Supplier.contact_name, phone Supplier.phone
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   company_name C 40 Field supplier listing is not binnary
2.   contact_name C 30 Field supplier listing is not binnary
3.   phone C 24 Field supplier listing is not binnary

View: top25cust
 
Description
PlugIn Class:_diaf_pdm
PlugIn ID:1000
PlugIn Group:DIAF

Source file:C:\PROGRAM FILES\DEVSTUDIO\VFP\SAMPLES\TASTRADE\DATA\TASTRADE.DBC!top25cust
Current Group:DIAF
File Group:16

SubType:Local
SQL SELECT:SELECT TOP 25 customer.company_name,customer.country,SUM(ordertotal.ordertotal) AS custtotal FROM customer INNER JOIN tastrade!ordertotal ON customer.customer_id = ordertotal.customer_id GROUP BY ordertotal.customer_id ORDER BY custtotal DESC
SourceType:Local
SendUpdates:A SQL update query sent not to update remote tables
UpdateType:1
WhereType:3
Prepared:SQL statements aren't prepared for subsequent REQUERY() function calls
CompareMemo:Memo fields (Memo/General) are included in the WHERE clause for updates
FetchAsNeeded:Data isn't fetched as needed
Offline:The view isn't an offline view
RuleExpression:
RuleText:
Tables:
KeyFieldList:
UpdatableFieldList:
UpdateNameList:company_name company_name, country country, custtotal custtotal
AllowSimultaneousFetch:Fetch rows permit not simultaneously

Or.NameTypeLenghtBinnary
1.   company_name C 40 Field top25cust is not binnary
2.   country C 15 Field top25cust is not binnary
3.   custtotal Y