User Tag List

Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

Thread: SQL Server

  1. #1
    Clicker Fusion 2.5 Developer

    Join Date
    May 2007
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server

    Hi.

    This is almost a major version of the extension adding more than 35 actions/extensions and correcting some bugs. Feedback is much appreciated. Link is at the bottom of this post.


    v1.5 - 20/07/2008
    =====================================
    - CHANGED: The first Next Row action will return the first row (the first time) for easy of use in a loop.
    - CHANGED: Most of the commands which return sizes/space used are now returned as integer.
    - FIXED: Small bug with field count not being properly reset between queries.
    - CHANGED: Menus were redesigned to accomodate all new commands.
    - CHANGED: Some menu items were slightly renamed for better readability.


    NEW ACTIONS

    - ADDED: Rename local server

    - ADDED: Create database
    - ADDED: Remove database
    - ADDED: Attach database
    - ADDED: Detach database
    - ADDED: Backup database
    - ADDED: Rename database

    - ADDED: Add user login
    - ADDED: Add database access to user
    - ADDED: Remove database access to user
    - ADDED: Change current user password
    - ADDED: Clear error log

    - ADDED: List connected users
    - ADDED: List tables
    - ADDED: List views
    - ADDED: List functions
    - ADDED: List procedures
    - ADDED: Error log

    - ADDED: Check database integrity
    - ADDED: Check database allocation
    - ADDED: Check table for errors
    - ADDED: Shrink database



    NEW EXPRESSIONS

    - ADDED: Get local server name

    - ADDED: Get current database
    - ADDED: Get datafile name
    - ADDED: Get datafile path
    - ADDED: Get datafile file size
    - ADDED: Get datafile max size
    - ADDED: Get datafile growth

    - ADDED: Get logfile name
    - ADDED: Get logfile path
    - ADDED: Get logfile file size
    - ADDED: Get logfile max size
    - ADDED: Get logfile growth

    - ADDED: Get database creation year
    - ADDED: Get database creation month
    - ADDED: Get database creation day
    - ADDED: List database properties

    - ADDED: Get table space used

    Attached files Attached files

  2. #2
    Clicker Fusion 2.5 Developer

    Join Date
    May 2007
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQL Server

    FIXED DOWNLOAD LINK:
    Attached files Attached files

  3. #3
    Clicker Fusion 2.5 Developer

    Join Date
    May 2007
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQL Server

    It seems that my ZIP files were getting corrupt somehow. Better start looking for another file compression software.

    Anyway, here is the REAL FINAL DOWNLOAD LINK :blush: :
    SQL SERVER

  4. #4
    Clicker Fusion 2.5 Developer

    Join Date
    May 2007
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL Server UPDATE v1.6

    New Version 1.6 - stability update

    - FIXED: Crash when returning fields from queries that failed to load.
    - FIXED: Crash when exiting the application without disconnecting.
    - FIXED: Some minor fixes to improve stability.

    DOWNLOAD LINK HERE

  5. #5
    Clicker Fusion 2.5 Developer

    Join Date
    May 2007
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    UPDATE: SQL Server v1.7

    SQL SERVER EXTENSION VERSION 1.7 FOR MMF2 STANDARD/DEVELOPER


    Here's a new update to the extension. See below for what's new. Thanks.


    v1.7 - 22/10/2009
    =====================================
    - CHANGED: Changed the first column index to 1 instead of 0. The same for rows.

    Explanation: If you want to select the first field from the row you have to use the
    expression "Get Field XXXX"this way: GetFieldString$(1) instead of GetFieldString$(0) as
    you used to do. This change was made because this was the only extension made by me that
    had the index starting at 0 instead of 1. So to not confuse users from extension to
    extension I decided to make all of them equal. That's why the SQL Server internal
    indexing system had to change.


    ACTIONS
    =======

    - FIXED: A small bug with "Next Row" that would sometimes not point to the right row.

    - ADDED: Go To Row
    Now you can jump directly to a row number of your choice

    - CHANGED: Make connection
    Make connection is now known as "Make connection (user/password)" because a new
    connection command is added (see below). Its functionality wasn't changed.

    - ADDED: Make Connection (Windows account)
    You now have another way to connect. This is the Windows account authentication
    meaning that if you configure SQL Server to accept Windows users to access the
    database directly from their accounts then this option will do that automatically.
    (There is a small example added - connection_example)

    - ADDED: Create file from SQL script
    You can create a file with an SQL script from a MMF2 string with this option.
    The good thing here is that you'll be able to encrypt all the file to protect
    its content from curious people.

    - ADDED: Execute SQL script from file
    From the file created in the command mentioned above, you'll be able to execute
    the contents of the file whether the data is encrypted or not.
    Warning: There are no resulting rows from this procedure.

    Notes: The two commands: "Create file from SQL script" and "Execute SQL script from file"
    could be used for the entire creation of your database, to set some values as default
    or for a version update system through script files.


    NEW EXPRESSION:
    ===============

    - ADDED: Get connection string:
    For advanced users who wish to get all the detailed ADO connection string used.


    DOWNLOAD LINK - SQL SERVER VERSION 1.7 EXTENSION FOR MMF2

  6. #6
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleSWF Export ModuleMac Export ModuleUnicode Add-on
    Pharanygitis's Avatar
    Join Date
    Aug 2006
    Location
    Germany
    Posts
    1,037
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Has anybody latest version (download) from this extension? The link is down..

  7. #7
    Clicker Fusion 2.5 Developer

    Join Date
    Jun 2011
    Location
    East of Africa
    Posts
    213
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  8. #8
    Clicker

    Fusion 2.5 DeveloperFusion 2.5+ DLCAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleUniversal Windows Platform Export ModuleSWF Export ModuleXNA Export ModuleInstall Creator Pro
    nivram's Avatar
    Join Date
    Jul 2006
    Location
    Bandon, Oregon
    Posts
    6,730
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)
    Pharanygitis. I sent you a pm

    Marv
    ​458 TGF to CTF 2.5+ Examples and games
    http://www.castles-of-britain.com/mmf2examples.htm

  9. #9
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleSWF Export ModuleMac Export ModuleUnicode Add-on
    Pharanygitis's Avatar
    Join Date
    Aug 2006
    Location
    Germany
    Posts
    1,037
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you

  10. #10
    Clicker Fusion 2.5 Developer

    Join Date
    Jun 2011
    Location
    East of Africa
    Posts
    213
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    any one with this extension in zip format. I cant install it in CF 2.5

Page 1 of 2 1 2 LastLast

Similar Threads

  1. server
    By rootg in forum Multimedia Fusion 2 - Technical Support
    Replies: 5
    Last Post: 25th May 2009, 02:48 AM
  2. web server?
    By Chokito in forum Multimedia Fusion 2 - Technical Support
    Replies: 3
    Last Post: 22nd January 2007, 01:41 PM
  3. New 24/7 VPS Mos Server
    By Patrick in forum Multimedia Fusion 2 - Technical Support
    Replies: 2
    Last Post: 20th September 2006, 06:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •