Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 361828 - CNTL-1 has "no suggestions available" for SQL open rs from ds for row.
Summary: CNTL-1 has "no suggestions available" for SQL open rs from ds for row.
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Zhi Zhu CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-24 12:20 EDT by Paul Hoffman CLA
Modified: 2017-02-23 14:16 EST (History)
2 users (show)

See Also:

Attachments
library for loading database for test program (3.53 KB, application/octet-stream)
2011-10-24 12:21 EDT, Paul Hoffman CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Paul Hoffman CLA 2011-10-24 12:20:50 EDT 
CNTL-1 for get row from ds shows default select statement used for the get.

CNTL-1 for open rs from ds for row should show the default select statement used for the open.

To see problem, open test case program, position cursor after "open" and press CNTL-1.
Comment 1 Paul Hoffman CLA 2011-10-24 12:21:16 EDT 
Created attachment 205845 [details]
library for loading database for test program
Comment 2 Zhi Zhu CLA 2011-10-25 21:01:12 EDT 
Paul, do not see any get or open statement in your attachment.

Do you mean:
  myCustomer Customer;
  connUrl string = “jdbc:derby:SomeDB;create=true;”;
  ds SQLDataSource = new SQLDataSource(connUrl);

  get myCustomer from ds;

  should generate sql like this:
    get myCustomer from ds using(myCustomer.id) with #sql{
	SELECT *
	FROM CUSTOMER
	WHERE id = ?
   };

  This works based on your comment

  For open statement:
   rs SQLResultSet;
   open rs from ds;

   Should we get sql like this:

    open rs from ds with #sql{
	SELECT * 
        FROM CUSTOMER
    };

   if you want default sql for statement: open rs from ds;

    Here is the question, where do I get table schema?
Comment 3 Zhi Zhu CLA 2011-10-25 22:41:01 EDT 
Paul, are you referring to this open statement:

  open rs from ds for row ;

Where I can get table message from 'row'?
Comment 4 Zhi Zhu CLA 2011-10-26 20:41:18 EDT 
please refer to bug 362139
Comment 5 Zhi Zhu CLA 2011-10-26 20:58:14 EDT 
EGLSQLClauseFactory.java
SQLIOStatementUtility.java
AbstractSQLStatementProposal.java
SQLAssistantSubProcessor.java
Comment 6 Paul Hoffman CLA 2011-11-02 10:41:28 EDT 
Verified and closed