Ahmad Abdelwahed
|
| Posted: 03/19/2001, 6:45 AM |
|
I am trying to add something beside URL type record in a form.
you know in the bookstore example, there is a list of categories in the
left, I want to add beside each category name a number of books in this
category, for example:
internet(5)
hardware(25)
and so on, I tried to do the using the code charge but I faild, can you tell
me how?
Regards,
|
|
|
 |
CodeCharge
|
| Posted: 03/19/2001, 8:17 PM |
|
Please try to the following in the BookStore example included with
CodeCharge:
- Choose Pages/CategoriesGrid
- Click on the icon 'FormProperties', go to SQL Tab and enter this query:
SELECT categories.category_id, categories.name, count(*) FROM items,
categories WHERE items.category_id = categories.category_id GROUP BY
categories.category_id, categories.name;
- Return to the Categories grid form, add new field by clicking on the New
Field icon.
- Select the newly created expression as your field, and use Label Type
- Make sure the field is of Numeric Type by clicking on Field Properties
CodeCharge Support
"Ahmad Abdelwahed" <ahmad@nileweb.com> wrote in message
news:99561c$32v$1@mail.tankhill.com...
> I am trying to add something beside URL type record in a form.
> you know in the bookstore example, there is a list of categories in the
> left, I want to add beside each category name a number of books in this
> category, for example:
> internet(5)
> hardware(25)
> and so on, I tried to do the using the code charge but I faild, can you
tell
> me how?
>
> Regards,
>
>
>
|
|
|
|
|
