October 12, 200421 yr Newbies Iam a beginner in FM. I have couple of problems working on it and would be glad if any of the 2 gets fixed. 1) Iam using FM7 pro to create a database whose records are imported from a MYSQL database server. I want to publish this form i created using FM7(to import the records) on the web and allow the user to import the records from the web. I know the curent version of FM7 does not support this feature on the web so any suggestion as to how this could be implemented differently. I definitely want to make this online so any suitable suggestions are greatly appreciated. 2) If in the worst scenario iam not able to import records directly from the web will it be possible to do it if manage to make a copy of the records in a FM7 file. What i mean by this is, if iam not able to connect to my MYSQL server using odbc can i atleast connect someway to my FM7 to access the records and copy that on the web. I hope i have presented my problem clearly. Urgent help required. Thanks in advance.
October 12, 200421 yr Use ODBC for this problem. You can do this on your local area network; afterall, an FM file which is on the Web can also be updated locally.
October 15, 200421 yr weird... if u want the data on the web, and ur ultimate source happens to be MySQL, u should use PHP directly. it's far better than relying on FM's IWP for everything. IWP is convenient, but with many limitations. for transfering data between MySQL and FM, ODBC should most certainly work.
Create an account or sign in to comment