[Gambas-user] gambas 1.0.5

[Rolf Schmidt]

Hi Benoit

> > As wrote you in a previous mail, I'm working on a more complex database
> > system (using Postgresql). The querys sometimes uses sum() or max() or
> > avg() selects, which could not be handled with normal select functions,
> > so I use EXEC(). Now I would ask you if it is possible to pass the error
> > messages generated by postgresql directly into a message window. Until
> > now most time I get something like "error... unknown UTF8 char...) even
> > if just a comma is missing or (my current problem) if a conflict with a
> > constrait occurse.

>
> Error.Text gives you the error emited by the postgresql client library. I
> think the library uses System.Charset, so you must convert it to
> Desktop.Charset with Conv$() before using it in a message box.

I didn't do any error handling by myself (until now) - I will doit soon. 
Especially when I test the SQL-statements until they are free of errors I 
thought I don't need an error handler. So the message boxes arraise should 
come from the interpreter.

Many thanks

Rolf
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20050420/749eba25/attachment.sig>