xText Grammer Scoping for SQL SELECT statement [message #552073] |
Tue, 10 August 2010 13:27  |
Eclipse User |
|
|
|
Do you need to know Java coding to implement scoping in xText? Or it can be all implemented in a xText grammer alone.
For example, I have a SQL "SELECT" xText grammer (not to reinvent the wheel, I am adapting this xText grammer, please see link
http://www.eclipse.org/forums/index.php?t=msg&goto=55180 5&S=ae2e996116dc9c0a1864fa097bd3e0e2#msg_551805).
I have two tables, Customer and PhoneNumber. Table Customer has columns called CustomerID and CustomerName.
And Table PhoneNumber has two columns called CustomerID and WorkNumber.
The following SQL statement will retreive the work numbers for all the customers.
SELECT Customer.CustomerName, PhoneNumber.WorkNumber
FROM Customer
INNER JOIN PhoneNumber ON Customer.CustomerID = PhoneNumber.CustomerID
How would I implement scoping for the table Customer so that Content Assist will only show CustomerID and CustomerName?
Likewise, table PhoneNumber will show CustomerID and WorkNumber.
Any help would be greatly appreciated. Thanks.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.08245 seconds