[Gambas-user] Exotic Mysql Problem

[nigel at ...38...]

Alex,
Not sure how you are using this but I have successfully tested the following:

rResult = hConn.Exec("Select max(field) as maxfield from table")
.
.
.
PRINT rResult!maxfield
Does this help?
Nigel
> Message Received: Sep 29 2005, 08:27 PM
> From: "Alex Ciric" 
> To: gambas-user at lists.sourceforge.net
> Cc: 
> Subject: [Gambas-user] Exotic Mysql Problem
> 
> Hi.
> 
> In my application i have to use the mysql-macro max().
> If i do a query like "select * from table" this works very good with 
> gambas and i am able to use the results for further stuff.
> But if i do a query like "select max(field) from table" i get an error 
> message "field not found in myqsl table"
> 
> Does anyone know this behavior or have a workaround?
> 
> Sincerely
> 
> alex Ciric
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20050930/3214eb5c/attachment.html>