>I downloaded the latest beta of version 9.0 and I was wondering how difficult it will be to move from 7.0? Can anyone name a few of the top issues I will have to deal with? I have several applications written in 7.0 and I am wondering how many gotchas I will run into.

There shouldn't be many. However, as David noted, the most significant is in the way SQL statements are handled.

I've used a compiler directive to handle this. If the version is 70 or earlier, do nothing, otherwise, get the current setting (using SET("ENGINEBEHAVIOR") set it to 70 and then restore it afterwards.