Databases
StackOverflow2013
Postsdbo
PO"out of memory" exception in CRecordset when selecting a LONGTEXT column from MySQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO"out of memory" exception in CRecordset when selecting a LONGTEXT column from MySQL
    primarykey
    data
    text
    <p>I am using CODBCRecordset (a class found on CodeProject) to find a single record in a table with 39 columns. If no record is found then the call to CRecordset::Open is fine. If a record matches the conditions then I get an Out of Memory exception when CRecordset::Open is called. I am selecting all the columns in the query (if I change the query to select only one of the columns with the same where clause then no exception).</p> <p>I assume this is because of some limitation in CRecordset, but I can't find anything telling me of any limitations. The table only has 39 columns.</p> <p>Has anyone run into this problem? And if so, do you have a work around / solution?</p> <p>This is a MFC project using Visual Studio 6.0 if it makes any difference.</p> <p>Here's the query (formatted here so wold show up without a scrollbar):<br /></p> <pre> SELECT `id`, `member_id`, `member_id_last_four`, `card_number`, `first_name`, `mi`, `last_name`, `participant_title_id`, `category_id`, `gender`, `date_of_birth`, `address_line_1`, `address_line_2`, `city`, `state`, `zip`, `phone`, `work_phone`, `mobile_phone`, `fax`, `email`, `emergency_name`, `emergency_phone`, `job_title`, `mail_code`, `comments`, `contract_unit`, `contract_length`, `start_date`, `end_date`, `head_of_household`, `parent_id`, `added_by`, `im_active`, `ct_active`, `organization`, `allow_members`, `organization_category_id`, `modified_date` FROM `participants` WHERE `member_id` = '27F7D0982978B470C5CF94B1B833CC93F997EE23' </pre> <p>Copying and pasting into my query browser gives me only one result.</p> <p>More info:</p> <p>Commented out each column in the select statement except for id. Ran the query and no exception.</p> <p>Then I systematically went through and uncommented each column, one at a time, and re-ran query in between each uncomment.</p> <p>When I uncomment the comment column then I get the error.</p> <p>This is defined as the following (Using MySQL): LONGTEXT</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAtes Goral
    1. USTony Fontenot
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO"out of memory" exception in CRecordset when selecting a LONGTEXT column from MySQL
      1. USdan90266
      1. VTFavorite
    2. VO
      singulars
      1. PO"out of memory" exception in CRecordset when selecting a LONGTEXT column from MySQL
      1. USDotNetRookie
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload