topic Add apostrophe symbol in an input box in QlikView

Add apostrophe symbol in an input box

Wed, 25 Nov 2020 16:16:04 GMT

Hey i have created an input box and every time i add an apostrophe symbol in it, the macro window pops up. How can i add an apostrophe symbol ( ' ) in an input box?

Re: Add apostrophe symbol in an input box

Anil_Babu_Samineni — Fri, 18 Nov 2016 06:44:32 GMT

Confusing, Where you want to add ' I understand in input box. In that, where?

Re: Add apostrophe symbol in an input box

tresB — Fri, 18 Nov 2016 06:46:55 GMT

In the Constraint tab, check if any constraint is enabled. Try enabling 'No Constraint' in the Input Constraint section.

Re: Add apostrophe symbol in an input box

Fri, 18 Nov 2016 06:53:47 GMT

Anywhere inside an input box

Re: Add apostrophe symbol in an input box

Fri, 18 Nov 2016 06:56:16 GMT

i have already enabled the "No constraint" dialog

Re: Add apostrophe symbol in an input box

tamilarasu — Fri, 18 Nov 2016 07:05:32 GMT

Hi Vikas,

What is the error message you are getting while enter the apostrophe symbol?

Re: Add apostrophe symbol in an input box

jonathandienst — Fri, 18 Nov 2016 07:07:50 GMT

That is not normal behaviour. You may have a on OnChange or OnInput trigger on the variable that is attempting to call a VBS macro script.

Re: Add apostrophe symbol in an input box

Fri, 18 Nov 2016 07:10:12 GMT

I am actually writing back whatever is written in the input box into a SQL database with the help of a macro. So whenever someone inserts an apostrophe symbol in the input box the macro window is opened.

Re: Add apostrophe symbol in an input box

Anil_Babu_Samineni — Fri, 18 Nov 2016 07:11:56 GMT

Can you share the macro?

Re: Add apostrophe symbol in an input box

hemanthaanichet — Fri, 18 Nov 2016 07:14:15 GMT

Hi Vikas,

Use CHR(39) for apostrophe.In Qlikview CHR(39) is for apostrophe

Regards

Hemanth

Re: Add apostrophe symbol in an input box

Fri, 18 Nov 2016 07:26:42 GMT

I have not assigned any trigger (OnChange or OnInput) to the variable which is storing the value of the input box

Re: Add apostrophe symbol in an input box

Fri, 18 Nov 2016 07:37:22 GMT

sub Cannotdecide_Rationale_SQLInsert

Const adOpenStatic = -1 ''these first two two lines have to be there when you are trying to insert into an external database

Const adLockOptimistic = -1

set Var_test = ActiveDocument.GetVariable("v_QVWB_CantDecide").getcontent

set Var_Row = ActiveDocument.GetVariable("v_ClaimID").getcontent

Set Var_Date = ActiveDocument.GetVariable("v_ModelRunDate").getcontent

Set objConnection = CreateObject("ADODB.Connection")

objConnection.Open "dsn=NEWDMNZ1D;User ID=********;Password=********"

Set objRecordSet = CreateObject("ADODB.Recordset")

var = Var_test.string

dom ="'"

row=Var_Row.string

Mdate=Var_Date.string

objRecordSet.Open "UPDATE NEWDMNZ1D.ADMIN.GHCMO_LCP_RESULTS_SET SET RATIONAL_FOR_DECISION_TXT = "& dom & var & dom &_

"Where (CLM_NUM_CD= '" & row & "' and MODEL_PROCESS_DT = '" & Mdate & "')" , _

objConnection, adOpenStatic, adLockOptimistic

end sub

Re: Add apostrophe symbol in an input box

tamilarasu — Fri, 18 Nov 2016 07:54:04 GMT

Change the below lines in your macro and try again. I replaced the variables with double apostrophe.

set Var_test = ActiveDocument.GetVariable("v_QVWB_CantDecide").getcontent

set Var_Row = ActiveDocument.GetVariable("v_ClaimID").getcontent

Set Var_Date = ActiveDocument.GetVariable("v_ModelRunDate").getcontent

set Var_test = Replace(ActiveDocument.GetVariable("v_QVWB_CantDecide").getcontent ,"'","''")

set Var_Row = Replace(ActiveDocument.GetVariable("v_ClaimID").getcontent ,"'","''")

Set Var_Date = Replace(ActiveDocument.GetVariable("v_ModelRunDate").getcontent ,"'","''")

Re: Add apostrophe symbol in an input box

Fri, 18 Nov 2016 09:27:58 GMT

hi,

i tried this but it is throwing an error since when i replace " ' " with " " ", the QlikView is reading the first two double quotes and reading the last double quote as incomplete (" " ")

Re: Add apostrophe symbol in an input box

Fri, 18 Nov 2016 09:33:27 GMT

Can you also tell me what happens if i have a OnChange or an OnInput trigger on the variable. Could this be a possible reason for input field not accepting a single apostrophe sign, please?

Re: Add apostrophe symbol in an input box

hemanthaanichet — Fri, 18 Nov 2016 09:36:45 GMT

Hi Vikas,

Try this:

set Var_test = Replace(ActiveDocument.GetVariable("v_QVWB_CantDecide").getcontent ," CHR(39) "," " ")

set Var_Row = Replace(ActiveDocument.GetVariable("v_ClaimID").getcontent ," CHR(39) "," " ")

Set Var_Date = Replace(ActiveDocument.GetVariable("v_ModelRunDate").getcontent ," CHR(39) "," " ")

Re: Add apostrophe symbol in an input box

Fri, 18 Nov 2016 11:58:15 GMT

hi Hemanth,

I tried this out also but the " " " at the last is incomplete, and this is what which is giving error

Re: Add apostrophe symbol in an input box

hemanthaanichet — Fri, 18 Nov 2016 12:35:39 GMT

Hi Vikas,

use single codes instead of double codes at the end

set Var_test = Replace(ActiveDocument.GetVariable("v_QVWB_CantDecide").getcontent ,' CHR(39) ',' " ')

set Var_Row = Replace(ActiveDocument.GetVariable("v_ClaimID").getcontent ,' CHR(39) ',' " ')

Set Var_Date = Replace(ActiveDocument.GetVariable("v_ModelRunDate").getcontent ,' CHR(39) ',' " ')

Regards

Hemanth

Re: Add apostrophe symbol in an input box

rubenmarin — Fri, 18 Nov 2016 12:44:54 GMT

Hi Vikas, I was about to answer something similar to what Jonathan saids...

When a macro throws an error QV opens the macro editor, this is what is happening to you so it seems that the apostrophe is creating an error in a macro.

Maybe when the macro uses the variable the apostrophe is breaking the code (probably it comments the code after the apostrophe comes to the macro)

If you have an OnChange or OnInput wich launches a macro (or updates another field or variable that launches the macro) the error will be thrown as soon as you change the variable value.