D
d052057
Please bare with me. I am very new to IP2003. I am trying to default a text
field to a <user Name>. I pulled data (2 tables) from SQL server.
Main data source: I have - myFields
- queryFiels
+ q:table_a
_ dataFields
+ d:table_a
Secondary Data Source: I have - myFields
+ dataFields
+ d:employee
employee table contains user_name, login_id fields.
From data entry form I have
query form, edit form (repeated table), query button, add record, and submit.
On the Edit form, I have a field called Assigned to which is a drop down
list using data from <d:employee>.
So the app has been working for me. However:
I want to capture who updates the record in the database. I need to
get/capture login user name and default to a text field. In the d:employee
table, I have user login Ids and User Names defined (let say I have 10 users
in the list).
I want to loop the drop down list and compare <
hardcode-domain_name\>+<login Id> to Application.User.IsCurrentUser().
My question are:
How do loop thru the drop down list or dataquery() from XDocument.DOM?
If Application.User.IsCurrentUser(domain_name\login id) == true then
How I am to populate the LAST_UPDATED_BY field in the edit form as a
default name?
end if
The LAST_UPDATED_BY field is a readonly field on the edit form.
I came from Javascript and HTML background. This is my first IP2003
application and this is my night mare to go thru a different mindset of
developping codes...
I hope someone will help me with this.
Thank you
field to a <user Name>. I pulled data (2 tables) from SQL server.
Main data source: I have - myFields
- queryFiels
+ q:table_a
_ dataFields
+ d:table_a
Secondary Data Source: I have - myFields
+ dataFields
+ d:employee
employee table contains user_name, login_id fields.
From data entry form I have
query form, edit form (repeated table), query button, add record, and submit.
On the Edit form, I have a field called Assigned to which is a drop down
list using data from <d:employee>.
So the app has been working for me. However:
I want to capture who updates the record in the database. I need to
get/capture login user name and default to a text field. In the d:employee
table, I have user login Ids and User Names defined (let say I have 10 users
in the list).
I want to loop the drop down list and compare <
hardcode-domain_name\>+<login Id> to Application.User.IsCurrentUser().
My question are:
How do loop thru the drop down list or dataquery() from XDocument.DOM?
If Application.User.IsCurrentUser(domain_name\login id) == true then
How I am to populate the LAST_UPDATED_BY field in the edit form as a
default name?
end if
The LAST_UPDATED_BY field is a readonly field on the edit form.
I came from Javascript and HTML background. This is my first IP2003
application and this is my night mare to go thru a different mindset of
developping codes...
I hope someone will help me with this.
Thank you