[Mysql-cocoa-users] Re: Just a thank you note

[Serge C. <co...@em...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi John

> Hi Serge,
>
> In the spirit of reporting good news to keep the spirits up I thought 
> I'd just drop you this quick note to say thanks for the effort you have 
> put into the framework so far and to let you know that my application 
> is now going well.
>
> I have many little parts to my application which are all being 
> developed simultaneosly, and this week was finally the time to get the 
> database integration code started.
>
> Well I have got some basic database access quite simply integrated with 
> my application in about two days (once I remembered to add the 
> framework to my project :-) But this was much less hassle than I 
> imagined.
>

It's nice to hear that my work is of some use to some one, thanks.

> I've only been caught by two little features (not of your code really 
> mainly mySQL)
>
> i) I tried reading from two different result sets at the same time 
> generated from the same SMySQLConnection object, and got caught out by 
> the fact that my results were interwoven (ie. you have probably used 
> msql_use_result() instead of msql_store_result().
> The solution was simple, just read the first set into an array and then 
> work from that
>

Strange, indeed to implement the dataSeek method for the SMySQLResult 
class I had to use mysql_store_result... In the mean time I've never 
tried myself to have two SMySQLResult myself (indeed I should have in 
MySQL Display, having two queries window at the same time : no problem 
as far as I remember). I'll check more extensivly.
(great if you can send me a code sneepet showing the problem).

> ii) How do I release a results set once I have finished with it? Just 
> in case I am working with  very large result sets (which I am not yet, 
> though I will be working with BLOBs later). I don't really want to wait 
> for the event loop to clear them out when the retain count for the 
> whole SMySQLResult object expires. The main reason for this is that my 
> core classes for my application will eventually be used in both Cocoa 
> desktop GUI applications and in command line utilities.
>

Normaly a release (or autorelease) to the SMySQLResult object should 
dealloc the memeory of the MYSQL_RES structure pointer...

> Anyway many thanks again, and I'll keep you up to speed on progress.
>
>
> JOhn
>
>

Serge.

- ----------------------------------------------------
Serge Cohen

GPG Key ID: 1024D/69B1D346
- ----------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (Darwin)
Comment: For info see http://www.gnupg.org

iD8DBQE80QSSMygj1Wmx00YRAhWVAJ9p43FkT5+oO9wP7kCk6bRfaYCamgCfWm3Z
aCewhjv/xJVMdbi80L9A0Tw=
=diZ9
-----END PGP SIGNATURE-----