Announcement

Collapse
No announcement yet.

mouseptr question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    Scott Wolfington
    Member

  • Scott Wolfington
    replied
    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).]

    Leave a comment:

  • Eric Pearson
    Member

  • Eric Pearson
    replied
    > 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][email protected]</A>



    [This message has been edited by Eric Pearson (edited July 30, 2000).]

    Leave a comment:

  • Eric Pearson
    Member

  • Eric Pearson
    replied
    [ 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>

    Leave a comment:

  • Gregery D Engle
    Member

  • Gregery D Engle
    replied
    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

    Leave a comment:

  • Scott Wolfington
    Member

  • Scott Wolfington
    replied
    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).]

    Leave a comment:

  • Eric Pearson
    Member

  • Eric Pearson
    replied
    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>

    Leave a comment:

  • Scott Wolfington
    Member

  • Scott Wolfington
    started a topic mouseptr question

    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).]
Working...
X