я буду очень благодарна, если кто-то может помочь.
Есть Stored Procedure
Когда пытаюць Execure, получаю такой error message:
Database C0038: Line 1: Incorrect syntas near '0'.

Long ls_oid_to_delete, ls_oid_to_keep, to_item_oid, from_item_oid
int to_aircraft_oid, to_city_oid, to_status_oid

ls_oid_to_keep = long(sle_1.text)
ls_oid_to_delete = long(sle_2.text)

to_city_oid = dw_1.getItemNumber(1, 'city_oid')
to_aircraft_oid = dw_2.getItemNumber(1, 'aircraft_oid')
to_status_oid = dw_3.getItemNumber(1, 'status_oid')

DECLARE test_inventory_merge procedure for sp_inventory_merge(:ls_oid_to_keep, :ls_oid_to_delete, :to_aircraft_oid, :to_status_oid, :to_city_oid) using SQLCA;

EXECUTE test_inventory_merge;
IF ( SQLCA.SQLCode <> 0 ) &
and ( SQLCA.SQLCode <> 100 ) THEN
MessageBox ( "Error", "EXECUTE failed" )
RETURN
END IF

MessageBox("Merge","Merge is Complete. Database has been updated.")
Close(w_inventory_merge)

ещё вот что...
Переменные декларированные как Long. ( в Window Script).
В Stored Procedure oни декларированы как инт.

это даст мне еrror наверное тоже?

SQL Server 2000

Procedure rabotaet otdel'no

EstetsВ какой момент ошибка, что в SQLCA.SQLErrText?
Почему не используется @Param1=Value1, @Param2=Value2,...?
Ошибка только в этой процедуре или в любой?

???

Pomeniala code na....

ls_oid_to_keep = long(sle_1.text)
ls_oid_to_delete = long(sle_2.text)

to_city_oid = dw_1.getItemNumber(1, 'city_oid')
to_aircraft_oid = dw_2.getItemNumber(1, 'aircraft_oid')
to_status_oid = dw_3.getItemNumber(1, 'status_oid')

DECLARE Merge_Inventory PROCEDURE FOR sp_Inventory_Merge
ls_oid_to_keep = :ls_oid_to_keep,
ls_oid_to_delete = :ls_oid_to_delete,
Aircraft_oid = :to_aircraft_oid,
Status_oid = :to_status_oid,
City_oid = :to_city_oid ;


Execute Merge_Inventory();


Error:

Database C0038: Line 1: Incorrect syntax near "=".
Warning C0014: Undefined variable: merge_inventory
Error Syntax Error

REATE procedure dbo.sp_Inventory_Merge
@ls_oid_to_keep int,
@ls_oid_to_delete int,
@Aircraft_oid int,
@Status_oid int,
@City_oid int as


Declare @from_item_oid int,
@to_item_oid int,
@from_sn char(30),
@to_sn char(30),
@move_date Datetime


Select @from_sn = (Select Serial_Number from rotable_inventory where rotable_inventory.oid = @ls_oid_to_delete)
Select @to_sn = (Select Serial_Number from rotable_inventory where rotable_inventory.oid = @ls_oid_to_keep)
Select @from_item_oid = (Select Item_oid from rotable_inventory, item_master where rotable_inventory.item_oid = item_master.oid and rotable_inventory.oid = @ls_oid_to_delete)
Select @from_item_oid = (Select Item_oid from rotable_inventory, item_master where rotable_inventory.item_oid = item_master.oid and rotable_inventory.oid = @ls_oid_to_keep)

Select @move_date = (Select Max(inv_move_date) from inv_move_log where inv_oid = @ls_oid_to_keep)

update inv_move_log
set inv_oid = @ls_oid_to_keep,
upd_timestamp = getdate()
where inv_oid = @ls_oid_to_delete

update work_order_data
set inv_oid = @ls_oid_to_keep,
upd_timestamp = getdate()
where inv_oid = @ls_oid_to_delete

update wo_inv_action
set inv_oid = @ls_oid_to_keep,
upd_timestamp = getdate()
where inv_oid = @ls_oid_to_delete

update mc_rotable
set inv_oid = @ls_oid_to_keep,
upd_timestamp = getdate()
where inv_oid = @ls_oid_to_delete

update purchase_order_data
set inv_oid = @ls_oid_to_keep,
upd_timestamp = getdate()
where inv_oid = @ls_oid_to_delete

update rotable_inventory
set status_oid = 2428,
upd_timestamp = getdate()
where oid = @ls_oid_to_delete

delete from rotable_inventory where oid = @ls_oid_to_delete

Insert into Inv_Move_log (inv_oid, create_Date, To_on_aircraft_oid, To_city_oid, To_inv_status_oid, inv_move_date, From_serial_no, To_serial_no, From_Item_oid, To_item_oid, upd_timestamp)
Values(@ls_oid_to_keep, getutcdate(), @aircraft_oid, @city_oid, @status_oid, @move_date, @from_sn, @to_sn, @from_item_oid, @to_item_oid, getutcdate())
GO

Rabotaet.

Spasibo bol'shoe vsem za pomosch.

Esche Vopros...
Kak sozdat' executable file (.exe) iz .pbl?