Michael Hamlett
|
Posted: 01/19/2005, 11:21 AM |
|
how do you enter variable field names in SQL statements. the name of the field that is being put in the grid is dl_moduleid.
i want to pull the title of a module from a Modules table where the ModuleID of the modules table = the dl_moduleid variable on the grid
how do you code this statement. I realize the code can be put in the default value
using .NET
how do you determine the name of the form?
|
|
|
peterr
Posts: 5971
|
Posted: 01/19/2005, 2:45 PM |
|
I'm not sure if you want to use an SQL statement for the grid itself, or for a field on the grid. Assuming that you'd like to replace dl_moduleid with module title on an existing grid, you can use 2 methods:
a) Use the code shown at http://docs.codecharge.com/studio/html/ProgrammingTechn...gleDBValue.html
or http://docs.codecharge.com/studio/html/QuickStart/Creat...LabelValue.html
The name of the form is the name of the grid and is shown in the Project Explorer section.
b) A much better method is to join several tables and thus use several tables as the datasource for your grid, rather than one table. The Task Manager tutorial may be a good example: http://docs.codecharge.com/studio/html/QuickStart/Creat...itRelship.html?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|