Search Results

Author: Created: 2/17/2012 1:03 PM RssIcon
My personal blog on ITQuants
By Philippe Bonneau on 2/20/2014 6:39 PM

The Sophis API provides a method, CSRSqlQuery::MultipleWrite, which enables the developer to insert several records in one command, using arrays. Unfortunately, the method doesn't work fine if an error occurs during an insertion. In this case, next calls to this method will return unpredictable results, like not data found:

 This error occurs in fact only when the optional parameter that corresponds to the Oracle cursor is not filled. In this case, the global one which is used remains in uncertain state after the error. This error occurs at least on 5.3.4, 5.3.7 versions of Sophis Risque.

By Philippe Bonneau on 2/6/2014 6:59 PM

Even on x64 OS environment, it is not interesting to let the process using all the available memory. In some cases, like on CITRIX servers, the fact that one user consumes a lot of quantity will impact all users too. The goal of this post is to analyze all the possibilities that gives the MS SDK, in order to capture either bad memory allocation or to limit the process to a certain quantity of RAM.

By Philippe Bonneau on 1/21/2014 2:06 PM

Since it is not really clearly indicated in the documentation provided by Intel, it is possible to use the code coverage function provided by Intel XE Composer 2011 with VS2005. The only problem is that the results generated by the tool are not very user-friendly (html pages), and that some operations have to be done manually once the execution tests are finished.

By Philippe Bonneau on 12/6/2013 1:14 PM

When trying to use LoadGeneralElement with a CSREditList declared in the transaction dialog, without mapping it to an Oracle table, it does not work. The method will return true when getting some value of one cell, but the output address won't be filled, even if GetGeneralLineCount returns the right number of lines.

Some piece of code has to be added, using the internal callbacks.

By Philippe Bonneau on 11/25/2013 7:15 PM

I 've got today the following message, when I've tried to compile a dll that compiled fine before any change:

“LINK : fatal error LNK1561: entry point must be defined”

During my investigations for resolution, I've tried several tests that all failed:

By Philippe Bonneau on 11/14/2013 6:07 PM

In some cases, for example when changing user calculation preferences like the Delta Split, it is necessary to close the portfolio windows in order to take into account the modifications. Closing specific portfolio windows in Sophis Risque and Value is possible using the Windows SDK, MFC and the low level toolkit.

By Philippe Bonneau on 11/8/2013 11:42 AM

Fine, you just wanted to use a x64 OS, because you need to make a lot of calculations for financial softwares, make videos, to play or whatever else. You just forget that most of current applications are still in x86, with plugins in Explorer, providing right-click menu items, which, infortunately, won't appear in the x64 explorer, because the plugin is a dll which was x86 built and cannot be loaded by the x64 explorer...

By Philippe Bonneau on 10/2/2013 5:53 PM

In most cases, when installed on the local hard disk, there is no problem to launch Sophis Risque.

Launching Sophis Risque from a network shared folder is quite a little bit harder, due to the fact that Sophis Risque loads 3 .Net assemblies which have to be registered on the GAC.

By Philippe Bonneau on 9/27/2013 9:22 AM

When changing some stored procedure which generated doublons due to the fact that it made always insertions instead of insertions or updates, I got the fatal Oracle error - ORA-22920 row containing the LOB value is not locked - when trying to update the BLOB field.

By Philippe Bonneau on 9/19/2013 4:58 PM
When taking a look at some database fields which contain absolute and relative dates, it appears that both formats are stored in a numeric value. In order to know the real value that is stored, some conversion has to be made, using specific limits. In other words, it means that the Sophis Oracle num_to_date method has not be used alone.

Search blog