Table and Field creation using FM 7 script engine

[Innocent Bystander]

Hi,

My company has developped an application using FM 6. They want to migrate to version 7, but their application is not easy to convert since it is splitted in multiple files (mainly due of the file size limitation). The converted application in FM 7 is REALLY slow and is still fragmented in multiple files.

Basically, by using XML export operations in FM 6 and some Java, I want to build a FM script that will be able to create the tables I need with their fields relations. I know that you can use SQL statements with the script engine, still a lot of fields or even data type cannot be created by using only SQL. Any suggestion about it or any hint about how I could use FM script to complete my tasks?

Thanks,

IB