On Wednesday 13 June 2007 04:51, VGSoftware wrote:
> Hi Ed,
>
> I'm sorry for the lack of info....
>
> > First off, what is the data type of the field to which you're
> > linking? dCheckListBox, by its very nature, is a multi-value control,
> > so whatever it is bound to must accept a tuple of values.
>
> I have the app using a PostgreSQL database, the field is of type int4[]
> On the BizObj DataStructure i have the following:
>
> ("beneficios", "I", False, "public.socio", "beneficios"),
> I want lo load the dCheckListBox with data from a table (done),
> the user will then select the options he is interested in,
> the keys of the values he selected should then be saved in a table field,
> i was thinking initialy in something like a varchar field with the
> selected keys saved like key1|key2|key3,
> i'm now trying the use of a int4[] field.... but having the same problem...
>
> What is the datatype i have to use to save tuples in postgresql??
> In the bizobj DataStructure there seems to be only the basic types
> available... I, C, D, B,
> nothing seems suitable for tuples...
I'm sorry the current postgres interface does not directly support the array
data types. That is to say the Dabo side of the interface does not know how
to handle an array field. I think it might be possible to setup a variable
to accept the selections and then manually send it to postgres (psycopg can
handle it). But I have to admit I have not used the dCheckListBox and do not
know how Dabo is handling the multi-selection.
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
