Zugg Software :: View topic

Adept Joined: 01 Mar 2005 Posts: 277

Zugg,

Could you please answer a few questions for me? When I run the following code all TEXT fields (using SQLite) say "[MEMO]" when I click in them to edit the values. How can I fix this so the text can be edited? How can I left align the text for numeric values? Also, I notice that when I change the theme the checkboxes background becomes black. Also, how can I get the background behind the edit fields to change with the themes (I tried using a panel, as you'll see, but that doesn't help. EDITED TO ADD: I notice it changes for some themes but the navigator doesn't all the times either. In fact, play around with changing the themes from the menu and theme selection dialog. You will notice inconsistencies and sometimes the navigator icons disappear.) Also, is there any way to set it so the user can press the tab key to move from cell to cell in the grid?

Here's the ZML code (I took out some unnecessary stuff):

Adept Joined: 01 Mar 2005 Posts: 277

Okay, if I use "CHAR" instead of "TEXT" for the datatypes then the binding works.

Adept Joined: 01 Mar 2005 Posts: 277

I would also like to apologize for my jumble of questions. I should of given each a line with a number. Embarassed

Posted: Sat Jul 09, 2005 4:55 pm

To override the defaults for the columns in a grid, you need to use the COLUMN tag and then set the Editor property to what you want. In this case, to set up a multiline memo editor you'd set the Editor property to "Memo" for the text columns.

Changing from Text to Char has limits with some databases. Text is the proper type when you want an unlimited length text field (like the body of a email message, for example). Char only will give you the default single-line text editor in a grid.

The Edit fields *should* be changing with the theme. At least it does here. It will only change if the theme has an editor color defined, and some themes don't. My usual test theme for this is the OddWood theme since it completely changes all of the colors, including the edit color.

For your other questions you'll need to number them and give me details on reproducing them. I'm afraid your post (as you said) was too much of a jumble to really follow.

Posted: Sat Jul 09, 2005 4:58 pm

As far as tabbing between cells, I'm not sure. I'll have to look at the DevExpress stuff to see how to turn on that option. But I'm on my laptop today and not at my development system. You might want to send me an email on this request so I don't forget since I probably won't have time to do much about it until after the conference this week.

Adept Joined: 01 Mar 2005 Posts: 277

Zugg,

1) If I have the database fields set to "TEXT" rather than "CHAR" and then click in an EDIT object (I'm not talking about in the grid I am talking about the edit text boxes) it says "[MEMO]" and doesn't let me change anything. What do I do for this?

2) Also, another thing of importance is the checkbox. When I change the theme the background goes black (try it by selecting one of the theme menu items.)

3) Switching themes sometimes causes the navigation bar icons to disappear.

I wanted to give the guy his application tomorrow so he can start entering data into his database. That way I can worry about reports, etc. later but at least he'll have something to start with. I am excited at how easy zApp has made this. Your design decisions have been very logical.

Posted: Sat Jul 09, 2005 5:38 pm

2) Sounds like a bug. I hope to have the bug database set up on the web site in a couple of days. I need to wait for the hosting company server move to be completed.

3) Also sounds like a bug.

Posted: Sat Jul 09, 2005 5:38 pm

1) A "Text" field (or "Memo" field) is a large multi-line database field. You need to use a MEMO component to edit this. The EDIT component can only edit the single-line "Char" field type. So, yes, either change your database field to CHAR or use a MEMO component to edit it.

(1) is more of a design decision on your part. You need to decide which fields are large, multiline fields (TEXT type) and which are just normal single line fields (CHAR type).

Posted: Sat Jul 09, 2005 5:39 pm

Unfortunately, I'm not going to be able to release any new version of zApp until after the conference, so you'll have to live with these bugs for a couple of weeks. You might just want to remove the theme switching for now if he just needs to start entering data.

Adept Joined: 01 Mar 2005 Posts: 277

Thanks for the answers. I'll just remove the theme support (for now.)

Posted: Tue Jul 12, 2005 6:43 pm

OK, the bug tracking system is up and running. Go ahead and submit (2) and (3) into the bug system (make a separate report for each bug). Go to the Support menu at the top of the page, then select Bug Reports, then select zApp Bug Report.