Hello all, I'm a total newbie to Revolution and I have limited programming experience. I'm one of those people I read about in a recent post that needs a solution so I figure out how to program it for myself. My experience has mostly been with cold fusion and MS-SQL/Access. I've been leaning toward MySQL for a cross-platform project, but from the posts on this board I'm just about ready to look at PostgreSQL. I know there's some differences between all the SQL's but don't know much about what they are. In the example below I see a bit of code which illustrated that point and just worries me a tad because I find Access invaluable to build queries quickly and test them out and if I didn't have to change the code at all, that would be a big plus. So which of the sql flavors is closest to MSSQL and will go cross-platform?
Thanks, Oak > It's been my experience that if you ultimately want to move > to Oracle, > Postgresql is a better choice than mySQL because PG tries to be as > Oracle compatible as possible. I can also tell you from > experience that > if you want to move to MS SQL Server later, be VERY careful > about your > SQL since there are lots of things that are incompatible even with > "simple" SQL statements. For example, in Oracle/Postgres you > would join > two fields you would use something like SELECT last_name || ', ' || > first_name whereas in MS SQL it would be SELECT last_name + ', ' + > first_name (very VB like). _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
