Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

OpenBase Plugin 3.0a2 for REALbasic (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: How to get the absolute Unix path?
Next thread: where is saved a COMMENT from file infos ?


Re: Restart and RTF   -   Dr Gerard Hammond
  OpenBase Plugin 3.0a2 for REALbasic   -   Luís Eugênio <l
    Re: OpenBase Plugin 3.0a2 for REALbasic   -   Brad Hutchings
     Re: OpenBase Plugin 3.0a2 for REALbasic   -   Luís Eugênio <l
      Re: OpenBase Plugin 3.0a2 for REALbasic   -   Brad Hutchings
       OpenBase Plugin 3.0a2 for REALbasic   -   Luís Eugênio <l
        Re: OpenBase Plugin 3.0a2 for REALbasic   -   Brad Hutchings
         Re: OpenBase Plugin 3.0a2 for REALbasic   -   Luís Eugênio <l
      Scrolling a ListBox   -   Stéphane Pinel <

OpenBase Plugin 3.0a2 for REALbasic
Date: 31.07.02 14:46 (Wed, 31 Jul 2002 10:46:59 -0300)
From: Luís Eugênio <l
Hi all,

Some problems I can't still work out the solution.

Developing machine: Mac OS X Server 10.1.4, G4 Quicksilver.

1. Front End written in Realbasic, Openbase database. Realbasic 4.02,
Openbase 7.0.6..., Plug in version 15.03.02. All worked fine except text
encoding. Even Object field was working ok (for huge text fields).

2. Upgrade to Openbase 7.0.7, plug in 3.0 -> problems with connection
(password null)

3. Plugin 3.0.2 -> connection ok, but object fields doesn´t work
anymore. Texts all wrong.

And I'm also having this little trouble with boolean fields. I can't
figure it out how can Realbasic is able to set to true of false. I've
already tried Checkboxes, editfields connected with datacontrols, or
directly by code. No sucess.

I would be very grateful for any suggestions.

Many thanks in advance.

Luis.

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: OpenBase Plugin 3.0a2 for REALbasic
Date: 31.07.02 17:02 (Wed, 31 Jul 2002 09:02:46 -0700)
From: Brad Hutchings
Luis,

Our mailing list server is down. Sorry about that. Using objects columns
with text (which should be encoded properly in the database encoding by
the plugin) is not yet supported for REALbasic 4.0.2. I do have
undocumented (as yet) support for it which can be used with REALbasic
4.5. I strongly suggest that you upgrade. I do not plan add equivalent
support for REALbasic 4.0.

That said, I need to write a document on object columns for the next
release. There are two cases to consider: (1) you are using an object
column for binary objects, and (2) you are using it for large text. In
case (1), the plugin should not translate the data based on text
encoding settings of database and client. In case (2), it should.

Elsewhere, I have suggested that you craft your own SQL statements
rather than relying on shoving data into a DatabaseRecord class and
calling the Database class's AddRecord or RecordSet's (DatabaseCursor's)
UpdateRecord methods. This holds especially true for object data, as
there is no way to tell the plugin whether the data should be treated as
text or an object.

The way that objects (and large text) works in OpenBase is that the
client uploads the object, gets an object handle, and inserts that into
a table. When data is selected, OpenBase returns the handle, and the
client then asks OpenBase to download the object. In the previous
version of the plugin, this was done automatically using the Object
method of DatabaseField. However, no distinction could be made between
text and binary data,

With the new plugin, you need to explicitly upload your large objects
and large text using either InsertBlob (for objects) or InsertClob (for
large text) methods of the OpenBaseDatabase class. These return a blob
handle which can then be put into the StringValue of a DatabaseField or
used in a hand-crafted insert or update statement.

I'll document this better for the next release.

Hope that helps!

-Brad

Re: OpenBase Plugin 3.0a2 for REALbasic
Date: 31.07.02 18:21 (Wed, 31 Jul 2002 14:21:39 -0300)
From: Luís Eugênio <l
Brad,

thanks for you quick response.
Do you know ( or anyone else knows) if DataControls methods are
implemented using DatabaseRecords or DatabaseCursors ? I'm asking
because using object columns with the binding edit fields seems to work
ok.

Luis.

On quarta-feira, julho 31, 2002, at 01:02 , Brad Hutchings wrote:

> Luis,
>
> Our mailing list server is down. Sorry about that. Using objects
> columns with text (which should be encoded properly in the database
> encoding by the plugin) is not yet supported for REALbasic 4.0.2. I do
> have undocumented (as yet) support for it which can be used with
> REALbasic 4.5. I strongly suggest that you upgrade. I do not plan add
> equivalent support for REALbasic 4.0.
>
> That said, I need to write a document on object columns for the next
> release. There are two cases to consider: (1) you are using an object
> column for binary objects, and (2) you are using it for large text. In
> case (1), the plugin should not translate the data based on text
> encoding settings of database and client. In case (2), it should.
>
> Elsewhere, I have suggested that you craft your own SQL statements
> rather than relying on shoving data into a DatabaseRecord class and
> calling the Database class's AddRecord or RecordSet's
> (DatabaseCursor's) UpdateRecord methods. This holds especially true for
> object data, as there is no way to tell the plugin whether the data
> should be treated as text or an object.
>
> The way that objects (and large text) works in OpenBase is that the
> client uploads the object, gets an object handle, and inserts that into
> a table. When data is selected, OpenBase returns the handle, and the
> client then asks OpenBase to download the object. In the previous
> version of the plugin, this was done automatically using the Object
> method of DatabaseField. However, no distinction could be made between
> text and binary data,
>
> With the new plugin, you need to explicitly upload your large objects
> and large text using either InsertBlob (for objects) or InsertClob (for
> large text) methods of the OpenBaseDatabase class. These return a blob
> handle which can then be put into the StringValue of a DatabaseField or
> used in a hand-crafted insert or update statement.
>
> I'll document this better for the next release.
>
> Hope that helps!
>
> -Brad
> --
> Brad Hutchings
> <email address removed>
> On Wednesday, July 31, 2002, at 08:12 AM, Luís Eugênio wrote:
>
>> Brad,
>>
>> Tried the list but nobody seems to care. Or really do not know how to
>> solve. Tried Openbase and Realbasic list. No answer yet and this is a
>> very important issue to me.
>>
>> You are the one that have left. Maybe this is useful for you also.
>>
>> Begin forwarded message:
>>
>>> From: Luís Eugênio <<email address removed>>
>>> Date: qua jul 31, 2002 10:46:59 America/Sao_Paulo
>>> To: "REALbasic Network Users Group" <realbasic-
>>> <email address removed>>
>>> Subject: OpenBase Plugin 3.0a2 for REALbasic
>>> Reply-To: "REALbasic Network Users Group" <realbasic-
>>> <email address removed>>
>>>
>>> Hi all,
>>>
>>> Some problems I can't still work out the solution.
>>>
>>> Developing machine: Mac OS X Server 10.1.4, G4 Quicksilver.
>>>
>>> 1. Front End written in Realbasic, Openbase database. Realbasic 4.02,
>>> Openbase 7.0.6..., Plug in version 15.03.02. All worked fine except
>>> text encoding. Even Object field was working ok (for huge text
>>> fields).
>>>
>>> 2. Upgrade to Openbase 7.0.7, plug in 3.0 -> problems with
>>> connection (password null)
>>>
>>> 3. Plugin 3.0.2 -> connection ok, but object fields doesn´t work
>>> anymore. Texts all wrong.
>>>
>>> And I'm also having this little trouble with boolean fields. I can't
>>> figure it out how can Realbasic is able to set to true of false. I've
>>> already tried Checkboxes, editfields connected with datacontrols, or
>>> directly by code. No sucess.
>>>
>>> I would be very grateful for any suggestions.
>>>
>>> Many thanks in advance.
>>>
>>> Luis.
>>>
>>>
>>> ---
>>> Subscribe to the digest:
>>> <mailto:<email address removed>>
>>> Unsubscribe:
>>> <mailto:<email address removed>>
> ---
> Subscribe to the digest:
> <mailto:<email address removed>>
> Unsubscribe:
> <mailto:<email address removed>>

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: OpenBase Plugin 3.0a2 for REALbasic
Date: 01.08.02 01:25 (Wed, 31 Jul 2002 17:25:43 -0700)
From: Brad Hutchings
> Brad,
>
> thanks for you quick response.
> Do you know ( or anyone else knows) if DataControls methods are
> implemented using DatabaseRecords or DatabaseCursors ? I'm asking
> because using object columns with the binding edit fields seems to work
> ok.
>
> Luis.

Luis,

They may seem to be working OK, but they are not handling text encoding
correctly. If you are relying on the DatabaseRecord approach to updating
records (as DataControl objects do), text that comes from or is put into
object columns will not be encoded consistently with other text in the
database.

-Brad

OpenBase Plugin 3.0a2 for REALbasic
Date: 01.08.02 21:44 (Thu, 1 Aug 2002 17:44:46 -0300)
From: Luís Eugênio <l
Hi list,

I've gave up Objects columns for now.

No upgrade yet, I'm still using Realbasic 4.0.2. Maybe by the end of the
week...

Plugin 3.0a2 works ok for encoding. A little bit more fast, I guess.

But here is the side effect: cannot bind the datafield anymore.
DataControl is ok. Datasource, ok. But the list of fields doesn't show.

Just to check if anybody pass through that or Realbasic 4.5 is a must...

Many thanks.

Luis.

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>

Re: OpenBase Plugin 3.0a2 for REALbasic
Date: 01.08.02 22:10 (Thu, 1 Aug 2002 14:10:03 -0700)
From: Brad Hutchings
Luis,

OpenBase Plugin 3.0a1 and 3.0a2 require OpenBase 7.0.7 for the
FieldSchema call to work correctly. I have added support for previous
versions of OpenBase to 3.0a3, which will be available shortly.

-Brad

Re: OpenBase Plugin 3.0a2 for REALbasic
Date: 01.08.02 22:44 (Thu, 1 Aug 2002 18:44:16 -0300)
From: Luís Eugênio <l
Hmmm,

make sense... I'm using Openbase Manager 7.0.7 on my local machine, but
the database is hosted by Openbase 7.0.6 ....

Thanks again,

Luis.

On quinta-feira, agosto 1, 2002, at 06:10 , Brad Hutchings wrote:

> Luis,
>
> OpenBase Plugin 3.0a1 and 3.0a2 require OpenBase 7.0.7 for the
> FieldSchema call to work correctly. I have added support for previous
> versions of OpenBase to 3.0a3, which will be available shortly.
>
> -Brad
> --
> Brad Hutchings
> <email address removed>
> On Thursday, August 1, 2002, at 01:44 PM, Luís Eugênio wrote:
>
>> Hi list,
>>
>> I've gave up Objects columns for now.
>>
>> No upgrade yet, I'm still using Realbasic 4.0.2. Maybe by the end of
>> the week...
>>
>> Plugin 3.0a2 works ok for encoding. A little bit more fast, I guess.
>>
>> But here is the side effect: cannot bind the datafield anymore.
>> DataControl is ok. Datasource, ok. But the list of fields doesn't show.
>>
>> Just to check if anybody pass through that or Realbasic 4.5 is a
>> must...
>>
>> Many thanks.
>>
>> Luis.
>
> ---
> Subscribe to the digest:
> <mailto:<email address removed>>
> Unsubscribe:
> <mailto:<email address removed>>

---
Subscribe to the digest:
<mailto:<email address removed>>
Unsubscribe:
<mailto:<email address removed>>