Using WebSphere MQ (still MQSeries for most of us) and the related products abbreviated WPM and alike from Microsoft .NET applications can be painstaking. While there are enterprise application integration solutions and BizTalk Server can help quite a bit with connecting to the IBM MQ world, you are...
As in every reporting system, one of the problems that you often meet in DataDynamics ActiveReports is how to control number of records in the subreport that will be displayed on the page. The actual problem I had was following: on a financial document (order list), I had to create report, which contains...
And now something totally wierd: if anyone has had the task to convert data from Clarion's TPS database files (anyone still remembers Clarion?), (s)he will have a problem of converting date fields. Clarion stores dates as long values in it's own format, which is not Unix Timestamp or anything...
If you would ever, from whatever reason, need to check/validate/list foreign keys in the MS SQL 2000/2005 database, here is the magical query you won't find on msdn: SELECT sysforeignkeys.constid, sysforeignkeys.fkeyid, sysforeignkeys.rkeyid, sysobjects.name as keyname, soFK.name AS firsttable, soRK...
Since the last month both Microsoft and MySQL AB have proudly, with lot of bells and whistles, announced their cooperation (MySQL AB has became an Alliance Member of the Microsoft Visual Studio Partner Program) , and since the information on using MySQL database as data backend for development of .NET...