mouseptr question

[Scott Wolfington]

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

[Eric Pearson]

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

[Eric Pearson]

[ 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>

[Gregery D Engle]

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

[Scott Wolfington]

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

[Eric Pearson]

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>

[Scott Wolfington]

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.

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