| Use SQL Code to populate Data block in Forms [message #143279] |
Wed, 19 October 2005 14:00  |
sikorsky05
Messages: 40
Registered: October 2005
|
Member |
|
|
I currently have a view that populates a data block in forms.
Below is the code for view
CREATE VIEW DMC_INPUT_VIEW AS
Select a.mmc,a.GROUP_CODE,a.MODEL,a.archive_number,b.nomenclature
from gencaram_dmc_dtosc a, gencaram_prediction_data b
where a.mmc = b.mmc
and a.group_code = b.group_code
and a.model = b.model
and a.unit_price is null
and b.roll_id = 0
order by a.mmc;
Instead of using a view where can I imbed this code to populate
the data block .
I tried using a pre-query trigger and select the columns I needed into variables then assign the display item within the data block the variables that are associated with it ..
Didn't work
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
