Integration into an MS Access database
The Karyotype and Karyotypes classes are prepared for use with Visual Basic for Applications which is used e.g. in Microsoft Access databases.
The ISCNAnalyser must be registered with 'regasm ISCNAnalyser.dll /tlb' from its installation directory (normally C:\CyDAS\).
Then open your Access database, and therein the module where classes from the ISCNAnalyser dll will be required. From the menu "Extras" choose "References":
From the selection of available references, choose "ISCNAnalyser" and click "OK":
Now you can define a Karyotype variable in e.g. an event procedure of
your Access database:
Dim Karyotyp1 As New Karyotype
Let us assume, the karyotype is shown on the form in field "KARYOTYPK1". It can be checked as follows:
'define a string containing the karyotype formula Dim strKaryo1 As String 'read it from the form strKaryo1 = CStr(KARYOTYPK1.Value) 'pass it to the Karyotype object Karyotype1.setKaryotype (strKaryo1) 'notify the user if the karyotype has errors and leave the procedure If Not Karyotype1.isValidKaryotype Then strError = Karyotype1.getErrorDescription MsgBox ("Error in Karyotype1:" & vbCrLf & strError) Exit Sub End If
We can then calculate the gains and losses as well as the structural aberrations in the Simplified Computer readable Cytogenetic Nomenclature (SCCN). We assume that quantitative aberrations (gains and losses) are found in the field "QUANTS" and structural aberration are found in the field "QUALS". The banding resolution is set to 400 bands per haploid set.
'get quantitative aberrations Dim strQuant As String strQuant = Karyotype1.getQuantitativeAberrationsExpandedToResolution(eResolutionLevel_Resolution400Bands).toString 'get qualitative aberrations Dim strQual As String strQual = Karyotype1.getQualitativeAberrationsExpandedToResolution(eResolutionLevel_Resolution400Bands).toString QUANTS.Value = strQuant QUALS.Value = strQual
Further data may be calculated from he karyotype. For a more comprehensive list, see Analysing a monoclonal karyotype.