Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
 Posted - 2004-12-29 : 23:53:01
|
| Hi,I called this query thru Visual Basic 6.0 Application which is connected to SQL Server 2000select replace(xx,' ','') from tt where no=333It worked wellBut the same query give error "Undefined function 'Replace' in expression."when Visual Basic Application is connected to Access 2000What causes this error?Madhivanan |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-12-30 : 09:04:59
|
| I don't believe that JET implements the replace() function. Do the replace AFTER you bring the data into your VB app. That is just return column xx as is, but then when you get the contents of that column in your VB app, do the replace.You can use Replace() in MS Access, but that's because while MS Access is loaded (the application, not a particular MDB file) it allows you to use VBA functions in your SQL statements. The application itself is processing those functions, however, not the DB engine. Just as you must do yourself when using VB connected to the DB engine.Makes sense?- Jeff |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2004-12-31 : 00:25:17
|
| Thanks for you reply jeffMadhivanan |
|
|
|
|
|
|
Replace in MS Access