Professional Web Applications Themes

Can not open resultset - MySQL

Dear all, could someone help me in such problem: in a loop a make a lot of (ca.1500) inserts to table1. I the some time I make select query on another table and sometimes (not allways) during this query I get an error: " Can not open resultset". How it is possible ? This program is written in Delphi with components Zeos. best regards Rob...

  1. #1

    Default Can not open resultset

    Dear all,
    could someone help me in such problem:
    in a loop a make a lot of (ca.1500) inserts to table1. I the some time I
    make select query on another table and sometimes (not allways) during this
    query I get an error: " Can not open resultset". How it is possible ? This
    program is written in Delphi with components Zeos.
    best regards
    Rob


    Rob Guest

  2. #2

    Default Re: Can not open resultset

    what language are you using - SQL or PHP or ... or ...

    Your system apparently does not have the memory resources or the table
    you are querying is locked at the time of the query...

    commit often.

    It is possible because you are using brain-dead wysiwyg tools...

    onedbguru@firstdbasource.com Guest

  3. #3

    Default Re: Can not open resultset

    This is an old post but could be usefull for others,
    if you have acces to the source code, compile once again, but first check it:

    Probable a SQL query is done but the query (TzQuery )used for it is disabled at design time. But at runtime is enabled, the component tries to get a result, here the error appeards.

    Comment it and try again

    datos.DataModule1.radios.SQL.Text:='INSERT INTO transacciones( dni_receptor) values(''ABC'')';
    //Tzquery1.Active:=true;
    datos.DataModule1.sql_gen.ExecSQL;
    for doing the query is not required that query is active.

    www.cromosoft.com
    ramiro Guest

Similar Threads

  1. Resultset Comparison
    By alagukannan in forum Coldfusion Database Access
    Replies: 1
    Last Post: December 8th, 07:59 PM
  2. Single Quotes in resultset
    By timstsprymsn in forum Macromedia ColdFusion
    Replies: 1
    Last Post: March 16th, 10:37 PM
  3. Procedure wrapper needs 2nd Resultset?
    By Jonathan Beam in forum ASP
    Replies: 1
    Last Post: September 27th, 03:31 AM
  4. ResultSet is not updatable.
    By xixi in forum IBM DB2
    Replies: 7
    Last Post: August 7th, 10:53 PM
  5. resultset.close()
    By xixi in forum IBM DB2
    Replies: 3
    Last Post: July 14th, 05:04 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139