[Gambas-user] Extracting fields from a Result

[T Lee Davidson]

On 01/01/2018 02:47 AM, Doug Hutcheson wrote:
> 
> On Mon, 2018-01-01 at 16:19 +1000, Doug Hutcheson wrote:
>>
[snip]
>>
>> How do I prepare my project and transmit it to the list?

Go to Project > Make > Source archive...

You could put a pared down database dump file in the project directory before making an archive, so that others could more
easily re-create it from that SQL file.


> Hi everyone. Another piece of the puzzle, I think:
> 
> I have a Database Application where I have been experiencing the above problems. Within this application I have one form which I
> have hardly been using. I have also created two Connections, one for my PostgreSQL database and one for my MySql database.
> 
> As the two connections are able to browse their respective databases, it seemed logical that controls using these connections
> would work also. I created a DataSource control on my form and set its Connection property to Connection1 (my PostgreSQL
> database). When I run the project, I am told "Cannot open database: fe_sendauth: no password supplied". I then set the
> Connection property to Connection2 (my MySql connection). When I run the project I am told "Cannot open database: Access denied
> for user 'root'@'localhost' (using password: NO)"
> 
> Why am I seeing these password problems when the Connection objects they are using connect perfectly?

Good question. I am having a similar issue, but all I get is "Cannot open database:" - no reason given. "Common.CheckDB.34" tops
the Stack backtrace.

I don't know if it's related, but when I set the properties for the Connection, I did not enable "Remember password". Yet, I got
an error message, "Unable to save password. Cannot store passwords on desktop KDE5: No wallet found". The error is correct;
there is no wallet. But I shouldn't have gotten any error because I did not elect to save the password.

The Connection can read the database statically through the IDE, but apparently not at runtime.


-- 
Lee