Richard White
|
| Posted: 07/21/2003, 1:14 PM |
|
I'm using CC studio 2.0.5.6 (trial version) with, WinXP-Pro, MySQL (V
4.0.12), and PHP (V 4.3.1) on my local PC.
I've developed a [relational] database of 9 tables, and tried using
Application Builder to create a "quick" sample/test scenario application
using CCStudio.
However, the builder doesn't "see" all of the tables, and likewise only
showed some of the columns in the tables. This was during the initial
definition of a new application, where it asks for files to be
searched/maintained and also (somewhere there!) allowed me to select fields
to be included.
I can't get back to those screens now ..... it seems that once the
application is "defined", then that's it as far as those build application
screens are concerned.
Anybody come across this problem before?????
---------------------------------------
I also had a couple of other problems:-
1. CCStudio required me to specify a "Primary Key" to a table which already
had one ! (which I couldn't do in CCStudio, since it let me select only one
field as key, and that file has a two field primary key)
2. I can't find (or apparently generate) anything sensible at all out of it.
I've also taken "Publish" [to the local directory], but still nothing seems
to get generated.
anybody any thoughts on these problems too?
Guess it's back to reworking the quick tutorials, and seeing how they work
in more detail and then trying things manually and not rely on Application
Builder?
Thanks in advance.
|
|
|
 |
DonB
|
| Posted: 07/21/2003, 2:45 PM |
|
The builders (unfortunately) are one-shot deals. Unless you have something
really customized, it's just as easy to delete the control and create a new
one (you have Builders that create the entire app and all pages, but you can
also use other Builders to generate individual controls. the various
elements (search, grid and record) "link" to each other by passing
parameters (input via the "Data Source" Property and output via the Href
source Property). You can easily excise a control and run the appropriate
builder to recreate the component.
As to the missing database objects, this seems to crop up regularly and
sometimes is merely an issue with the datasource of your control. Open it
and look at the Data Source - go into the Query Builder and see if the new
objects show up there - especially, are the new columns there but just not
"checked"?). Other times, it is as if the Data Source can't see the new
database objects no matter what you do. This situation needs to be reported
to http://support.codecharge.com as they are investigating it.
The Primary Key is only specifiable as a single column, but this is of no
consequence other than the "auto-increment primary keys" option as far as I
can tell. As long as you ensure the input and output parameters fully
specify all PK columns, then things will work fine. It's just that CCS
can't automatically put it all together automatically.
DonB
"Richard White" <whiter@gmx.co.uk> wrote in message
news:bfhhj7$a83$1@news.codecharge.com...
> I'm using CC studio 2.0.5.6 (trial version) with, WinXP-Pro, MySQL (V
> 4.0.12), and PHP (V 4.3.1) on my local PC.
>
> I've developed a [relational] database of 9 tables, and tried using
> Application Builder to create a "quick" sample/test scenario application
> using CCStudio.
>
> However, the builder doesn't "see" all of the tables, and likewise only
> showed some of the columns in the tables. This was during the initial
> definition of a new application, where it asks for files to be
> searched/maintained and also (somewhere there!) allowed me to select
fields
> to be included.
>
> I can't get back to those screens now ..... it seems that once the
> application is "defined", then that's it as far as those build application
> screens are concerned.
>
> Anybody come across this problem before?????
> ---------------------------------------
>
>
> I also had a couple of other problems:-
>
> 1. CCStudio required me to specify a "Primary Key" to a table which
already
> had one ! (which I couldn't do in CCStudio, since it let me select only
one
> field as key, and that file has a two field primary key)
>
> 2. I can't find (or apparently generate) anything sensible at all out of
it.
> I've also taken "Publish" [to the local directory], but still nothing
seems
> to get generated.
>
> anybody any thoughts on these problems too?
>
>
>
> Guess it's back to reworking the quick tutorials, and seeing how they work
> in more detail and then trying things manually and not rely on Application
> Builder?
>
>
> Thanks in advance.
>
>
>
|
|
|
|
Richard White
|
| Posted: 07/23/2003, 4:21 PM |
|
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:bfhmt4$h57$1@news.codecharge.com...
> The builders (unfortunately) are one-shot deals. Unless you have
something
> really customized, it's just as easy to delete the control and create a
new
> one (you have Builders that create the entire app and all pages, but you
can
> also use other Builders to generate individual controls. the various
> elements (search, grid and record) "link" to each other by passing
> parameters (input via the "Data Source" Property and output via the Href
> source Property). You can easily excise a control and run the appropriate
> builder to recreate the component.
If you know what you're doing <lol> What you've written above just doesn't
make sense to me though: mainly because I don't yet understand how CCS
works - which is why I'm trying to get through the tutorials, but this
problem is a show stopper there!
> [...snipped...] This situation needs to be reported
> to http://support.codecharge.com as they are investigating it.
Done - if they'll accept trial user bug reports that is?
> The Primary Key is only specifiable as a single column, but this is of no
> consequence other than the "auto-increment primary keys" option as far as
I
> can tell.
Well, this is another show stopper. Can't proceed past this error message.
|
|
|
|
DonB
|
| Posted: 07/23/2003, 7:29 PM |
|
The basic mechanism for web page operation is to pass parameters attached to
the URL when submitting forms (html <FORM> that is).
CCS reads these values off the URL and uses them as inputs to forms when a
page loads. CCS also collects them and attaches them to URLs as outputs,
when other pages are loaded.
The inputs are connected to form controls by adding them to the Data Source.
The outputs are added to the output through the Href Source. Both of these
are shown in the Properties panel of the CCS window.
When CCS asks for the Primary Key, just give it one of the segments
(columns) and don't worry about the others. There shouldn't be any further
complaint about mssing primary key. Just review the Data Source "where"
parameter list and add the other segments if they are not listed.
Another note: I never use the Application Builder. It is confusing and
doesn't create an application with the flow I want (usually). I typically
start with the Grid and Record builder or even just a grid OR record builder
and although I do a bit more work, I have better results.
Have you read the documents at http://support.codecharge.com/tutorials.asp?
The don't answer all the questions, but they make a good start and are
better than just the help files.
DonB
|
|
|
|
|
