go to post Kyle Baxter · Sep 10, 2016 Ah licensing - I should have covered that. This does require an iKnow enabled license, but one of those should be easy to obtain, at least for development purposes. Just contact InterSystems or your already assigned sales representative.
go to post Kyle Baxter · Sep 10, 2016 This deserves a full answer that I will give on Monday - just want to put this here as a placeholder. But, spoiler, iFind is better.
go to post Kyle Baxter · Sep 9, 2016 You should use the newer stream implementations: %Stream.FileCharacter, %Stream.FileBinary, %Stream.GlobalCharacter, %Stream.GlobalBinary. Which one you use depends on what you want to do.
go to post Kyle Baxter · Sep 9, 2016 Excellent question.Of course, when you are going to be using iFind it does mean a heavier burden for your INSERT/UPDATE/DELETE functions. It also does take up more space on disk than a traditional index. The cost is going to depend on what kind of iFind index you are using and the size of the data being indexed. For my example an insert went from about 5 global references to about 200. But that is, of course, still fast due to the way Caché manages writes to disk. On INSERT went from 0.0002 seconds to 0.0032 seconds. So significantly slower, but still plenty fast. If you test a use case and come up with something different, post it here!!!
go to post Kyle Baxter · Sep 8, 2016 Caché fully supports INNER and OUTER JOINs, so I'm not sure what the question or problem is here. Do you have a query that's not working?
go to post Kyle Baxter · Sep 7, 2016 You can starting in 2016.2! Check out the field test and try it out! We want people who have Eclipse experience to help us make our new IDE as smooth and easy to use as possible.
go to post Kyle Baxter · Aug 30, 2016 Great question! The reason is that count(*) will read the smallest index, so having an index on ANY field made the count go quickly. So the customer had an indexed field that helped here, but not in general.
go to post Kyle Baxter · Aug 30, 2016 Well you could check if the first character is "<" or not. I am not sure you can write a valid Caché construct that begins with a less-than, while XML must, necessarily begin with one. So something like:s strm=##class(%Stream.FileCharacter).%New() d strm.LinkToFile(<file location>)if strm.Read(1)="<" return "XML"return "UDL"
go to post Kyle Baxter · Aug 29, 2016 You should contact the WRC at wrc.intersystems.com to help you debug this issue - we'd be happy to help!As a first guess, are you using Cache 5.0.2? If so those DLLs might be 32-bit and not match your 64-bit web server, causing some problems. I would suggest using the most recent CSP Gateway client, which you can also download from wrc.intersystems.com, and make sure you use 64-bit. From there, following those instructions has always led me to success in configuring webservers.
go to post Kyle Baxter · Aug 11, 2016 Sansa - you can check out the docs here:http://docs.intersystems.com/cache20152/csp/docbook/DocBook.UI.Page.cls?...let me know if that's not clear!
go to post Kyle Baxter · Aug 10, 2016 Shouldn't be too bad. I think all you need to do is to set up Caché as an ODBC Data source on the system. Steps are as follows: 1) Download Caché ODBC Driver from wrc.intersystems.com or .intersystems.com/pub/cache/odbc/2016 2) Go to Control Panel->Administrative Tools->Data Sources ODBC -> System DSN and create a new DSN with the InterSystems ODBC Driver. You will need to know the IP, Port, Namespace, and credentials for your Caché server. 3) Configure Crystal Reports to use that DSN. 4) ???? 5) Profit!
go to post Kyle Baxter · Aug 1, 2016 If you are going to do all the $C's, then you should definitely test $C(0) as well. Was that "" (empty) or " " (space)? I think you should test both. And also probably test with a longer string - something like 600+ characters (limit for subscripts), 33K characters (normal string limit), and perhaps even try to blow out the string stack and make sure things are handled "properly" (whatever that means for you).
go to post Kyle Baxter · Jul 14, 2016 I don't know the tutorial you're talking about, but it's got to be either onclick or onsubmit. onsubmit if you are submitting form data, onclick otherwise.
go to post Kyle Baxter · Jun 30, 2016 Looking at the log I see:DSN: TH_T2016_PRE-LIVE USERNAME: So you are logging in as unknownuser? If so, does that user have permissions?
go to post Kyle Baxter · Jun 30, 2016 You can enable the ODBC log by going to the 32-bit Driver Manager (C:\Windows\sysWOW64\odbcad32.exe) and opening your DSN. Click 'ODBC Log' which is a checkbox in the bottom-left of the screen. Then open WinSQL, and refresh the catalog, and close WinSQL again (this last piece forces the log to flush out of buffers onto disk). The log file will be in C:\Users\Public\Logs\CacheOBDC.log.
