[Bond-users] Couple questions

[Davor Ocelic]

On Tue, Aug 14, 2007 at 12:08:25PM +1200, Dru wrote:
> Davor Ocelic wrote:
> > On Mon, Aug 13, 2007 at 10:20:23AM +1200, Dru wrote:
> >> I always just align to the left to match gnome specifications.
> > 
> > Oh, good to know. Well, in fact, my situation is this: I want to
> > visually create something like this:
> > 
> >  A:    _____
> >    AA: _____
> >    AB: _____
> >    AC: _____
> > 
> > So right-align would be useful. But I could also use left-align
> > if I changed color or font to somehow make it obvious that AA, AB
> > and AC are subelements of A.
> 
> Have you coded in GTK before? The functions in C are pretty 
> straightforward in uigeneral.c for labels. So if you know the GTK 
> commands to run on the widget it would be very easy to do this. I can 
> help, I just not sure how in GTK you modify colours and layout.

I'll get around to coding this in, even though the schedule will permit
it only in September.

If I get some time to work on bond, it will be updating the glade2bond
xsl to support glade3. I found it much, much easier to write non-trivial
forms with glade.

Also, one offtopic question, how is the login.xml file from bond
trunk supposed to be used? Can you really display this window and
have user type in username/password to connect to postgres? I 
thought this information was embedded in the .conf file and you couldn't
change it before connection.

> >>> 3) Could bonddb quote field names? I have a table whose column
> >>>    names are pure numbers (like 208, 214, 301).
> >> I just changed for updates. does it need it for inserts also?
> >>
> >> You need to checkout new version of bonddb from subversion for the fix.

Sure. I have tested it and it works great.

> > I think in inserts you never explicitly name fields, right? You just say
> > insert into TABLE values (v1,v2,v3...)? In that case nothing has to be
> > done for inserts.
> 
> I believe I explicity name them because the order of fields can be 
> different if we use bondreplicate and have two different databases, so 
> it explicitiy adds field name nw. I can change that to.

Yes, you are right. I tried adding a new record, and here's what
happened:

<bonddb/bonddbwrite.c:593 bonddb_write_execsql();> Exec :
INSERT INTO po (268,269,291,303,318,401,203,204,205,208) VALUES ('165','1415','17','10','123','44','12','12','12','12')
Error bonddb/bonddbwrite.c: 615: bonddb_write_execsql(): SQL Failed with ERROR:  syntax error at or near "268"
LINE 1: INSERT INTO po (268,269,291,303,318,401,203,20...
                                      ^
On: INSERT INTO po (268,269,291,303,318,401,203,204,205,208) VALUES ('165','1415','17','10','123','44','12','12','12','12')
<bonddb/bonddbwrite.c:93 bonddb_write_freelist_special();> Dealing with special case where a mark fails to save and needs to creativly free. SELECT * FROM po

If you do the same fix like for updates, I'll just test it to make 
sure it works.

Thanks,
-doc