From: "Joel Burton" <jburton@scw.org>
Organization: Support Center of Washington
To: karasiov@mediatech.ru
Date: Thu, 31 Aug 2000 14:35:51 -0400
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: convert from access
CC: pgsql-general@postgreSQL.org, pgsql-interfaces@postgreSQL.org
Message-ID: <39AE6D47.18613.F20E023@localhost>
In-reply-to: <00083121004006.01123@localhost>

> 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)