hi,
I am having problem with inserting the progress data
to crystal report.
I am using Progress Database with Merant Progress SQL
driver. In my db, I have a table with a field defined
as extent 5.
it has the following values: 12 23 345 12 23. When I
place the field on the crystal report it displays
"12233451223". How am I suppose to make CR to display
every value seperately.
thanks in advance.
fatihadd command in the CR like this
select
( "PUB"."salesrep"."RepName" ) As Name,
( "PUB"."salesrep"."Region" ) As Region,
( PRO_ELEMENT("PUB"."salesrep"."MonthQuota",1,1) ) As January,
( PRO_ELEMENT("PUB"."salesrep"."MonthQuota",2,2) ) As February
FROM "PUB"."salesrep"
and than in the CR design drop field
name region January February
thanks all
Showing posts with label inserting. Show all posts
Showing posts with label inserting. Show all posts
Sunday, February 19, 2012
Thursday, February 16, 2012
Arithmetic overflow error converting expression to data type datetime.
Ya ? am taking this error message in Asp.Net and i am not inserting a new row my database.
i have a databese and my fields
EmailID-->int
EmailAdress-->varchar(100)
DateTime-->datetime
IPAdress-->char(15)
Please help me,thanks
Most likely a disparity between the application date format and the date format SQL Server 'expects'. (Application passing the date parameter in the form of dd/mm/yyyy, and SQL Server accepting that as mm/dd/yyyy -and the ensuing date is invalid.
Have the application pass the date parameter in the ISO form of: yyyy/mm/dd OR yyyymmdd.
Subscribe to:
Posts (Atom)