Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Null error with copy/paste function--Access table with iSeries

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Null error with copy/paste function--Access table with iSeries

    If you have any blanks or nulls in any fields, you might try putting in a space or something like that. Of you could export your test table to the iSeries, which should create it with the right data types (according to Access ;-)). Brian

  • #2
    Null error with copy/paste function--Access table with iSeries

    I created a test table in MSACCESS and also a table with a "link" from an iSeries PF. Both tables having identical fields & sizes, when I copy from my "test table" and try to paste to the "link table", I receive this error: "You tried to assign the Null value to a variable that is not a variant data type." All data types in both the test and linked table are text types. Any thoughts? Diane

    Comment


    • #3
      Null error with copy/paste function--Access table with iSeries

      Brian, You're right, add the spaces and it's working fine. Thanks for the help. Diane

      Comment

      Working...
      X