Types of DataSources

Types of DataSources in AOT:

A form data source supplies the data that appears on a form. 
To display data, you assign a data field from the form data source to a property of a control that appears on the form.

1. Table: 

A table is a business object in the Data Dictionary node of the AOT. A table is an object that contains data records for the system. In additionally, a table can define a table relation that enables you to look up data from a referenced table.

2. View:
A view is a business object in the Data Dictionary node of the AOT. A view is a stored query that retrieves a specified collection of data records and fields. The data in a view is retrieved when the view is accessed. 

How to use in form level:

AOT>DataDictionary>View>DirPartyView

AOT>Form>DirPartyTable

3. Query:

A query is a business object in the Queries node of the AOT. A query uses tables, maps, or views to retrieve a set of data fields. To use a query as a form data source, you use the Query property of the Data Sources node to specify the query for the form.

You might find that a query has set the Dynamic property of the Fields node to No. You set Dynamic to No when you want to specify the list of fields that appear in the query. When you add that query to the Data Sources of a form, the list of fields in the table node include all the fields for the table.

http://msdn.microsoft.com/en-us/library/bb278121.aspx

I am trying to install IIS showing a error message in internet explorer:

trying to install IIS showing a error message in internet explorer:

Solution:

Internet exploreràinternet optionsàadvanced tab pageà resetàreset.

some useful RUN (Windows+r) commands in windows

                   To Access                                                       Run Command

1. Add/Remove Programs                                              appwiz.cpl   
2. Administrative Tools                                                  control admintools
3. Command Prompt                                                     cmd
4. Event Viewer                                                             eventvwr.msc
5. Registry Editor                                                           regedit
6. Remote Desktop                                                        mstsc
7. Network Connections                                                ncpa.cpl
8. Services                                                                     services.msc
9. System Configuration Utility                                        msconfig
10. Task Manager                                                            taskmgr
11. System Properties                                                      sysdm.cpl
12. Windows Firewall                                                      firewall.cpl
13. Local Users and Groups                                             lusrmgr.msc
14. Date and Time Properties                                           timedate.cpl
15. Display Properties                                                      desk.cpl
16. Notepad                                                                    notepad
17. Calculator                                                                  calc
18. Shuts Down Windows                                               shutdown

for more commands

http://www.symantec.com/connect/articles/list-run-commands-windows-7-and-8

adding Display method in Table level fieldgroup

AOT>Table>LanguageTable.

Warning: Field 'Group' must be filled in.

The above Warning message "Field 'Group' must be filled in" pops up.  But, there is no 'Group' field.

Solution: Group is nothing but a CustGroup or VendGroup field.
 go to table level find out CustGroup r VendGroup field and set mandatory field YES to NO  or find the control and fill in form level.

display and edit methods

display():
The display method modifier is used to indicate that a method’s return value is to be displayed on a form or a report. if you want to edit the value use a edit method. the display method using Table methods,Form methods, Form DataSource methods,Report, Report Design methods.

Write your display methods on a table. You can use the same code in several forms or reports. 

display methods are called each time the form is redrawn. They should not contain complex and  time consuming calculations.

To create a display method, place the display keyword immediately in front of the method’s return type.

Ex: 

display AddressStatename stateName()

{

    return AddressState::find(this.CountryRegionId, this.State).Name;

}

display methods must have a return type. The return value is typically a calculated value (for example, a sum).

There should no parameters in a display method unless it is on a form data source where you must include the data source as a parameter. 

For example:

display boolean displayOperations(AssetGroup _assetGroup)

Note: You must use display on a form data source method when the return value is to be shown on a grid control.

AOT>Forms>AssetGroup.

edit():

The edit method modifier is used to indicate that a method’s return value is to be displayed on a form, and users can edit that value. If you don't want users to edit the value, use a display method.

Use the edit method modifier on Table methods, Form methods, Form data source methods.

Write your edit methods on a table. You can use the same code in several forms.

edit methods are called each time the form is redrawn. They should not contain complex and  time consuming calculations.

Create an edit method on a form or table.

1. Place the edit keyword immediately in front of the method’s return type.
2. Create a Boolean parameter called Set. It is used to determine whether the user has entered anything into the control.
3. create a second parameter to hold the values that the user has entered into the control.
4. If the edit method is on a form data source, create a third parameter for the data source. Place this parameter after the Set parameter.
   Ex: AOT>Table>CustTable>Methods>edit ContactPersonName
   
   
   edit ContactPersonName editContactPersonName(boolean _set, ContactPersonName _name)
   {
       return this.CustVendTable::editContactPersonName(_set, _name);
   }
   
   
   Form Level: AOT>Forms>BOMCalcSum>Methods>editCostSales

How to use query classes in table level

AOT>DataDictionary>Tables>CustTable>Methods>getCurrenicesForAllTrans