Dear Fabien,
I'm using Gambas 3.3.0. Under database manager you mean the connection
manager? I just tried it out, see attached screenshot. The query
doesn't return any results, just pops up a "OK".
All the best,
M.
On Thu, Oct 18, 2012 at 9:19 AM, Fabien Bodard wrote:
> Have you try your sql r
Have you try your sql request in the gambas3 IDE database manager?
Le 18 oct. 2012 02:54, "Markus Schatten" a écrit :
> Dear Fabien and Ian,
>
> thank you for your reply. I was kind of hoping that there is a way to
> index the results. I started of to write a query rewriter, but got
> soon into t
Dear Fabien and Ian,
thank you for your reply. I was kind of hoping that there is a way to
index the results. I started of to write a query rewriter, but got
soon into trouble with lots of possible ways of writing a query. I
would probably need a grammar parser to do that ;-)
Anyways, after looki
On Wed, Oct 17, 2012 at 7:32 AM, Markus Schatten wrote:
> queries. Yes, I could parse each query and rewrite it before
> executing, but this would be at least an "ugly hack".
No, I think its your best solution
Maybe your users can just type in the "where" part of the query and
then you add the r
I think there is not simple way for that. It's a collection of names. You
need to distinct the by your self.
Le 16 oct. 2012 22:34, "Markus Schatten" a écrit :
> Dear all,
>
> I have a problem with a PostgreSQL connection (haven't tested it with
> other dbms'). When a query has the same attribute
Dear all,
I have a problem with a PostgreSQL connection (haven't tested it with
other dbms'). When a query has the same attribute name for a column,
there seems to be no way in accessing any of these columns except for
the first one. Consider the following example.
I create a table test with:
db