I'm hoping that you long time list users are looking at the subject, shaking your heads and muttering, "Ha! That old chestnut!" :-)
In this Access db that I'm transferring to SAPdb are a number of updateable queries. They don't work when SAPdb replaces Access as the back end. I *think* it's because, from the SAP docos, a result table is updateable if it is a named result table, ie, it must not have been generated by a select statement. It seems as if the way to create a named result table id with the statement DECLARE <name> CURSOR FOR <select statement>. This syntax is not allowed in Access as far as I can see, so it has to be entered in a Pass through query. But (AFAIK) passthrough queries in Access may not return updateable recordsets. So I'm stumped. Is there a way to run an ad-hoc query from Access to SAPdb and get an updateable recordset? Thanks hugely Alan Graham _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
