executescalar

[inter]

Hello,

 

I have made an application where I execute an sql statement to the database. I have 3 sql statements.

1: I do a count for people based on the name

2: I do a count for people based on birth date

3: I do a count for people based on ID.

 

All 3 queries work in the database and also in my application on my computer. I use executescalar in the application.

 

But I have made a package to install on other computers. and when I start the programme on other computers... everything works Except for the second query .... there i execute a sql statement, in this stament I look for people based on the BIRTH DATE...

 

this is my query:

 

it works on my computer but not on the computer of someone else :s ...

 

Can anyone help ????

 

I get the next exception :s

 

 

An unhandled exception has occured in your application. if you click Continue, the applicaiont will ignore this error and attempt to continue. if you click Quit, the application will be shut down immediately.

 

ORA-01843: not a valid month

Edited September 2, 2005 by inter

[inter]

the country date format was set to american at the users computer while it was different on my computer

 

thx

[PlausiblyDamp]

How are you generating the SQL that contains the date?

[inter]

How are you generating the SQL that contains the date?

 

as a string.

 

but i have put to_date(date,'dd/mm/yyyy') around the date... now it works ...