Re: SQL differences between Informix and SQL Server 6.5

"Igor Shpak" <I_SHPAK@IX.NETCOM.COM> wrote: :Are there any differences in the SQL statements between Informix and SQL :Server, from the Visual Basic 4.0 point of view. I am currently working on :a project in VM and SQL Server 6.5, but the client wants to move the DB :part of it to Informix 7.0 Are there in changes in my code or the SQL :statements that I have to be aware of, that will work with SQL server, but :not Informix? : :thank you for you time, Igor Shpak : :Please reply to my E-mail address... : :I_SHPAK@IX.NETCOM.COM As long as you use ODBC with no passtrough you should be ok. If you do use passtrough there are some differences that I don't know in detail. You can get an Informix manual off the net at http://www.informix.com/answers/answers/english/pubs.htm You are best off by the way if your client gets Informix ver. 7.22. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org