Solved Sqlserver Cast error on Bind

General discussion forum about all databases other than SqlBase.
ianrudge

Sqlserver Cast error on Bind

Post by ianrudge » 05 Apr 2011, 11:00

6.0SP1
This works
select employee.emp_id
from employee,jobs,train_record where employee.emp_id in (select emp_id from career where status = \'C\' and dept_id = ' || fQuoteString( sSelectedDept ) || ')
and employee.emp_id = train_record.emp_id and employee.job_id = jobs.job_id ' || sLongTSick || '
and jobs.volunteer = :sNo and personnel_stat = \'C\' into :colEmp_id

but this doesn't
select employee.emp_id
from employee,jobs,train_record where employee.emp_id in (select emp_id from career where status = \'C\' and dept_id = :sSelectedDept )
and employee.emp_id = train_record.emp_id and employee.job_id = jobs.job_id ' || sLongTSick || '
and jobs.volunteer = :sNo and personnel_stat = \'C\' into :colEmp_id

Conrado Zavala

Re: Sqlserver Cast error on Bind

Post by Conrado Zavala » 11 Apr 2011, 19:14

Hello ianrudge:

I'm currently looking at your case. I will get back to you shortly.

ianrudge

Re: Sqlserver Cast error on Bind

Post by ianrudge » 12 Apr 2011, 09:57

Thanks - SP2 has resolved it

Conrado Zavala

Re: Sqlserver Cast error on Bind

Post by Conrado Zavala » 12 Apr 2011, 16:46

I'm glad to know that. Thanks you for your feedback.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests