Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    51

    Angry Unanswered: GRR! GRR! and GRR!

    The GRR! pervasive docs say GRR! this:

    ***
    PRINT

    Remarks
    Use PRINT to print variable values or constants. The PRINT statement applies only to Windows-based platforms. It is ignored on other operating system platforms.

    You can use PRINT only within stored procedures.

    Examples
    The following example prints the value of the variable :myvar.

    PRINT( :myvar );
    PRINT 'MYVAR = ' + :myvar;

    The following example prints a text string followed by a numeric value. You must convert a number value to a text string to print the value.

    PRINT 'Students enrolled in History 101: ' + convert(:int_val, SQL_CHAR);
    ****

    So why does this (or any other obvious variant) compile, but hang when it runs?

    CREATE PROCEDURE testProc()
    AS
    BEGIN
    PRINT 'text = ' + 'text';
    END;

    GRR! thanks GRR!

    Kimball GRR!

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Where's the Pervasive engine? The PRINT statement displays where the engine is running. In a CLient/Server setup, this is at the server and the client may appear to hang. Check the server console if you're using a client/server engine.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Aug 2004
    Posts
    51

    Antics

    Ahhh... I see.

    Haven't run across that kind of stuff in a long time.

    There must be a whole lot of btrieve in the world to maintain. Why else would people work with this stuff?

    Thanks,

    Kimball

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Because it's cheap, easy, and rock solid. I've never run into a corrupted file that wasn't caused by hardware, I've never had to "reindex" or "compact" a database and I get lightning fast access through Btrieve while being able to report through SQL..
    That's why so many people use it.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Feb 2004
    Posts
    78
    When I first used PRINT, I too was suprised to see that it popped up on the server because it makes sense to return it to the client. Oh well. :-) They are getting better all the time with client side apps/support so I'm sure Pervasive will improve their sprocs. They are also looking for new programmers too. The client side apps could use a facelift.

    I think V8.5 is great if you need a rock solid low maint db with a small # of clients. But once you start going up with the # of clients, Sql Server offers SO MUCH MORE for the same amount money on a single or 2 processer server in a larger corporation.

Posting Permissions

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