Can runtime do odbc & reports

[LC]

Hello everyone,

I'm trying to develop a Filemaker solution for our company. We have 3 offices spread throughout the state. I considered IWP but the lack of reporting hurts. My question is if I upgrade to Advanced and created a runtime standalone will:

1. All the scripts work,unlike IWP?

2. Get all the reporting of 8.5?

3. Save to a SQL base database using the execute SQL script? (I will be placing a DSN on all of the admin computers).

[Genx]

Hi and welcome to the forums!

1. All the scripts work,unlike IWP?

-- Yes

2. Get all the reporting of 8.5?

-- Yes

3. Save to a SQL base database using the execute SQL script? (I will be placing a DSN on all of the admin computers).

-- Possibly? You can't connect to the runtime as an ODBC source, but i'm not sure that would stop the Execute SQL statement from operating seeing as you aren't trying to use it as a source in the common interpretation of the statement -- i.e. you're not connecting from the SQL DB to the runtime but rather connecting to the SQL DB via a SQL ODBC driver to update your SQL DB using a script step... So, i would think so, but you might want someone to confirm that.

[comment]

2. Minus the 'Save As PDF' option.