InfoQube IM - Community

Submitted by ethanrox on 2016/03/28 09:10

Currently testing the Smart Fields functionality, running the examlpe for URLLink field which should display "Link" pulling the data from the URL field.

I copy/pasted the example code to the options section in the URLLink Field Management from here:

Name: URLLink
Type: Text
Options: <source>SELECT IIf([URL] Is Null,"","<A href='" & [URL] & "'>Link</A>") AS URLLink, ¯qURL.ItemID
FROM ¯qURL
WHERE (((¯qURL.FieldID)=15) AND ((¯qURL.URL) Is Not Null));
</source>

I restarted InfoQube as suggested.

I get this error message when I refresh the grid

Comments

Hi !

I just tried it in the sample IQBase and it works just fine... Note that the reference to fieldID=15 is not required as the URL field ID is 15, so on need to filter on this. I've updated the referenced page

Perhaps a type on your part ?

BTW, no need to restart IQ for such changes

Pierre_Admin

IQ Designer

Got it.

When I copy pasted the code "¯ "got pasted as "?". Have to find a way to get it through keyboard input I guess :)

EDIT: just out of curiosity I typed ä the German character in the Options input -> did not get it. So there might be a Unicode issue again.

1. Humm strange. Are you using a clipboard handler other than the Windows one

2. True, not all UI is Unicode compatible. I'll update that one in v74 (though ä hardly requires Unicode AFAIK...)

Pierre_Admin

IQ Designer

No I am not? Unless there is some ghost clipboard handler going on in the background that does not support UniCode (don't want to be mean :), maybe there is a virus, you made me think about what's going on there...)

But I just typed "ä" and it did not display properly.

Definitely a code page issue then. In a command prompt, type chcp and report back the number reported

(Press Start and type CMD to open a command prompt)

Pierre_Admin

IQ Designer

No Number. "Not recognized ..."

Managed to fix things though. Changed my System Locale to English(United States) and it seems to be working now.

OK... in the control panel > Region > Administrative tab, report back the Current language for non-Unicode programs

Pierre_Admin

IQ Designer

>Changed my System Locale to English(United States) and it seems to be working now

Yes, for my info, what was it before, so I can test it ?

Pierre_Admin

IQ Designer

Bulgarian :)

OK, that explains it... and does it need to be Bulgarian ?

Pierre_Admin

IQ Designer

Well, not really. It would not inconvenience me to have it in English.

I guess this solves it :)

[quote=ethanrox]

Well, not really. It would not inconvenience me to have it in English. I guess this solves it :)

[/quote]

I'll update that one to use a Unicode control

But, of course, the complete conversion of the IQ UI to Unicode will not be complete, as there are older dialogs still using non Unicode control..., so I recommend leaving it to USA if you can...

Pierre_Admin

IQ Designer

Just FYI the right syntax seems to be without the " ' " apostrophe.

<source>SELECT IIf([URL] Is Null,"","<a href=" & [URL] & ">Link</a>") AS URLLink, ¯qURL.ItemID FROM ¯qURL WHERE ((¯qURL.URL) Is Not Null); </source>