Podskajite pojaluista sintax modify User Defined Function, dynamically.
Ia predpolagau doljno bit' chtoto like dw.modify tak je dlia User Defined functions in Database. Mojet net.. ia ne uverena.. ne nashla eto nigde on the web.
Spasibo..

Eto mne izvestno.. modify and Describe Datawindow eto poniatno.. moi vopros bil po UDF ( User Defined Function), ona je ne prinadlejit k datawidow, funczia stoit v Database

spasibo..

Server daet etot syntax...kogda ispolzuiu ego v PowerBuider poluchau errors..
USE [MISA]
GO
/****** Object: UserDefinedFunction [dbo].[Udf_Get_No_Of_KA_Delays] Script Date: 07/30/2009 10:44:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
create function [dbo].[Udf_Get_No_Of_KA_Delays] (@oid int )
Returns int
as
BEGIN
declare
@int_parm_out int

select @int_parm_out = isnull(count(oid), 0)
from Flight_Delay with (NOLOCK)
where flight_data_oid = @oid and
flight_delay.delay_code_oid in (74, 83, 84, 85, 86, 87, 88,89,90,128, 91, 96, 97, 98, 99, 100, 101, 120, 121)
Return @int_parm_out END

kak ia ponimau dynamic UDFF ne suschestvuet.. mojet est kakaia to drugaia vozmojnost eto osuschestvit'.. vot chto trebudetsa..
Datawindow osnovnoi SQL sleduschi..

Select flight_data.oid,

flight_data.flight_id,

aircraft_id,

'Origin'= dbo.udf_get_location_id_by_oid(flight_data.origination_oid),

'Destination'= dbo.udf_get_location_id_by_oid(flight_data.destination_oid),

/* 'Mission' = dbo.udf_Get_Mission(flight_data.origination_oid, flight_Data.destination_oid, flight_data.aircraft_oid, flight_Data.actual_time_out),

'Dev'= datediff(minute,flight_data.sched_time_out,flight_data.actual_time_out), */

flight_data.sched_time_out,

flight_data.actual_time_out,

flight_data.actual_time_off,

flight_data.actual_time_on,

flight_data.actual_time_in,



Mon = datepart(month, flight_data.actual_time_out),

'year' = datepart(year,flight_data.actual_time_out),

'No_Delays' = dbo.Udf_Get_No_Of_KA_Delays(flight_data.oid)



from flight_data ( NOLOCK) ,

aircraft_Data ( NOLOCK)

where

Flight_data.status_sym = 'Completed' and

Flight_data.type_oid not in (2886, 2880, 4301, 30, 2902, 4473) and



flight_Data.aircraft_oid = aircraft_Data.oid and

aircraft_data.status_sym = 'Active'

********
'No_Delays' = dbo.Udf_Get_No_Of_KA_Delays(flight_data.oid)
schitaet skolko delays dlia dannogo poleta.
Delay kod kotorie nado schitat' meniautsia s kajdim razom. Ia dumala esli ia izmenuy SQL v UDFF eto reshit mou problemu.. mojet ktoto podskajet kak esche mojno eto reshit.
Thanks...