Re: D5 + SQLSERVER

AdoConnection.Execute('SET CONCAT_NULL_YIELDS_NULL OFF');//switch it off to
simulate BDE
AdoConnection.Execute('SET CONCAT_NULL_YIELDS_NULL ON');//switch it on again
Still better would be to adopt yours SQL to process nulls gracefully. For
example you can use this construct: IsNull(<COLUMN_NAME>, '')
"Jean-Michel Granier" <jmgway@xxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:446d85b3@xxxxxxxxxxxxxxxxxxxxxxxxx
Vitali,

do you have an example to use this option in ado ?

Thank you

JM

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> a écrit dans le message de
news:446d7de9$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Jean-Michel Granier" <jmgway@xxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:446d7bae@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello Vitali,


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

regards,

Jean-Michel


Sure it is same since QA use ODBC, thus assigns CONCAT_NULL_YIELDS_NULL
to
ON, which is done by OLEDB provider also, but not done by BDE. You can
play
with Connection Properties in QA switch off "Set concat_null_yields null"
and see if it will make any difference.






.

Relevant Pages

  • SQL 2000 Timeout Issues Since Converting from BDE to ADO
    ... multi-user application which runs against either SQL ... 2000 or Oracle which we recently converted to ADO from BDE. ... application to use ADO basically by converting the BDE components to ADO ...
    (borland.public.delphi.database.ado)
  • Re: ADODataset.CreateDataset
    ... Especcially because if using SQL, a lot of data is entered twice, as the table has persistance columns. ... >>But how to get this memory table into a physical database, using ADO? ... with BDE it worked directly to the mdb file. ... ADO does not have a capability to create ...
    (borland.public.delphi.database.ado)
  • ADO Newbie Question
    ... MS SQL Server 2005 and ADO. ... I am working on some research to convert an application from BDE to ADO. ...
    (borland.public.delphi.database.ado)
  • Re: ADODataset.CreateDataset
    ... There is nothing built into ADO to do this. ... Most ADO databases use SQL DDL ... The capability to create tables is in BDE and the Access driver for BDE was ...
    (borland.public.delphi.database.ado)
  • Re: TDBLookupList does not highlight
    ... In BDE the Local SQL query seems Case Sensitive and I can use the UPPER ... In ADO it seems case INsensitive and I cannot change that. ...
    (borland.public.delphi.database.ado)