Hi Guys,
One user have bring our attention to RBDB issue again,
I have spend few hours today working on this.
* One issue have come thanks to our change in engine
* Another issue thanks to fact that RB2006 in Table Designer
now execute close of db each time..
This is solved. Good.
--------------------------------------------------------------
After that I have stick into issue, that if I create column with VarChar
type, then one next access to FieldSchema Cursor, REALbasic crashes.
All other types works fine. Only VarChar
Few hours of fight and resume:
* Wow - wonder, the same plugin works fine in RB 5.5.
no crashes. So REAL have change something...
* Next discover, that if I return to RB
dbTypeLong then it show in table "Small Int"
dbTypeDouble then it show in table "Float"
And
dbTypeFloat then it show in table "VarChar"
I.e. It seems that RB2006 do -1 for type of column (???)
If look which type is just before VarChar it is
dbTypeChar, // 4
And THIS dbChar type cause RB2006 show dialog
"Nil object exception, inform REAL, Quite".
I hard believe that bug is in our code somehow, because we simply return
number 2, 3, 4, 5, 6, ... to REALbasic. And if we return 5, then BOOM.
And again, our code works fine in RB 5.
At first I have think that may be changes in plugin SDK, but even new alpha
SDK have the same enum with types. I.e. no changes here.
--------------------------------------------------------------
So it seems to me, to make this mess working it needs check version of RB
and do +1 for RB2006...
The most interesting in this game is, that for own db engine RB2006 works
fine. The it sounds like you do this if( RBVersion() ) .. Tricks.
I wonder, if e.g. Norman (OpenBase plugin) developer have meet
the same issue?
--------------------------------------------------------------
Another thing which I do not like (again) in RBDB, and which lives here from
RB 5 is next:
You use for string types of column names as
Char => FIXED size string
VarChar => Variable size string
Text BLob => unlimited size string based on BLOB.
I wonder, where in Standard SQL you have see such name "Text BLOB" ?
Quick search in google show that any DBMS do not support such name
of type "TEXT".
So REALbasic produce oddy CREATE TABLE T1 (ff Text BLOB).
Hmm, Valentina do not eat such SQL. It is not SQL standard.
Why you are doing this people? :-)
-----------
P.S.
Kim, RBDB works now IF not touch these GUI tools of REALbasic.
our RBDB examples work fine. I.e. You can work programmatically.
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
