E_D00068 ERROR: Compile errors in component FormName
droesler
I have an application with one frame and the frame script has only one
on setvalue event in it. I don't have anything in the initialize or
declare sections of the frame script.
When I try and run this I get the error in the subject of this post.
The trace output window also says:
Can't instantiate starting object formname.
E_WT0029 Error at line 3523 of aw_appworkbench06.
Where can I find what all this means?
Thanks
Dennis
Paul White
E_WT0029 is a runtime error message - I haven't seen it listed in the docs.
This particular message says that workbench is unable to run the frame
linked to your application.
Did you get your editor problems sorted out ok?
http://groups.google.com.au/group/comp.databases.ingres/browse_thread/thread
/096c74be7b60b6b2#
Hopefully now, after you save the code and close the frame you can re-open
and retrieve the same code.
Does your frame compile ok without errors? Below is a simple code fragment
for you to try.
Create a new frame in your application
Open the frame
Tools, Script (Shift F1)
Paste the sample into the script editor then Save and close the script
editor.
Tools, Compile (Ctrl F5)
File, Save (Ctrl S) just in case
Debug, Go (F5)
Check the trace window for any error messages. You should have a little
popup with a 10 in the middle.
If all looks good you can save and the frame, then set your frame to be the
starting frame for your application.
Then try again Debug, GO at the application level.
Sample fm_popup_10
initialize() =
declare
counter = integer not null
enddeclare
{
counter = 10;
message varchar(counter);
}
Paul
droesler
On May 5, 10:30 pm, "Paul White" <shift7soluti...@gmail.com> wrote:
> Hi Dennis,
>
> E_WT0029 is a runtime error message - I haven't seen it listed in the docs.
> This particular message says that workbench is unable to run the frame
> linked to your application.
>
> and retrieve the same code.
> Does your frame compile ok without errors?
error.
I tried your sample code mentioned below and it works fine.
Below is the code in the frame script.
I'm not sure if there is a requirement for something in the block
after enddeclare or not. Also, I'm not sure it this is the correct
way to populate a form in OR. I couldn't find an example in any of
the manuals I've been looking at. Just going by my ABF experience :-)
initialize()=
declare
enddeclare
{
}
on setvalue fieldName =
{
formName = select <cols in table match fields on form> from
tableName where fieldName = :fieldName;
}
Thanks
Dennis
droesler
> for you to try.
>
> Create a new frame in your application
> Open the frame
> Tools, Script (Shift F1)
> Paste the sample into the script editor then Save and close the script
> editor.
> Tools, Compile (Ctrl F5)
> File, Save (Ctrl S) just in case
> Debug, Go (F5)
> Check the trace window for any error messages. You should have a little
> popup with a 10 in the middle.
>
> If all looks good you can save and the frame, then set your frame to be the
> starting frame for your application.
starting frame, all of the fields on that tab a disabled and I'm not
able to set the Starting Component.
> Then try again Debug, GO at the application level.
Dennis
Paul White
Try changing your sql to this first:
SELECT
:formfield1 = tabfield1,
:formfield3 = tabfield2,
:formfield2 = tabfield3,...
FROM tableName
WHERE fieldname = :fieldName;
If that works ok then I would move the SQL to a userclass which should
handle all the I/O for the table.
Create a user class say uc_tablename, copy the attributes from the database
table (Insert Attributes from Database Table) and create a method getit().
Move the SQL to the user class, something like this:
method getit() =
declare
li_return = integer not null;
enddeclare
{
SELECT
:curobject.tabfield1 = tabfield1,
:curobject.tabfield2 = tabfield2,
:curobject.tabfield3 = tabfield3,...
FROM tableName
WHERE fieldname = :curobject.fieldname;
/* error checking locking etc goes here */
/* Return value for success goes here */
return li_return;
}
On the frame, wrap all the fields in a flexible form and give that form a
name say myform and a datatype of uc_tablename. Then change your frame
script to something like this.
on setvalue myform.fieldname =
declare
li_return = integer not null;
enddeclare
{
li_return = myrecord.readit();
if Li_return <> 0 then
message
}
There are some basic examples in the programmers guide. OR_Program.pdf Chap
6 "working with databases".
(In my opinion this subject should given priority over any other)
I highly recommend David Tondreau's presentation:
Hello OpenROAD! An Introduction to Rapid Application Development for Ingres
It can be found here:
http://www.ingres.com/about/ondemand-webcasts.php?category=OpenRoad-Applicat
ion-Development
Other useful OpenROAD links are here:
http://groups.google.com.au/group/openroad-users/web/related-websites
Paul
-----Original Message-----
From: openroa...@googlegroups.com
[mailto:openroa...@googlegroups.com] On Behalf Of droesler
Sent: Wednesday, 6 May 2009 3:32 PM
To: OpenROAD Users Mailing List
Subject: [openroad-users] Re: E_D00068 ERROR: Compile errors in component
FormName
Paul White
> Where do I look at compile errors? I thought they were in the trace
> window, but I don't think they are.
Compile errors pop up in a separate window which you can leave open while
you are editing. Then when you save your work and re-compile the popup
window refreshes. If you have set II_W4GL_COMPILEEDITOR then the feature
will behave differently.
Paul
Neil Warnock
I could be wrong here but I think "Formname =" is an ABF thing only. Neil.
Sent from my BlackBerry® wireless device
-----Original Message-----
From: droesler <droe...@comcast.net>
Date: Tue, 5 May 2009 22:32:11
To: OpenROAD Users Mailing List<openroa...@googlegroups.com>
Subject: [openroad-users] Re: E_D00068 ERROR: Compile errors in component
FormName
Bodo Bergmann
Don't forget to "Save & Close" them afterwards.
Bodo.
Bodo Bergmann | Sr. Software Engineer | Bodo.B...@ingres.com | Ingres Germany GmbH | Ohmstr. 12 | 63225 Langen | GERMANY | +49 6103 9881 0
-----Original Message-----
From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of droesler
Sent: Wednesday, May 06, 2009 7:45 AM
To: OpenROAD Users Mailing List
Bodo Bergmann
This is ABF code you are trying to write.
Though there are some common language constructs they are not the same.
Take your time to read the documentation, i.e. Programming Guide, User Guide, Language Reference Manual,
or even better - attend an OpenROAD training course.
The documentation is either part of your installation, available for download and online,
e.g. for accessing the database see http://docs.ingres.com/OpenROAD/2006/Programming%20Guide/6_workingwithadatabase.htm
Bodo.
Bodo Bergmann | Sr. Software Engineer | Bodo.B...@ingres.com | Ingres Germany GmbH | Ohmstr. 12 | 63225 Langen | GERMANY | +49 6103 9881 0
From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of droesler
Sent: Wednesday, May 06, 2009 7:32 AM
To: OpenROAD Users Mailing List
droesler
> You have to "Open" the application properties before you can change them.
> Don't forget to "Save & Close" them afterwards.
>
was "open".
Dennis
droesler
> Dennis,
>
> This is ABF code you are trying to write.
> Though there are some common language constructs they are not the same.
>
> Take your time to read the documentation, i.e. Programming Guide, User Guide, Language Reference Manual,
> or even better - attend an OpenROAD training course.
Probably was looking for a little more "instant gratification" knowing
I would need to "go back and do it right" :-)
Thanks
Dennis
Colin Hay
We are looking for an existing application that lets you create SQL
queries, save them as files, run them against Ingres with parameter
prompting and produce the output in spreadsheet form e.g. Excel
Microsoft Query does all that but is fiddly to set up and where a
parameter is being used twice in a WHERE clause, it prompts you twice
Ingres Visual DBA is much simpler but there is no parameter passing and
no obvious way to save the output
Is there some other app out there that lets you do it all ?
Colin Hay
Database Administrator
Fintechnix
Level 3,
55 Clarence Street,
Sydney
coli...@fintechnix.com
Phone: +61 2 8234 8276
Specialist providers of back and front office systems for the financial services industry.
Featuring: Fintechnix(r)
Disclaimer:
Notice: This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it.
Any views expressed in this message are those of the individual sender,except where the sender specifically states them to be the views of Fintechnix Pty Ltd.
Durwin Wright
Please contact Joesph Kronk or myself privately. We may have something
that might catch your interest.
We definitely know how to do this reliably and send the output either
directly to CSV, TAB delimited or Excel. We even know how to support
any Unicode character as well. The queries can be saved and customized.
Durwin Wright | Sr. Architect | Durwin...@ingres.com | Ingres | 500
Arguello Street | Suite 200 | Redwood City | CA | 94063 | USA +1
650-587-5523 | fax: +1 650-587-5550 | "Wag the Dog"
TBiServices (Thierry Boutevin)
Tim....@rwesystemsuk.com
--------------
Name: <none>
Object Type: menubar
DataType: <none>
Object Type: matrixfield
DataType: <none>
--------------
Name: <none>
Object Type: barfield
DataType: i4
Object Type: matrixfield
DataType: <none>
--------------
Name: <none>
Object Type: menubar
DataType: <none>
Object Type: matrixfield
DataType: <none>
--------------
Name: <none>
Object Type: freetrim -- what was a barfield is now freetrim
DataType: <none>
--------------
Name: stylefield1_1 - This lable is new
Object Type: freetrim
DataType: varchar(100)
-----------
Value Text
2 "Second Item"
3 "Third Item"
Object Type: imagetrim
DataType: bitmapobject
Image File: d:\hi_art\frame_editor_24mar94\ImagTrm3.BMP
Tim Davis
Support Analyst
Programmer
Customer Services Team
Residential Applications
Management
RWE IT UK
Please consider the environment before printing this email.
**********************************************************************
This e-mail including any attachments is provided for general information purposes only and does not constitute advice except to the addressee if expressly stated in this email. For the avoidance of doubt the contents of this email and any attachments are subject to contract and are not intended to and will not constitute a legally binding contract or any part of a legally binding contract.
The information contained in this email and any attachments is confidential. It is intended only for the use of the intended recipient at the email address to which it has been addressed. If the reader of this message is not an intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution or copying of the message or associated attachments is strictly prohibited.
If you have received this e-mail in error, please notify postm...@RWEsystemsUK.com and permanently delete the email and any attachments immediately from your system. You should not retain, copy or use this email or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you for your co-operation.
Neither RWE IT UK Ltd nor any of the other companies in the RWE Group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses.
RWE IT UK Ltd Registered office: Mistral, Westlea Campus, Chelmsford Road, Swindon, Wiltshire, SN5 7EZ. Registered in England and Wales: company number 6052966.
*******************************************
Bodo Bergmann
Hi Barry,
First of all, DocumentApp (-a) is not a very reliable source for “diffing”,
but anyway I’m trying to explain some of the problems you encounter:
Most of the items you mention are not from the fields you
created, but come from the field style prototype fields in the “Style
Sheet” (Tools menu),
e.g. the stylefield1_1, stylefield13_1 and variant_bb items.
Basically you should remove all the StyleSheet fields from the
documentapp output before doing a diff,
otherwise you will just see diffs in the internal implementation of the style
sheet – nothing what you should really care about.
Also there are some “false friends”, e.g. the
reported MenuBar might just the remainder of a menu which doesn’t
exist any more:
When deleting all menu groups from a menu that menu disappears from the view of
the developer, but the underlying MenuBar is still existent and gets reported.
And then there are cases were only the order of the fields in the output is different, so there it’s actually a “move” rather than a “diff”.
Example: The order of the child fields of a table field will
change by switching off “HasScrollbar” and switching it on again.
This is because “documentapp” reports the children according
to their occurance within the childfields array.
Switching the attribute off removes the scrollbar from this array, switching it
on again appends the scrollbar to the end of that array.
So, doing a “diff” with some common line-oriented “diff” tools will report lots of differences – they don’t detect that the field is still there, just at another position.
Hope this helps.
Regards,
Bodo.
Bodo Bergmann | Sr. Software Engineer | Bodo.B...@ingres.com | Ingres Germany GmbH | Ohmstr. 12 | 63225 Langen | GERMANY | +49 6103 9881 0
Tim....@rwesystemsuk.com
From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Bodo Bergmann
Sent: 12 May 2009 11:22
To: openroa...@googlegroups.com
Cc: Davison, Barry (CIB)
Subject: [openroad-users] Re: DocumentApp