Hi Tom,  I understand that you are not supporting QB2003 anymore, but I have a quick question and I was hoping that you could help.  I am trying to update a Custom Field in the Customer Table in QB2003, however, the UPDATEABLE and INSERTABLE columns are both 0 when running SP_COLUMNS CUSTOMER.  A Previous programmer used QODBC to create and update this column (or so I has presumed).  IS there a way to update this column or change the properties on it?  Or, is there an easy way to create a new column associated with each Customer where I can put new information?

THanks in advance for the help, it is greatly appreciated.

Best Regards,   Mike

Point Noted :-)  In the process of upgrading to GreatPlains as we type. :-)  I found your post on inserting into the CustomField table.  I tried accomplishing my update this way, but I cannot get the OwnerID field set properly.  If I set it to '0', it does not recognize the owner...if i set it to anything else, it does not understand my custom field name.  Here is my insert: 

INSERT INTO CustomField (OwnerID, Name, EntityType, EntityRefListID, Value) VALUES  ('0', 'CustomFieldISOGroupID', 'Customer', '6470000-1114449033', '2416531')

POST http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=2&post_id=31  states that OwnerID is alway '0'.    If i use '0' I get "Error 3000 - The given object ID '0' in the field OwnerID is invalid.

Any pointers?  I am basically trying to populate QB with my new IDs so that I can run exports of account balances for import into GreatPlains...then i will donate my QB2003 to a local museum if they would take it :-)

Thanks so much,  MIke