Announcement

Collapse
No announcement yet.

mouseptr question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mouseptr question

    Hey all,

    I'm experiencing some strange things with the mouseptr
    function (it's probably only strange to me because I
    probably don't know how it really works). At the
    beginning of this function I set the mouse pointer
    to 11 (busy) and at the end I set it back to 0
    (default). What's weird is that it goes back to 0
    (default) before the loop is done. Any ideas?
    This function get's called from the CALLBACK function
    of a DDT button. Thanks again for all your help!

    Regards,
    Scott
    ps. I XXX'd out all the SQLTools commands since I'm not
    sure if I'm allowed to post them.

    Code:
    FUNCTION MainAction(BYREF pUserChoices AS UserChoices) AS LONG
    
    
        LOCAL sSql         AS STRING
        LOCAL x            AS LONG
        LOCAL lStmtNumber  AS LONG
        LOCAL sResult      AS STRING
     
     
        MOUSEPTR 11
     
     
        'Let's create our SQL strings.
        sSql$ = BuildSqlStatement(pUserChoices)
     
     
        '#############################################################
        '#  Let's open the table and start looping through.          #
        '#############################################################
        lStmtNumber& = SQL_XXXXXXX(1)
     
        'Let's open our resultset.
        SQL_XXXXXXXX 1, lStmtNumber&, %IMMEDIATE, sSql$
     
        'Now let's loop through the resultset.
        DO
            SQL_XXXXXXXX 1, lStmtNumber&, %XXXX_ROW
            IF SQL_XXXXXXX(1, lStmtNumber&) THEN EXIT LOOP
     	
            'Do some stuff right here...
     
            x=x+1
     
            'Let's display some output.
            IF x MOD 100 = 0 THEN
                CONTROL SET TEXT hPage5Dlg&, %frmMain_lblRecordCount, STR$(x)
                DIALOG DOEVENTS
            END IF
     
            SLEEP(0)
     
        LOOP
     
        CONTROL SET TEXT hPage5Dlg&, %frmMain_lblRecordCount, STR$(x)
     
        MOUSEPTR 0
     
        'Close the SQL Resultset.
        SQL_XXXXXXXX 1, lStmtNumber&
     
        MainAction = 0
     
     
    END FUNCTION


    [This message has been edited by Scott Wolfington (edited July 30, 2000).]
    Scott Wolfington
    [url="http://www.boogietools.com"]http://www.boogietools.com[/url]

  • #2
    Scott --

    > I XXX'd out all the SQLTools commands
    > since I'm not sure if I'm allowed to
    > post them.

    I don't know the answer to your MOUSEPTR question, but please post all the SQL Tools source code you want!!! (I am obviously biased, but I'm convinced that if people really understood how easy SQL Tools was to use, especially compared to doing everything with the ODBC API, we'd see a lot more people ordering it!)

    And if you add this...

    [ CODE ]

    ...before your source code, and this after...

    [ /CODE ]

    ...it will be much easier for people to read, and you'll be much more likely to get responses. I had to add spaces before and after the square brackets to get them to display; you'll need to type them without the spaces. BTW you can go back and "fix" your previous message by clicking on the "Edit/Delete Message" icon at the top of the message.

    -- Eric


    ------------------
    Perfect Sync: Perfect Sync Development Tools
    Email: mailto:[email protected][email protected]</A>

    "Not my circus, not my monkeys."

    Comment


    • #3
      Thanks for the [ code ] tip Eric. It's interesting that the [ code ]
      tag doesn't preserve double carriage return/line feeds too. (Not consistenly
      anyway).

      Scott


      ------------------


      [This message has been edited by Scott Wolfington (edited July 30, 2000).]
      Scott Wolfington
      [url="http://www.boogietools.com"]http://www.boogietools.com[/url]

      Comment


      • #4
        Eric,

        Speaking of SQL Tools, at work we have this huge MRP system with
        over 6 gigs of databases and everyday we do about 200 dbf
        extracts for clients/co-workers for reports and information.

        We are wanting to automate some of our business and we can do
        this by reading the dbf files, now I'm not good with ODBC api at
        all so I was resorting to Visual Basic, the downfall of Visual
        Basic is that I have to install all the dependancies and
        that is a system administrators nightmare since I can't add
        it to the login script.

        How powerful is SQL Tools? Is it much faster then VB? How
        many functions do I need to call to display data? I am slowly
        learning SQL so that isn't a problem.

        Thanks

        ------------------
        -Greg
        -Greg
        [email protected]
        MCP,MCSA,MCSE,MCSD

        Comment


        • #5
          [ CODE ] doesn't preserve lines that are 100% blank. So just put a single "space" character on the lines that you want to appear as blank.

          -- Eric


          ------------------
          Perfect Sync: Perfect Sync Development Tools
          Email: mailto:[email protected][email protected]</A>

          "Not my circus, not my monkeys."

          Comment


          • #6
            > How powerful is SQL Tools?

            PowerBASIC Tech Support has requested (in the past) that questions like that be confined to the Third Party forum.

            If you re-post your question there, hopefully you'll get some answers from real-world SQL Tools users!

            -- Eric

            ------------------
            Perfect Sync: Perfect Sync Development Tools
            Email: mailto:[email protected]support[email protected]</A>



            [This message has been edited by Eric Pearson (edited July 30, 2000).]
            "Not my circus, not my monkeys."

            Comment


            • #7
              Gregery,

              I'm a VB programmer too and I've used DAO, RDO, ADO, and ODBC
              for accessing data. ODBC is definitely the fastest of the 4
              but it really is a nightmare. SQL Tools is really really fast
              and a piece of cake to use. SQL Tools is basically a library
              that sits on top of ODBC. I was starting to write my own library
              of include files for ODBC, but there really wasn't a need for
              me to do that since SQL Tools existed. It's as easy as using
              ADO, plus the only run-time file dependency would be the 150kb
              SqlTools dll. Buy it! You won't be disappointed. Eric has a 12
              line example on his website showing how easy it is to use.

              Scott


              ------------------


              [This message has been edited by Scott Wolfington (edited July 30, 2000).]
              Scott Wolfington
              [url="http://www.boogietools.com"]http://www.boogietools.com[/url]

              Comment

              Working...
              X