Re: [GENERAL] convert from access
От | Joel Burton |
---|---|
Тема | Re: [GENERAL] convert from access |
Дата | |
Msg-id | 39AE6D47.18613.F20E023@localhost обсуждение исходный текст |
Список | pgsql-interfaces |
> I have to remake PHP script (which full of Access SQL implementation) > for PostgreSQL. I have a some of strings like this: > > SELECT memmod.item, memmod.oempartno, memmod.sdescr > FROM memmod WHERE (InStr(1, [item], '".$edtPartNo."'));"; There are programs to help you move Access *tables* to pgsql, but I don't know of anything that would help you move VBA functions to Access. A chart of the 'usual' conversion (ie InStr, Left$, etc.) VBA <-> pgsql SQL would be a simple project for someone to start. (Any takers?) In the PostgreSQL + Access faq (www.scw.org/pgaccess), there are tips about many Access->PostgreSQL conversion issues, including how to rewrite some queries to support things like outer joins, transform queries, etc.; but nothing about VBA functions. If you come across such a resource, could you email me (or this list, or better still, the INTERFACES list), so it can be added to the FAQ? -- Joel Burton, Director of Information Systems -*- jburton@scw.org Support Center of Washington (www.scw.org)
В списке pgsql-interfaces по дате отправления: