Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi...
am pretty new to QV.
problem below...
LOAD abc,
xyz,
abcd
FROM
[http://asdasds.pp.nnn.net:2334/.txt?....[]........]
**url is not real
my query above is a url(kdb). The query itself has a '[]', which seems to be interfering with the '[]' from the load statement.
whats the work around?
Thanks a lot.
Try using " " (double quotes) around the url instead of [].
Or
['http://asdasds.pp.nnn.net:2334/.txt?....' & chr(91) & chr(93) & '........']
-Rob
Thanks for the response, but I already tried both single and double quotes...
i found a way around...not a qv option though...
in this sql, 'if' statement is represented by '['...so i just removed the if condition and wrote the sql twice,
once each for the conditions that were in the if loop...n put the if in where