Comments by Member 11239384

Member 11239384 20-Oct-20 4:40am View

Deleted

how do i equate the left side and the right side?

Member 11239384 16-Jun-18 10:28am View

USE [Apartmentmanagementsystem]
GO
/****** Object: StoredProcedure [dbo].[Rento] Script Date: 6/16/2018 5:25:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[Rento]
@rent_id int,
@rent_fee varchar (255),
@late_fee varchar (255),
@due_date varchar (255),
@service_charge varchar (255),
@lease_id int,
@pay_id int,
@pay_date varchar (255),
@pay_amount varchar (255),
@receipt_no varchar (255)

as

begin

insert into Rent ( rent_fee,late_fee,due_date,service_charge,lease_id) values (@rent_fee,@late_fee,@due_date,@service_charge,@@IDENTITY)
select @rent_id=SCOPE_IDENTITY()
insert into Payment (pay_date,pay_amount,receipt_no,rent_id) values(@pay_date,@pay_amount,@receipt_no,@rent_id)
end

please show me how to do it correctly.pleeeeease

Member 11239384 16-Jun-18 8:57am View

yeah but follow up it has inserted null into column lease_id

should i have done something else on the parent side?

Member 11239384 16-Jun-18 8:15am View

thanks worked

Member 11239384 16-Jun-18 7:06am View

help

Member 11239384 16-Jun-18 6:02am View

ALTER procedure [dbo].[Rento]
@rent_id int,
@rent_fee varchar (255),
@late_fee varchar (255),
@due_date varchar (255),
@service_charge varchar (255),
@lease_id int,
@pay_id int,
@pay_date varchar (255),
@pay_amount varchar (255),
@receipt_no varchar (255)

as
select lease_id from Lease where lease_id=@@identity
if @rent_id=0
begin

insert into Rent ( rent_fee,late_fee,due_date,service_charge,lease_id) values (@rent_fee,@late_fee,@due_date,@service_charge,@lease_id)
select @rent_id=SCOPE_IDENTITY()
insert into Payment (pay_date,pay_amount,receipt_no,rent_id) values(@pay_date,@pay_amount,@receipt_no,@rent_id)
end

this is not working

Member 11239384 16-Jun-18 5:31am View

ok so how do i implement this in the current context please give me an example of stored procedure above done correctly.I am stuck.

Member 11239384 14-Jun-18 6:53am View

ok what about selecting from both tables after entering tenant id on the application side it is displaying the first row no matter what i input as id

Member 11239384 12-Jun-18 4:29am View

now i have tried it like this and it is not updating .cause it doesn't know which id to update.should i create a textbox to enter the id ?

Member 11239384 12-Jun-18 4:15am View

yes but how will the system know which record to update because cant feed it with tenant-id it is autogenerated.And i am not using a grid view where i can highlight record to update

Member 11239384 19-May-17 5:12am View

can you recomend any references?

Member 11239384 19-May-17 4:42am View

let's say a hard drive fails but u have its image in an external hard disc.how then do you search for an application in that image?using C#

Member 11239384 18-May-17 8:00am View

any method there that can be tested.in any part of the project?

Member 11239384 18-May-17 7:12am View

have you opened in visual studio?what about enumerate() in installproprty class.can't u test it

Member 11239384 18-May-17 6:59am View

i meant the project.not the code example given.

Member 11239384 24-Nov-14 11:32am View

there are also reference market prices e.g 30% will buy at$20 when brands are selling at $17,$21,$23 .i am looking at the points of intersection with the line for refernce prices but which point will be optimal to balance market share and profits

Member 11239384 24-Nov-14 2:28am View

Deleted

there are many articles in this forum and the authours want people to rate them so it is an article finding forum

Comments by Member 11239384 (Top 17 by date)