***********************
Your mail has been scanned by InterScan.
PT. AJ Central Asia Raya
***********-***********
Dear all,
Saya punya SP seperti dibawah ini
CREATE procedure sp_test1
@fperiod datetime,
@tperiod datetime
as
select * from production where lastupdated between @fperiod and
@tperiod
GO
Dengan table seperti berikut
CREATE TABLE [Production] (
[Branch] [char] (3) NOT NULL ,
[Period] [char] (6) NOT NULL ,
[LastUpdated] [datetime] NULL ,
[District] [char] (2) NOT NULL ,
[Unit] [char] (2) NOT NULL ,
[Rank] [char] (1) NULL ,
[Pos] [char] (4) NULL ,
[StartingDate] [datetime] NULL ,
[EffectiveDate] [datetime] NULL ,
[TerminationDate] [datetime] NULL ,
[Remarks] [varchar] (30) NULL ,
) ON [PRIMARY]
GO
Sewaktu saya mau create datawindow
Muncul error
Cannot create datawindow
'Error converting data type varchar to datetime
1 execute dbo.sp_test1 ; 1 @fperiod = '0' , @tperiod = '0' '
PB yang saya gunakan PB 7
Mohon bantuannya, mengapa bisa muncul pesan seperti diatas, padahal
sudah sama2 datetime
Tks
Seluya
[Non-text portions of this message have been removed]
-----------------------------------------------
INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
-----------------------------------------------
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
