Search found 187 matches

by bobobo
Wed Jun 14, 2023 4:26 pm
Forum: Bugs - Windows
Topic: Bug - ODBC and stored-procedures (PB 4.2 up to 5.21)
Replies: 13
Views: 4690

Re: Bug - ODBC and stored-procedures (PB 4.2 up to 5.21)

i made another testscenarios similar to this above with mysql database and couldn't replicate this error ok, long up to very long databaseactions but all ok . 6.02 and 5.24 both in 64bit and a 64bit Maria odbc connector and i found a 32bit odbc driver , so i ran with an old pb 32bit 431 .. no error ...
by bobobo
Wed Jun 14, 2023 1:52 pm
Forum: Bugs - Windows
Topic: Bug - ODBC and stored-procedures (PB 4.2 up to 5.21)
Replies: 13
Views: 4690

Re: Bug - ODBC and stored-procedures (PB 4.2 up to 5.21)

after some testing (6.02 x86) and mssql (old database) i think it isn't a timeout, but more somethng that has to to with communications a test with waitfor ... gets a result even after 1 minute pause. my special test code posted above disconnects after shorter time , about 3 seconds if running the s...
by bobobo
Wed Jun 14, 2023 12:19 pm
Forum: Bugs - Windows
Topic: Bug - ODBC and stored-procedures (PB 4.2 up to 5.21)
Replies: 13
Views: 4690

Re: Bug - ODBC and stored-procedures (PB 4.2 up to 5.21)

select sleep(TIME) should do in my-sql tested with maria db created a procedure sleeper containing SELECT SLEEP(10); running it with call sleeper greetings i thought it over: select sleep(10),count(*) from EXISTING_TABLE as procedure shows row 2 as result after the 10 seconds. the table must exist s...
by bobobo
Tue Jun 13, 2023 9:52 am
Forum: Bugs - Windows
Topic: Bug - ODBC and stored-procedures (PB 4.2 up to 5.21)
Replies: 13
Views: 4690

Re: Bug - ODBC and stored-procedures (PB 4.2 up to 5.21)

playing arround with my testscenario from above in 6.02 the error is still there (only wheren using USEODBCDatabase())

i have to use the x86 as the database requires it

looks like a time out when the stored_procedure takes a longer time

greetings
by bobobo
Thu Dec 06, 2018 11:46 am
Forum: Announcement
Topic: PureBasic 5.70 LTS is out !
Replies: 252
Views: 133217

Re: PureBasic 5.70 LTS beta 3 is out !

i have to use ApplyEntityImpulse without Postions (otherwise it causes the 3dEngine to stop v5.70) maybe the docs should be updated change ApplyEntityImpulse(#Entity, x, y, z [, PositionX, PositionY, PositionZ [, Mode]]) to ApplyEntityImpulse(#Entity, x, y, z [, PositionX, PositionY, PositionZ , Mod...
by bobobo
Thu Dec 06, 2018 11:41 am
Forum: Applications - Feedback and Discussion
Topic: RagDolls Ogre and Physics
Replies: 20
Views: 11205

Re: RagDolls Ogre and Physics

updated code in the postings above due a behaviour concerning ApplyEntityImpulse when using Postitions in PB 5.70 Beta
by bobobo
Wed Oct 01, 2014 5:14 pm
Forum: Coding Questions
Topic: Center one or multiline text in TextGadget [Resolved]
Replies: 14
Views: 4050

Re: Center one or multiline text in TextGadget

Hi there

change #SS_CENTERIMAGE to #ES_CENTER

greetz

-- wow .. a little late :mrgreen:
by bobobo
Mon Jun 23, 2014 12:56 pm
Forum: Coding Questions
Topic: Difficult to describe problem with CanvasGadget
Replies: 9
Views: 1637

Re: Difficult to describe problem with CanvasGadget

no prob on win7 x86 pb 5.22 5.30 b4

(only when dragging the window the update is not shown)
by bobobo
Thu May 22, 2014 3:17 pm
Forum: Coding Questions
Topic: SQL Inner Join et al
Replies: 15
Views: 1601

Re: SQL Inner Join et al

Here is your Playground 8) UseSQLiteDatabase() ;Debug DeleteFile("D:\squ.sqlite",#PB_FileSystem_Force) ;Debug CreateFile(0,"D:\squ.sqlite") ;CloseFile(0) ;If OpenDatabase(0,"D:\squ.sqlite","","",#PB_Database_SQLite) If OpenDatabase(0,":memory:&q...
by bobobo
Tue Apr 15, 2014 5:06 pm
Forum: Feature Requests and Wishlists
Topic: Updated Code indentation
Replies: 10
Views: 2542

Re: Updated Code indentation

Image
by bobobo
Tue Apr 15, 2014 4:13 pm
Forum: Feature Requests and Wishlists
Topic: Updated Code indentation
Replies: 10
Views: 2542

Re: Updated Code indentation

That's what I meant :D
by bobobo
Tue Apr 15, 2014 12:05 pm
Forum: Feature Requests and Wishlists
Topic: Updated Code indentation
Replies: 10
Views: 2542

Re: Updated Code indentation

Startdrawing is not the best example, it has a returncode
and may fail

Code: Select all

If StartDrawing() ; startdrawing may fail
  drawsomething(...)
  StopDrawing()
EndIf
by bobobo
Wed Mar 12, 2014 3:44 pm
Forum: Coding Questions
Topic: Read the header of column with ODBC [Resolved]
Replies: 4
Views: 970

Re: Read the header of column with ODBC

read databasecolumns with the appropriate databasecolumn-fucctions (look at pb-help) do that before you step through the resultset. code not tested, i dont have any xlsx here UseODBCDatabase() DatabaseFile$ = "c:\ExcelKcc.xlsx" If OpenDatabase(0, "Pure_Viewer", "", &quo...