Board index » off-topic » problems with ms sql link
Dan
Delphi Developer |
Dan
Delphi Developer |
problems with ms sql link2003-12-26 05:39:58 PM off-topic10 Hi I have problems with MS SQL link. When I send to stored procedure parameter with value ' ', through BDE comes nil: in Dephi: storedprocedure.parambyname('a').asstring:=' ' result in MS SQL profiler: exec storedprocedure @a=nil I use Delphi 7, BDE component TStoredProcedure and BDE Native MSSQL driver - SQLMSS32.dll It looks, that in some way parameters are trimed. Where is the problem? |
Malik
Delphi Developer |
2003-12-27 10:08:51 PM
Re:problems with ms sql link
"Dan" < XXXX@XXXXX.COM >wrote:
QuoteHi storedprocedure.parambyname('a').asstring:='''' + ' ' + '''' Because if you are passing a string variable it should be quoted. So the BDE is not actualling making it nil. I hope it helps.. Regards ziya |