Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 358680

Summary: Content Assist does NOT prompt string variable for "prepare"
Product: z_Archived Reporter: Yu Hao <yuhaodl>
Component: EDTAssignee: Xiao Bin Chen <xiaobinc>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: chenzhh, xiaobinc, yuhaodl
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Attachments:
Description Flags
Patch for SQL String to with statement
lasher: iplog+
enable prepare to use with_str lasher: iplog+

Description Yu Hao CLA 2011-09-22 22:21:20 EDT
Build Identifier: 201109222102

Use to content assist to define "prepare SQL statement with string expression" did not prompt the string variable which had already been defined

Reproducible: Always

Steps to Reproduce:
1.Create a program
2.write following code:
package test;

// basic program
//
program myPro type BasicProgram {}
	
	ds SQLDataSource = new SQLDataSource("aaaa");
	rs SQLResultSet;
	sqlstat SQLStatement;
	strstat string = "select * from customer";
	
		
	function main()
		
	end
	
end

3.type "pre" inside main() function and wake content assist then select "prepare SQL statement with string expression", move behind "with" and wake up content assist, the string "strstat" was not prompted
Comment 1 Xiao Bin Chen CLA 2011-09-25 22:48:02 EDT
Created attachment 203983 [details]
Patch for SQL String to with statement
Comment 2 Xiao Bin Chen CLA 2011-09-26 01:10:09 EDT
fixed
Comment 3 Xiao Bin Chen CLA 2011-09-27 03:11:21 EDT
Created attachment 204051 [details]
enable prepare to use with_str
Comment 4 Yu Hao CLA 2011-09-30 01:45:15 EDT
verified in 201109292101