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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
RuleExpression: | |
RuleText: | |
Tables: | category |
KeyFieldList: | |
UpdatableFieldList: | |
UpdateNameList: | category_name Category.category_name, description Category.description, picture Category.picture |
AllowSimultaneousFetch: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | category_name | C | 15 | ![]() |
|
2. | description | M | ![]() |
||
3. | picture | G |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
RuleExpression: | |
RuleText: | |
Tables: | customer |
KeyFieldList: | |
UpdatableFieldList: | |
UpdateNameList: | company_name Customer.company_name, contact_name Customer.contact_name, phone Customer.phone |
AllowSimultaneousFetch: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | company_name | C | 40 | ![]() |
|
2. | contact_name | C | 30 | ![]() |
|
3. | phone | C | 24 | ![]() |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
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: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | title | C | 30 | ![]() |
|
2. | last_name | C | 20 | ![]() |
|
3. | first_name | C | 10 | ![]() |
|
4. | extension | C | 4 | ![]() |
|
5. | notes | M | ![]() |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
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: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | order_id | C | 6 | ![]() |
|
2. | order_date | D | |||
3. | deliver_by | D | |||
4. | ord_total | Y | |||
5. | paid | L |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
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: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | exp_1 | L | |||
2. | product_name | C | 40 | ![]() |
|
3. | quantity | N | 12,3 | ||
4. | unit_price | Y | |||
5. | extension | Y | |||
6. | product_id | C | 6 | ![]() |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
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: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | order_number | C | 6 | ![]() |
|
2. | order_date | D | |||
3. | ship_to_name | C | 40 | ![]() |
|
4. | ship_to_address | C | 60 | ![]() |
|
5. | ship_to_city | C | 15 | ![]() |
|
6. | ship_to_region | C | 15 | ![]() |
|
7. | ship_to_postal_code | C | 10 | ![]() |
|
8. | ship_to_country | C | 15 | ![]() |
|
9. | discount | N | 2 | ||
10. | freight | Y | |||
11. | unit_price | Y | |||
12. | quantity | N | 12,3 | ||
13. | company_name_a | C | 40 | ![]() |
|
14. | address | C | 60 | ![]() |
|
15. | city | C | 15 | ![]() |
|
16. | region | C | 15 | ![]() |
|
17. | postal_code | C | 10 | ![]() |
|
18. | country | C | 15 | ![]() |
|
19. | company_name_b | C | 40 | ![]() |
|
20. | product_name | C | 40 | ![]() |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
RuleExpression: | |
RuleText: | |
Tables: | |
KeyFieldList: | |
UpdatableFieldList: | |
UpdateNameList: | customer_id customer_id, ordertotal ordertotal |
AllowSimultaneousFetch: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | customer_id | C | 6 | ![]() |
|
2. | ordertotal | Y |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
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: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | product_name | C | 40 | ![]() |
|
2. | quantity_in_unit | C | 20 | ![]() |
|
3. | unit_price | Y | |||
4. | unit_cost | Y |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
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: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | exp_1 | C | 6 | ![]() |
|
2. | order_date | D | |||
3. | sum_unit_price | Y |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
RuleExpression: | |
RuleText: | |
Tables: | rectclass |
KeyFieldList: | |
UpdatableFieldList: | |
UpdateNameList: | exp_1 exp_1, sum_unit_price sum_unit_price |
AllowSimultaneousFetch: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | exp_1 | C | 6 | ![]() |
|
2. | sum_unit_price | Y |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
RuleExpression: | |
RuleText: | |
Tables: | |
KeyFieldList: | |
UpdatableFieldList: | |
UpdateNameList: | company_name COMPANY_NAME |
AllowSimultaneousFetch: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | company_name | C | 40 | ![]() |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
RuleExpression: | |
RuleText: | |
Tables: | supplier |
KeyFieldList: | |
UpdatableFieldList: | |
UpdateNameList: | company_name Supplier.company_name, contact_name Supplier.contact_name, phone Supplier.phone |
AllowSimultaneousFetch: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | company_name | C | 40 | ![]() |
|
2. | contact_name | C | 30 | ![]() |
|
3. | phone | C | 24 | ![]() |
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: | ![]() |
UpdateType: | 1 |
WhereType: | 3 |
Prepared: | ![]() |
CompareMemo: | ![]() |
FetchAsNeeded: | ![]() |
Offline: | ![]() |
RuleExpression: | |
RuleText: | |
Tables: | |
KeyFieldList: | |
UpdatableFieldList: | |
UpdateNameList: | company_name company_name, country country, custtotal custtotal |
AllowSimultaneousFetch: | ![]() |
Or. | Name | Type | Lenght | Binnary | |
1. | company_name | C | 40 | ![]() |
|
2. | country | C | 15 | ![]() |
|
3. | custtotal | Y |