SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 11:39 PM
| ||||
| ||||
 Replace String in Database Hello, I want to replace in a table every driveletter "c:\" to "\\server\c\" But I do not now, why it doesn't work with the REPLACE funtion. Thanks Daniel -- Nachrichten an nospam [at] dseichter.de werden sofort gelöscht!!! Für E-Mail Kontakt bitte daniel [at] dseichter.de benutzen. Messages to nospam [at] dseichter.de will deleted immediately!!! To contact me please use daniel [at] dseichter.de.      |
|
04-09-2008, 11:39 PM
| |||
| |||
| Re: Replace String in Database "Daniel Seichter" <nospam@dseichter.de> wrote in news:c8v0uo$gok$1 @news.dtag.de: > Hello, > > I want to replace in a table every driveletter "c:\" to "\\server\c\" > > But I do not now, why it doesn't work with the REPLACE funtion. > > Thanks > > Daniel Potentially the '\' is a problem. Try 'c:~\' and '~\~\server~\c' in the replace function. This works for me: DEFINE VARIABLE cString AS CHARACTER INITIAL "C:\" NO-UNDO. cString = REPLACE(cString, "c:~\", "~\~\server~\c"). MESSAGE cString VIEW-AS ALERT-BOX INFO BUTTONS OK. HTH Kevin |
|
04-09-2008, 11:39 PM
| ||||
| ||||
| Re: Replace String in Database Hello Kevin, > Potentially the '\' is a problem. Try 'c:~\' and '~\~\server~\c' in the > replace function. This works for me: > > DEFINE VARIABLE cString AS CHARACTER INITIAL "C:\" NO-UNDO. > > cString = REPLACE(cString, "c:~\", "~\~\server~\c"). > > MESSAGE cString > VIEW-AS ALERT-BOX INFO BUTTONS OK. Thank you, it works fine now! Wish you a nice day Daniel Seichter -- Nachrichten an nospam [at] dseichter.de werden sofort gelöscht!!! Für E-Mail Kontakt bitte daniel [at] dseichter.de benutzen. Messages to nospam [at] dseichter.de will deleted immediately!!! To contact me please use daniel [at] dseichter.de. |
 |
« winning made easy
|
Combo box »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:09 AM.
