On Jun 8, 6:14 am, Zhi-Qiang Lei <[email protected]> wrote: > On Jun 7, 2011, at 12:19 AM, Jeremy Evans wrote: > > > On Jun 5, 11:05 pm, Zhi-Qiang Lei <[email protected]> wrote: > >> The TypecastOnLoad plugin works. Thank you. Here is one more issue. > >> When save a new record, it will raise a "Record not found" error. However, > >> the record is valid and it saved successfully. > > > This is probably a consequence of Dataset#insert not returning the > > autoincrementing primary key used. That requires patching the ado > > adapter to support such a thing, which would probably require adding > > an ado/access subadapter. In general the ADO adapter does not support > > that concept. The ado/mssql subadapter does support it, but through a > > fairly nasty hack. It looks like a similar hack may work on Access, > > I'll test it and see if it works. > > > Jeremy > > Hi Jeremy, > > Do you mind if I submit a issue on Github for tracking?
As far as I know, there isn't a solution to the issue, it's a limitation in WIN32OLE. If you can find a way to fix it, by all means submit an issue, but unless you can suggest a fix, I'd just close the issue since I don't think it is a problem in Sequel itself. Can't you just use the workaround I gave you? It should work fine with Access unless you have multiple processes modifying the Access database simultaneously. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
