A=Split (replace ("##yyy##1234","##",chr (27)),chr (27))
Or do not use double characters as separator .
Le 22 mai 2017 23:35, a écrit :
> Matti
>
> Your string has 3 substrings when split with SPLIT (STRING, "#"):
>
> Index 0: "Hello"
> Index 1: ""
> Index 2: "12345"
>
> It is documented
hi again tobias.. only a informative mail: the tools that refers your first
links all does not usefully, due
with huge data no one its working!.. all the solutions are script based
over a mysql dump so all are a disc I/O operation when are using...
Lenz McKAY Gerardo (PICCORO)
http://qgqlocheko
http://gambaswiki.org/bugtracker/edit?object=BUG.1096&from=L21haW4-
Bruce BRUEN changed the state of the bug to: Invalid.
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot
Matti
Your string has 3 substrings when split with SPLIT (STRING, "#"):
Index 0: "Hello"
Index 1: ""
Index 2: "12345"
It is documented that separators are single characters, not strings; you can
specify a string because any of its individual characters may be used as
separator.
If you also sp
Ok, thank you, Tobi.
I'll have to start thinking again (but not tonight anymore).
Matti
Am 22.05.2017 um 22:17 schrieb Tobias Boege:
> On Mon, 22 May 2017, Matti wrote:
>> If I have a string sStr="hello##12345" and want to split it:
>>
>> Dim aSplit as String[]
>> aSplit = Split(sStr, "##")
>> Pri
On Mon, 22 May 2017, Matti wrote:
> If I have a string sStr="hello##12345" and want to split it:
>
> Dim aSplit as String[]
> aSplit = Split(sStr, "##")
> Print aSplit[0], aSplit[1]
>
> Returns always only "hello". Maybe "12345" is excluded because being an
> integer?
>
It is not an integer in
If I have a string sStr="hello##12345" and want to split it:
Dim aSplit as String[]
aSplit = Split(sStr, "##")
Print aSplit[0], aSplit[1]
Returns always only "hello". Maybe "12345" is excluded because being an integer?
Now the Wiki says "StringArray = Split ( String [ , Separators , Escape ,
Ig
http://gambaswiki.org/bugtracker/edit?object=BUG.1101&from=L21haW4-
Comment #6 by PICCORO LENZ MCKAY:
hello all, based on documentation from ZXMARGE the count must retunr in INSERTS
at leaast. .but seems not! so MAX neither!
in sqlite or odbc how can extrat the table name, due i try to autodetect
the field name from a result:
For indexcol = 0 To rsObj.Fields.Count - 1
rsObj.Fields[indexcol].Name
next
but in sqlite case i get string: "tablename.colname" event "colname"
so there's some property or method that ca
2017-05-22 13:48 GMT-04:00 Tobias Boege :
> 1. Copy the database users (Connection.Users), then the databases
> (Connection.Databases) and after that the table schemas
> (Connection.Tables)
> for each database. I don't think you can expect to transfer anything
> else like permissi
On Mon, 22 May 2017, PICCORO McKAY Lenz wrote:
> umm usefully, but the source its odbc.. was my faul...
>
> in any case, there's posible to cpy between results object of differents
> connections? that the right quiestion!
>
Ok, after I formulated my answer, I can see how you may want to use Gamb
i have a var named query1 = "`SHW325X`,"
when i do String.Left(querycolsinserts, -1) the las char "," are not
removed, so i used Left$(querycolsinserts, -1) and works..
now this due the "`" char inside?
so then how can i do when i dont know if the string are utf-8 or not? due
the behaviour dep
umm usefully, but the source its odbc.. was my faul...
in any case, there's posible to cpy between results object of differents
connections? that the right quiestion!
the case its important to make a special daemon for webservices..
Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com
On Mon, 22 May 2017, PICCORO McKAY Lenz wrote:
> i mean, due the now well knowed problem of odbc,
>
> i have two databases, db1 can be mysql, odbc, etc, and the other target db
> must be sqlite..
>
> can be possible to port from the db1 to the memory table in sqlite3 db2 ?
> or at leas ina normal
hi zxMarce debuggin i note that based on their documentation, inserts must
return affected roms and seems gambas odbc object does not made this..
please illuminate me! i made a odbc inserts and either returns affected
roms! some other has same results?
Lenz McKAY Gerardo (PICCORO)
http://qgqloche
i mean, due the now well knowed problem of odbc,
i have two databases, db1 can be mysql, odbc, etc, and the other target db
must be sqlite..
can be possible to port from the db1 to the memory table in sqlite3 db2 ?
or at leas ina normal sqlite3 table?
Lenz McKAY Gerardo (PICCORO)
http://qgqloch
http://gambaswiki.org/bugtracker/edit?object=BUG.1101&from=L21haW4-
Comment #5 by Benoît MINISINI:
I have updated the documentation of the Result.Count property, to explain that
ODBC connections may return the -1 value.
-
http://gambaswiki.org/bugtracker/edit?object=BUG.1100&from=L21haW4-
Comment #10 by PICCORO LENZ MCKAY:
due the result object to make the MoveTo need the count for... as said zxMarce
all .MoveXXX methods except .MoveNext SEEMS need a record count from the
provider. so there's no way for the DAt
hello Fabian.. hello zxMarce
Fabian, your method/code does not work as zxMarce said.. (in any case, the
resultset and db manage was done in form code)
due the result object to make the MoveTo need the count for... as said
zxMarce all .MoveXXX methods except .MoveNext SEEMS need a record count
fr
http://gambaswiki.org/bugtracker/edit?object=BUG.1103&from=L21haW4-
Comment #1 by Benoît MINISINI:
Fixed in revision #8136.
Benoît MINISINI changed the state of the bug to: Fixed.
--
Check out the vibrant tech communi
http://gambaswiki.org/bugtracker/edit?object=BUG.1103&from=L21haW4-
Benoît MINISINI changed the state of the bug to: Accepted.
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Sla
For those of you that, like me, are having trouble with editing a source
file, I have been using two functional workarounds:
a) I run a virtual machine (vbox), and then I mount the project directory
onto the virtual machine. From this virtual machine I edit the source code,
compile it, and then sw
22 matches
Mail list logo
