I am getting an invalid object name ‘joboper’ in a piece of custom code in MES. It finds the labordtl table but fails when i try to dataset the joboper table. Any help would be appreciated.
Ummm, just curious, why are you connecting directly to your database with an SqlDataAdapter?
There are supported ways to do this.
1 Like
Existing old code i am trying to get working.
1 Like
I think I would be converting it over to something else.
That being said, change the order and fill joboper first and see if it fills and labordtl fails,
or fill a different dataset (ds2) with the other
Fill is probably not updating the schema on the second fill.
I tried adding a ds2 for joboper it still errors.
find out if dsJobOper is null
I am with @klincecum on converting, but it may need dbo or erp if you have added fields to JobOper.
1 Like