Skip to content

self.svars has to be corrected #45

@ShamilS

Description

@ShamilS

self.svars in code/export-msaccess-sql.py :

    self.svars = {
        'dao_types': {
            1: "Boolean",
            3: "Integer",
            4: "Long",
            5: "Currency",
            7: "Single",
            8: "Double",
            9: "Date",
            10: "Text",
            11: "Binary",
            12: "Text"
        }}

has to be corrected to something like the following:

     self.svars = {
        'dao_types': {
            1: "Boolean",  # dbBoolean
            2: "Byte",     # dbByte
            3: "Integer",  # dbInteger
            4: "Long",     # dbLong
            5: "Currency", # dbCurrency 
            6: "Single",   # dbSingle
            7: "Double",   # dbDouble
            8: "Date",     # dbDate
            9: "Binary",   # dbBinary
            10: "Text",    # dbText
            11: "Binary",  # dbLongBinary 
            12: "Text"     # dbMemo
        }}

see: DataTypeEnum enumeration (DAO)

P.S. Thanks! MSAccessToSQL is a great (time-saving) tool for my current project - it's right to the job - I'm using it together with AI-tools to generate some boiler-plate code on C#.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions