New to SQL?
FM3 makes a conversion from TPS to SQL very much easier than any other method, BUT… SQL is a whole new ball game as it were. Do not add FM3 straight off and expect it to do what you want. It is vital you have done some research into SQL. Specifically how it works with Clarion, what some of the oddities are, and how they can be overcome with various tips and tricks. If you are expecting your dct and app to stay the same for a SQL backend, then you’re being a little too optimistic. SQL opens up a whole new world to your programming, and will be a very powerful tool, once used correctly. The nature of SQL is quite different to flat file systems such as TPS, and comes with more options or “variables in the equation” as it were. Below are a few tips of where to start with Clarion / SQL programming, and then some FM3 specific tips and tricks. Read the Clarion documentation under SQL Accelerator Drivers. We are building up a pretty good Clarion SQL Reference ourselves. See our FM3 SQL Docum
