I am working on a procedure where Crystal SQL will update some custom fields I have in my Timberline Database. I know that the fields can be updated through ODBC, because I can access them through a Linked Access table and modify the data. However, when I try to do an update with Crystal SQL I get an "Access Violation," which means to me that Timberline is not allowing the update to occur.
1) Can Crystal SQL Designer do updates.
2) If so, why am I getting the Access Violation error when I try to update?
Thanks a ton!