why DBD::ODBC (which wrote to the scalar) might need to call SvSETMAGIC?
To assign a value to a scalar, there are a few steps to follow.
- Make sure the scalar has the slot (IV, PV, etc) you need by upgrading the structure if necessary.
- Place the value in the appropriate slot.
- Set the flag indicating there's a usable value in the slot you populated.
- Call SvSETMAGIC to let magic respond to the new value if appropriate (if SMG=1). This will end up calling STORE for tied variables, for example. In this case, I expect that it will clear the precomputed length of the string.
To obtain a value from a scalar, the same is done in reverse.
- Call SvGETMAGIC to populate the scalar with the a value. (This will end up calling FETCH for tied variables, for example.)
- Coerce the scalar into the requested type if necessary. (This may requiring upgrading the scalar).
- Return the value in the appropriate slot.
Some macros and functions do more than one of these steps for you.
Setting $txt = $txt at the end of the loop makes no difference
No, at the start of the loop. After the fetch, but before you use it.
There's no get magic on the scalar (GMG=0), so the fact that the set magic wasn't called earlier work won't matter. But when the value is assigned back to the scalar, the assignment will properly handle the set magic.
If I'm right, I can provide a cheaper workaround than copying the string (which defies the purpose of binding).
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||