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.