There is a minor bug in the data migration wizard which prevents the wizard
from discovering which fields are NOT NULL. The attached patch should fix
the problem.
-Brage
*** frmWizard.frm.orig Wed Feb 12 14:39:44 2003
--- frmWizard.frm Wed Feb 12 14:25:00 2003
***************
*** 1627,1633 ****
szTemp1 = szTemp1 & " " & szTemp2
If chkNotNull.Value = 1 Then
! If catLocal.Tables(lstData.List(X)).Columns(newColumnArray(Y)).Attributes
And adColNullable = False Then szTemp1 = szTemp1 & " NOT NULL"
End If
szTemp1 = szTemp1 & ", "
End If
--- 1627,1633 ----
szTemp1 = szTemp1 & " " & szTemp2
If chkNotNull.Value = 1 Then
! If (catLocal.Tables(lstData.List(X)).Columns(newColumnArray(Y)).Attributes
And adColNullable) = False Then szTemp1 = szTemp1 & " NOT NULL"
End If
szTemp1 = szTemp1 & ", "
End If
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
