Re: D5 + SQLSERVER

From: "Jean-Michel Granier" <jmgway@xxxxxxx>
Date: Fri, 19 May 2006 10:02:51 +0200

Hello Vitali,

no the problem is the same inside SqlAnalyser (sqlserver 2005).

regards,

Jean-Michel

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> a écrit dans le message de
news:4450d966@xxxxxxxxxxxxxxxxxxxxxxxxx

Could it happen that some of concatenated values in this expression

T2.code_div+'/'+T2.code_dr+'/'+T2.code_dp+'/'+T2.code_sv+'/'+T2.hg_idlevelh

are nulls? If so then CONCAT_NULL_YIELDS_NULL is involoved. By default,
ODBC(QA) and OLE DB(ADO) clients issue a connection-level SET statement
setting CONCAT_NULL_YIELDS_NULL to ON for the session when connecting to

SQL

Server, Probably BDE don't do that, which could explain yours issue.

Regards,
Vitali

Follow-Ups:
- Re: D5 + SQLSERVER
  - From: Vitali Kalinin

Prev by Date: Re: Working with ORACLE Stored procedures
Next by Date: Re: D5 + SQLSERVER
Previous by thread: Re: Working with ORACLE Stored procedures
Next by thread: Re: D5 + SQLSERVER
Index(es):
- Date
- Thread