Showing posts with label inserting. Show all posts
Showing posts with label inserting. Show all posts

Sunday, February 19, 2012

array

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

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.