I have in my database a caracter's field wich contains sometines quotes.
exemple : JOURNAL DES "A NOUVEAUX"
I'm trying to replace or delate quote " by the following function but it doesn't work :
Set db = Client.OpenDatabase(DBNAME)
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "JOURLIB2"
field.Description = ""
field.Type = WI_VIRT_CHAR
a= "@Replace(JOURNALLIB;" & Chr(34) & Chr(34) & Chr(34) & ";"" "")"
field.Equation = a
field.Length = 100
Set task = Nothing
Set db = Nothing
Set field = Nothing
I tried the function @remove but I didn't succeed to handle the quote.
anybody has an idea ?
Last seen: 2 months 2 weeks ago
Joined: 11/29/2018 - 11:25