0 Replies Latest reply on Apr 24, 2009 2:41 PM by dwestendorf

    SQL Error #3128, works in OSX, fails in Windows

      Hello all,

       

      I'm populating a database. Some records work just fine, while others do not. I get the following error:

       

      [app:/index.html][15:36:02] ActiveRecord: Adapters.AIR.executeSQL: INSERT INTO products (description,division,gv1,gv2,part_number,quantity,tv1,tv2,upc,warehouse) VALUES (?,?,?,?,?,?,?,?,?,?) [BIKE SPEEDSTER S30 CD 20-sp.,Bike,021,,212043,6,S52,,886687466427,OG01]
      [app:/index.html][15:36:03] SQLError: 'Error #3128', details:'', operation:'execute'

       

      While the previous Insert workes just fine:

       

      [app:/index.html][15:36:02] ActiveRecord: Adapters.AIR.executeSQL: INSERT INTO products (description,division,gv1,gv2,part_number,quantity,tv1,tv2,upc,warehouse) VALUES (?,?,?,?,?,?,?,?,?,?) [BIKE SPEEDSTER S30 CD 20-sp.,Bike,020,,212043,0,XS49,,886687466410,OG01]

       

      Can anyone shed some insight on the issue? I'm using ActiveRecordJS.

       

       

      Thanks,

       

      Daniel