Home » Archived » EGL Development Tools » Migrating EGL CE projects to EDT
|
| Re: Migrating EGL CE projects to EDT [message #763332 is a reply to message #763326] |
Fri, 09 December 2011 10:29   |
Eclipse User |
|
|
|
Kevin - I would start here: http://wiki.eclipse.org/EDT:How_to_move_RBD_app_to_EDT
An EDT "Web 2.0 client with services" project is configured for both Java and JavaScript like a CE project (the client package is setup for JS, server is setup for Java, and common is setup for both). You can put EGL parts that will run on the server in "server" (so, like services), RUI and client-side parts in "client", and common parts (records, common libraries), under "common". Of course, if you already have your own package structure, you can replicate this in an EDT project, and then configure the compiler/generator settings for a package or part via Properties > EDT Compiler.
|
|
| | |
| Migrating EGL CE projects to EDT - Joined Record [message #763471 is a reply to message #763326] |
Fri, 09 December 2011 15:43 |
| Eclipse User |
|
|
|
Thanks for the tips guys.
I was able to join tables in CE using content assist for Record, see code.
What is the corresponding syntax for a join in EDT?
Record EventContacts type SQLRecord
{tableNames = [["contacts", "a"] ,["event_contacts", "b"]],
defaultSelectCondition = #sqlCondition{a.Contact_ICN = b.Contact_ICN},
keyItems=[Contact_ICN, Contact_Name, Contact_Email, event_contacts_Contact_ICN, Event_ID, RuleNo]
}
Contact_ICN int {column="a.Contact_ICN", isReadOnly=yes};
Contact_Name string {column="a.Contact_Name", isReadOnly=yes, sqlVariableLen=yes, maxLen=30};
Contact_Email string {column="a.Contact_Email", isReadOnly=yes, sqlVariableLen=yes, maxLen=50};
Contact_Cell_No decimal(10) {column="a.Contact_Cell_No", isReadOnly=yes};
Contact_Cell_Service string {column="a.Contact_Cell_Service", isReadOnly=yes, sqlVariableLen=yes, maxLen=30};
Contact_Status string {column="a.Contact_Status", isReadOnly=yes, maxLen=8};
Event_Contacts_Contact_ICN int {column="b.Contact_ICN", isReadOnly=yes};
Event_ID string {column="b.Event_ID", isReadOnly=yes, maxLen=5};
RuleNo int {column="b.RuleNo", isReadOnly=yes};
end
[Updated on: Fri, 09 December 2011 18:06] by Moderator |
|
|
| Re: Migrating EGL CE projects to EDT - Joined Record [message #764633 is a reply to message #763471] |
Mon, 12 December 2011 10:05 |
| Eclipse User |
|
|
|
EDT 0.7.0 does not support syntax to generate a JOIN statement.
You will need to change your record and write an SQL statement to support the JOIN.
Record EventContacts
Contact_ICN int {@Column {updateable = false}};
Contact_Name string {@Column {updateable = false}};
Contact_Email string {@Column {updateable = false}};
Contact_Cell_No decimal(10) {@Column {updateable = false}};
Contact_Cell_Service string {@Column {updateable = false}};
Contact_Status string {@Column {updateable = false}};
Event_Contacts_Contact_ICN int {@Column {updateable = false}};
Event_ID string {@Column {updateable = false}};
RuleNo int {@Column {updateable = false}};
end
There are a few ways to write an SQL JOIN, here's how I would start the SQL using the record you provided:
GET eventContacts from ds with
#sql{
select
contacts.Contact_ICN, rtrim(contacts.Contact_Name), rtrim(contacts.Contact_Email),
contacts.Contact_Cell_No, rtrim(contacts.Contact_Cell_Service),
rtrim(contacts.Contact_Status), event_contacts.Contact_ICN,
rtrim(event_contacts.Event_ID), event_contacts.RuleNo
from contacts, event_contacts ............complete the JOIN statement
};
regards,
Joe
|
|
| | |
Goto Forum:
Current Time: Sun Jul 13 07:48:32 EDT 2025
Powered by FUDForum. Page generated in 0.06670 seconds |
Home