Comments by Adam_adam

Adam_adam 17-May-17 3:14am View

I installed the Oracle Provider for OLE DB on the SQL server.

Adam_adam 11-Feb-16 14:15pm View

Thanks I did it..

Adam_adam 8-Nov-13 17:22pm View

Thanks.

Update stored procedure For Multiple Rows using from access project for updating multiple rows

I have two tables, Table 1 has three fields (a1,a2,a3) and table 2 has three fields (b1,b2,b3) I want to update table one base on table two when a1=b1 . This is essay in Microsoft access but I want t to do it in Microsoft Access project FORM. Sql server 2005 as a back end.

create
PROCEDURE [dbo].[t12]
@a1 nvarchar(255)
, @a2 nvarchar(255)
, @a3 nvarchar(255)
AS
BEGIN

DECLARE @S1 nvarchar(255)
DECLARE @S2 nvarchar(255)
DECLARE @S3 nvarchar(255)

SELECT @S1 = @a1

SELECT @S2 = @a2

SELECT @S3 = @a3

UPDATE t1
SET a1 = @s1, a2 = @s2, a3 = @s3
WHERE a1 = A1

End

Adam_adam 8-Nov-13 17:14pm View

Deleted

Thanks.

Update stored procedure For Multiple Rows using from access project for updating multiple rows

I have two tables, Table 1 has three fields (a1,a2,a3) and table 2 has three fields (b1,b2,b3) I want to update table one base on table two when a1=b1 . This is essay in Microsoft access but I want t to do it in Microsoft Access project FORM. Sql server 2005 as a back end.

create
PROCEDURE [dbo].[t12]
@a1 nvarchar(255)
, @a2 nvarchar(255)
, @a3 nvarchar(255)
AS
BEGIN

DECLARE @S1 nvarchar(255)
DECLARE @S2 nvarchar(255)
DECLARE @S3 nvarchar(255)

SELECT @S1 = @a1

SELECT @S2 = @a2

SELECT @S3 = @a3

UPDATE t1
SET a1 = @s1, a2 = @s2, a3 = @s3
WHERE a1 = A1

End

Adam_adam 21-Aug-12 8:10am View

thanks,I am a beginner in programming

Adam_adam 9-Aug-12 20:27pm View

When would i use abstract classes? How do i make a concrete class abstract?

Adam_adam 9-Aug-12 20:26pm View

Deleted

When i use abstract classes? How do i make a concrete class abstract?

Adam_adam 7-Aug-12 11:24am View

Thanks so much but is is same problem

Comments by Adam_adam (Top 8 by date)