Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Import of Boolean Values from tables fail #11

Open
Xarno opened this issue Oct 28, 2013 · 0 comments
Open

Import of Boolean Values from tables fail #11

Xarno opened this issue Oct 28, 2013 · 0 comments

Comments

@Xarno
Copy link

Xarno commented Oct 28, 2013

Problem: There is an Casting error in this line: rs(fieldObj.Name) = Value
if the Field is an Boolean.
Possible, but not so good Patch:

@@ -760,6 +760,14 @@ Private Sub ImportTable(tblName As String, obj_path As String)
                     Value = Replace(Value, "\n", vbCrLf)
                     Value = Replace(Value, "\\", "\")
                 End If
+                'Only correct if the Fields are actually Booleans, and when using a German Version of Access.
+                If Value = "Falsch" Then
+                    Value = CBool(Value)
+                End If
+                If Value = "Wahr" Then
+                    Value = CBool(Value)
+                End If
+
                 rs(fieldObj.Name) = Value
                 C = C + 1
             Next
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant