Activity overview
Latest activity by hansmank
Still pops-up.
No difference. / comments
Still pops-up.
No difference.
When typing sql script, like:
Select * from SomeTable
where cp = 5
and field2 = 'test'
When the cursor is behind the last line and you click Home to place the cursor in front of: and
than click <enter> to open up a new line between the lines "where cp=5" and the line "and field2 = 'test'"
Than the prompt window is activated in (all suggestions).
Moving the cursor up, to go to the new line, places the cursor on "yell" of the code snippets.
When you click tab, you get the AAAAAAARCH! tekst and you are frustrated [image] .
If someone sees this behaviour depends on the formating end editing habbits, but for me it is very anoying.
Hans / comments
When typing sql script, like:
Select * from SomeTable
where cp = 5
and field2 = 'test'
When the cursor is behind the last line and you click Home to place the cursor in front of: and
than click <en...
SQLWB.exe temporarily "hangs" the system
After installing SQL prompt 3.5, I experience a periodical "hang" of my system.
It occured after working for a couple of hours in SQL Server Management studio. I looked in taskmanager and the reaso...
Dear development team,
First code snippet:
I don't know if it is possible in SQL Prompt, but I use CodeSmith to generate a fetch loop for a table by selecting a table from a database.
With tablename: Station, the format is:
--
-- Buffer Station
--
declare @ST_Column1 int
declare @ST_Column2 varchar(5)
declare @ST_Column3 varchar(50)
declare curs_Station cursor for
select
Column1,
Column2,
Column3
from Station
open curs_Station
fetch next from curs_Station into @ST_Column1, @ST_Column2, @ST_Column3 @fetch_status = 0)
begin
--
-- Processing of row starts here
--
fetch next from curs_Station into @ST_Column1, @ST_Column2, @ST_Column3
end
close curs_Station
deallocate curs_Station
It would be nice to generate the above code from SQL Prompt.
Second codesnippet:
The second thing I would like to be able to do from SQL Prompt, is beeing able to generate a column list for a selected Table, to work with in my coding.
Looking forward to the final release,
Hans / comments
Dear development team,
First code snippet:
I don't know if it is possible in SQL Prompt, but I use CodeSmith to generate a fetch loop for a table by selecting a table from a database.
With tablenam...