Flype UserLibraries for PureBasic 4.0

[Flype]

First, in 'exbar.pbi' :

line 17: Global *ListExbar
line 62: FreeListEx(*ListBarEx)

*ListExbar <> *ListBarEx

Maybe the error comes from here, and somewhere else.

You should use 'EnableExplicit' to track all unconsistent vars.

try and tell me.

[Frontier]

Hello Flype,

Thank you very much for your extremely useful libraries

I have one question however: the SysTrayIconEx library is incompatible with Unicode executables in PB 4, therefore it does not display correctly the text (and title) within the balloon.

Is it possible to fix that somehow?

[Dr. Dri]

Hello Flype,

Thank you very much for your extremely useful libraries

I have one question however: the SysTrayIconEx library is incompatible with Unicode executables in PB 4, therefore it does not display correctly the text (and title) within the balloon.

Is it possible to fix that somehow?

i have the same problem with my userlibs... if i compile the lib with unicode, then it won't work in a ascii program...

i didn't see anything in the sdk about that

Dri

[Flype]

hum, you're right. i will see.
it might be resolved. it depends on tailbite and/or windows.

[gnozal]

i have the same problem with my userlibs... if i compile the lib with unicode, then it won't work in a ascii program...

i didn't see anything in the sdk about that

Dri

We all have the same unicode problem with our userlibraries. Thread-safe can be resolved with a subsystem (different library but with same functions), never tested this with unicode (not much use with Win9x).

[Flype]

hum, you're right. i will see.
it might be resolved. it depends on tailbite and/or windows.

well, i tried but i didn't manage to make it work in unicode mode.
source code is provided so if someone can find how to resolve this problem. i tried many things without result.

sorry.

[Dr. Dri]

We all have the same unicode problem with our userlibraries. Thread-safe can be resolved with a subsystem (different library but with same functions), never tested this with unicode (not much use with Win9x).

I know that but PB native libs work in either ascii and unicode mode... So we should be able to do so, right ? But i didn't find anything about that in the sdk.

Dri

[Flype]

*** NEW ***

SubSystem MySQL 5.1 for PB4.0 - BETA STAGE.

License :

It's a free and open-source mysql database userlibrary.
At the moment, in beta stage, all modifications, extensions, corrections, ideas should be posted/explained here for the interest of the purebasic communauty.



This project comes from the PureBasic Summer Of Code - French Forum.

French forum Link :
http://purebasic.forum-gratuit.com/viewtopic.php?t=5075


At the moment, it is still not compiled (with tailbite).
So only sources are provided.

usage

1/ Open the 'database_test_xx.pb' files.
2/ Configure the line OpenDatabase(id, "localhost", "root", "pwd", ["dbname"])
3/ And run in debug mode.

Command set

Code: Select all

;-
;- Database.lib - Minimal Set
;-

ExamineDatabaseDrivers()   
NextDatabaseDriver()
DatabaseDriverName()
DatabaseDriverDescription()

InitDatabase()
DatabaseError()
IsDatabase(database.l)
CloseDatabase(database.l)

OpenDatabaseRequester(database.l)
OpenDatabase(database.l, host.s, user.s, passwd.s, db.s = "")

DatabaseColumns(database.l)
DatabaseColumnName(database.l, column.l)
DatabaseColumnType(database.l, column.l)

DatabaseQuery(database.l, query.s)
DatabaseUpdate(database.l, query.s)

PreviousDatabaseRow(database.l)
FirstDatabaseRow(database.l)
NextDatabaseRow(database.l)

GetDatabaseLong(database.l, column.l)
GetDatabaseQuad(database.l, column.l)
GetDatabaseFloat(database.l, column.l)
GetDatabaseDouble(database.l, column.l)
GetDatabaseString(database.l, column.l)

;-
;- Database.lib - Extended Set
;-

DatabaseRows(database.l)

DatabaseQueryString(database.l, query.s)
DatabaseQueryLong(database.l, query.s)
DatabaseQueryQuad(database.l, query.s)
DatabaseQueryFloat(database.l, query.s)
DatabaseQueryDouble(database.l, query.s)
DatabaseQueryDate(database.l, query.s)
DatabaseQueryFormatDate(database.l, query.s, mask.s)

GetDatabaseDate(database.l, column.l)
GetDatabaseFormatDate(database.l, column.l, mask.s)
GetDatabaseBinary(database.l, column.l, bAllocateMemory.l = #False)
GetDatabaseLength(database.l, column.l)

ExamineDatabaseProcesses(database.l)
NextDatabaseProcess(database.l)
DatabaseProcess(database.l, field.l)

ExamineDatabaseTables(database.l, wild.s = "")
NextDatabaseTable(database.l)
DatabaseTable(database.l)

ExamineDatabaseFields(database.l, table.s, wild.s = "")
NextDatabaseField(database.l)
DatabaseField(database.l)

DatabaseDbList(database.l, userList.s(), wild.s = "")
DatabaseTableList(database.l, userList.s(), wild.s = "")
DatabaseProcessList(database.l, userList.DATABASE_PROCESS())

Debug, Tests, Comments, Extends, Validating... are very welcome.


DOWNLOAD :

see the 'SubSystem MySQL 5.1 for PB4.0 !!! BETA !!!' in the 1rst post.

[mskuma]

Exciting stuff! Thanks Flype.

[Flype]

Yes, isn't it...

Final objective is - once the model is validated - to do the same for PostGreSQL, SQLite, FireBird, And so on...

[Flype]

About the MySQL SubSystem, we need Bug trackers

[blueb]

Flype...

Final objective is - once the model is validated - to do the same for PostGreSQL, SQLite, FireBird, And so on...

Yahoo!

I need all three. I just bought a book on PostgreSQL and I'd like to use it with Pure.

Regards,

blueb

[Flype]

Flype...

Final objective is - once the model is validated - to do the same for PostGreSQL, SQLite, FireBird, And so on...

Yahoo!

I need all three. I just bought a book on PostgreSQL and I'd like to use it with Pure.

Regards,

blueb

do you use my postgreSQL wrapper or not ?

[Dr. Dri]

i just found that everything is in the library sdk readme for unicode stuff... the function only need a Unicode flag and a unicode version of the function.

Dri

[blueb]

Flype,

Yes, I just downloaded it and will play with it this week-end.

Thanks again,

--blueb