Database to array

Welcome to our brand new Clickteam Community Hub! We hope you will enjoy using the new features, which we will be further expanding in the coming months.

A few features including Passport are unavailable initially whilst we monitor stability of the new platform, we hope to bring these online very soon. Small issues will crop up following the import from our old system, including some message formatting, translation accuracy and other things.

Thank you for your patience whilst we've worked on this and we look forward to more exciting community developments soon!

Clickteam.

    Hi All

    I am wondering if it is possible to extract fields from a database table into an mmf array. I have had a look at ODBC but i have zero clue on how to use it.

    The database itself is password protected and i only need specific columns out of it.

    Anyone know if this is possible using the standard version of MMF2?

    What you are asking is possible, depending on the type of database. What kind of database do you need to access? The SQL Server object should work with MMF2 Standard, but it is for Microsft SQL Server databases only.

    lembi2001
    I think you may need the password in order to extract data.
    Also, do you have any experience using SQL code?
    e.g. select * from table_name
    If not Please login to see this link. is a great site to learn from.
    Also, have you looked at the ODBC example program which comes with MMF2? It shows a neat way of retrieving information using list objects.
    Whenever you retrieve from the ODBC object you need the following actions:
    New statement
    Send SQL command
    Get Row
    The rest then depends on whether you are retrieving a unique entry or several rows.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login