Re: pgaccess form design - Mailing list pgsql-interfaces
From | C. Maj |
---|---|
Subject | Re: pgaccess form design |
Date | |
Msg-id | Pine.LNX.4.44.0207092116360.27889-100000@freebird.stanley.cup Whole thread Raw |
In response to | Re: pgaccess form design ("Nigel J. Andrews" <nandrews@investsystems.co.uk>) |
Responses |
Re: pgaccess form design
|
List | pgsql-interfaces |
On Wed, 10 Jul 2002, Nigel J. Andrews waxed: > On Tue, 9 Jul 2002, C. Maj wrote: > > > On Wed, 10 Jul 2002, Nigel J. Andrews waxed: > > > > > > > > On Tue, 9 Jul 2002, John L. Turner wrote: > > > > > > > By mistake, I named a Form's data box, starting with a Capital letter. > > > > Received a message, but can not delete said offender. > > > > I removed the control from the Form, but still I get an error when Form opens. > > > > > > I think you probably need to edit the formsource column in the pga_forms > > > table. I haven't done this myself, or looked too closely at the contents of the > > > table but I presume that your deletion of the form item hasn't been propagated > > > into the description held for the form in the database and that therefore you > > > need to make the deletion by hand. > > > > > > You should be able to do this within pgaccess if I'm not mistaken. > > > > > > > I never tried this before, so I named a couple of buttons and entry > > boxes on a form with starting Capitals. Sure enough, after I saved, then > > opened the form, it complained. But to fix it I didn't have to go into > > the pga_forms table. I just designed the form again, changed the first > > letter to lower case, and saved then opened it. Works like a champ. > > > > If I didn't get that bug correctly reproduced, please file a report at > > bugzilla.pgaccess.org, so we can address the problem in more depth and > > off-list. > > > > Hmmm...in 0.98.7 if I create a label with the name Label1 and save it then when > I open it I get the error reported. When I 'design' the form again, which is > what I was assuming was part of the original report but obviously isn't, I > don't get the error but I can not simply edit the widget name to change the > uppercase letter to lowercase and save it. Looking at the backend logfile I see > a deletion of the form from pga_forms followed by a re-insertion . The INSERT > command still shows the capitalised Label1 name is being used. Further > experimentation seems to show that it's the editing of the widget name that is > not being handled correctly when the first letter is uppercase. > > As I say this was on 0.98.7, I haven't got 0.98.8 yet. > Perhaps the key part here is hitting the "Enter" key when you change the name of the label. I think _only_ that updates the variable which contains the name of the label. (You are correct about the DELETE/INSERT handling, the old form code is dropped immediately before the new code is put into the pga_forms table.) I will add this Capital Letter issue to bugzilla.pgaccess.org ASAP. FYI, 0.98.8 isn't released yet. The plan is out there for it, though. --Chris Maj -- cmaj_at_freedomcorpse_dot_info 0xC0051F6A 5EB8 2035 F07B 3B09 5A31 7C09 196F 4126 C005 1F6A
pgsql-interfaces by date: