How does a form link its controls to a SQL table's fields?

mfgibong

Hi,

New to Navision here. Hope someone can help.

The Change Log Entries form of Cronus Int'l is using SQL's Change Log Entry Table as the source. I wish to ask how exactly does Navision link the form's controls to SQL table? I've noticed that the field names used by the form's controls as sources are not exactly named as how SQL names its fields. Like for instance, the Navision form uses "Entry No." as the SourceExpr but if you will look at the SQL table the field is actually named as "Entry No_". In such case, I assume that Navision and SQL considers "." and "_" similar. Am I right on this? I noticed the same case in other fields with regards to "." and "_".

My second question is what about the fields "Table Name" and "Field Name" that are used by Navision's Change Log Entries Form...where does the form get values for these fields when SQL's Change Log Entry Table doesn't have such fields. I am thinking there might be some links to SQL in the Navision form that are hidden which I can't find. Please help.

Thanks!

kine

Characters are replaced as entered in "File-Database-Alter-Integration-Remove characters" - there are all chars that are replaced by _

FlowFields are not defined on SQL server. If you have some field in NA but not on SQL - field is calculated. Look into NA table definition into CalcFormula on this field and you see formula to calculate this field. You can take this formula and transcript it into SQL query.

dmccrae

Form controls dont map to SQL tables directly - they use Navision table object fields as source expressions. These table object fields are either corresponding to a SQL field or are calculated fields that the SQL table does not provide, but Navision calculates on the fly.