PureBasic Forums - English

As infratec said:

At the moment I check the packets with WireShark and always the dbname is truncated at the space character.


so, yes it is reproduceable

All attempts showed that the connection string is split or at least truncated at the blanks.
host=127.0.01
port=3306
dbname=everything_else ...

I have tried everything ", ', `, and [ - nothing helps

Little John wrote: Wed Sep 28, 2022 3:58 pm Maybe replace the space character with %20 (like in URLs)? Just another guess.

Doesn't helps leads to "Unknown database 'mysql%20test'".
Also any try with escape sequences ends in no result.

Problem is that the dbname is truncated at the first space character.

infratec wrote: Wed Sep 28, 2022 1:57 pm At the moment I check the packets with WireShark and always the dbname is truncated at the space character.

That's exactly what i mentioned... So it seems to be a bug, of the OpenDatabase function, doesn't it?

RASHAD wrote: Wed Sep 28, 2022 1:50 pm Shoot in the dark
...

Sorry RASHAD, also not the result i needed... Only the table list of the databse "mysql"

infratec wrote: Wed Sep 28, 2022 12:45 pm Try this:

Code: Select all

host.s ="host=127.0.0.1 port=3306 dbname=`mysql test`"

Already tested... Unfortunately no success

Nope...
Result is

I have a database on the client side named "mysql test". I know this is not a smart way to name the database, but I can't change it.
I use this code snippet to retrieve the table names from the database:

UseMySQLDatabase()
host.s = "host=127.0.0.1 port=3306 dbname=mysql test" -> results in table ...

Just cosmetics, 16:60 is not very common

It's an unsigned long comparing with integer probem.
NicTheQuick pointed me to this at http://www.purebasic.fr/german/viewtopic.php?p=332175#p332175 :idea: .
Just replace each
\FileInfo(Number-1)\crc
in the zBin_Unpack.pbi with
\FileInfo(Number-1)\crc & $ffffffff

This do the trick, quick and ...

Ah, yes DatabaseQuery()...
I'm not at a computer, just have that problem with the flags in mind

Hi Flype,
Did you check the "new" flags for OpenDatabase()?

You can add DK5UR or Heinz Urban, but at least it's not necessary

Hi Marco,
Should be
RunProgram("open", "http://www.purebasic.com", "")

cu Heinz

wilbert wrote:PureBasic however doesn't support user customization.

It does


Thanks for the hints. Next is to attach a menu to a tbButton