Re: Best way to use Microsoft SQL database in X#
Posted: Sun Nov 19, 2023 8:31 am
Hi Joe,
Well, I didn't exactly suggested to completely ditch VO, but since that you have an app working and delivered in X# (and no more in VO), I think it makes sense to now start developing and updating it directly in X#, instead of continuing to make the code changes in VO first!
Regarding replacing the standard VO.* libraries (which are X# compiled libraries though, they are not VO ones) with their XSharp.VO* equivalents, I think it's still too early for you to do that now, especially since bBrowser does not support them (yet, hopefully). My suggestion is to first just get comfortable using the new environment and start making the regular code changes directly in it.
As for moving from DBF to SQL, moving first to the new system classes would help, but I don't think it's mandatory, after all there are so many VO apps that did the move long before X# was created anyway. But I'm not the best person to talk about SQL and conversion from DBF, will let the experts step in.
Well, I didn't exactly suggested to completely ditch VO, but since that you have an app working and delivered in X# (and no more in VO), I think it makes sense to now start developing and updating it directly in X#, instead of continuing to make the code changes in VO first!
Regarding replacing the standard VO.* libraries (which are X# compiled libraries though, they are not VO ones) with their XSharp.VO* equivalents, I think it's still too early for you to do that now, especially since bBrowser does not support them (yet, hopefully). My suggestion is to first just get comfortable using the new environment and start making the regular code changes directly in it.
As for moving from DBF to SQL, moving first to the new system classes would help, but I don't think it's mandatory, after all there are so many VO apps that did the move long before X# was created anyway. But I'm not the best person to talk about SQL and conversion from DBF, will let the experts step in.