Suggestions & Feedback
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Forum Information > Suggestions & Feedback
Reload this Page

Syntax highlighting enhancements

Discuss Syntax highlighting enhancements in the Suggestions & Feedback forum on Dev Shed.
Syntax highlighting enhancements Use this forum for either suggesting ideas or submitting feedback about our forums. Suggestions, constructive criticism, and other feedback appreciated.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Page 1 of 3 1 2 3 >
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old September 23rd, 2005, 03:21 PM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,633 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 4 Days 10 h 5 m 36 sec
Reputation Power: 259
Syntax highlighting enhancements
Hi, I'm posting this here as Jcaputo suggested me to summarize my suggestions about syntax highlighting.
Hope that others who have suggestions about this will add their comments here making easier for Devshed to track those suggestions.
Now, I see that a lot of keywords are not highlighted in SQL, expecially those related to stored procedures, which will be soon supported by all databases represented here, so here is my list:
sql Code:
Original - sql Code 
  1. UNION 
  2. PROCEDURE 
  3. DECLARE 
  4. CURSOR 
  5. OPEN 
  6. FETCH 
  7. NEXT 
  8. WHILE 
  9. BEGIN 
  10. CLOSE 
  11. DEALLOCATE

also
sql Code:
Original - sql Code 
  1. #weeklytemp 
  2.  
is seen as a comment when (at least in mssql) it's a temporary table.
Hope this helps.
Reply With Quote
  #2  
Old September 26th, 2005, 12:48 PM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,633 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 4 Days 10 h 5 m 36 sec
Reputation Power: 259
Another catch:
sql Code:
Original - sql Code 
  1. COALESCE
Reply With Quote
  #3  
Old September 29th, 2005, 04:18 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,633 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 4 Days 10 h 5 m 36 sec
Reputation Power: 259
After another pass it seems that the "oracle8" highlighting option is just a superset of "sql" with stored procs support, maybe it would be worthwile to merge the two. Here is what I found before under oracle8 highlighting:
oracle8 Code:
Original - oracle8 Code 
  1. UNION 
  2. PROCEDURE 
  3. DECLARE 
  4. CURSOR 
  5. OPEN 
  6. FETCH 
  7. NEXT 
  8. WHILE 
  9. BEGIN 
  10. CLOSE 
  11. DEALLOCATE

oracle8 Code:
Original - oracle8 Code 
  1. #weeklytemp 
  2.  
Comments on this post
oneMSBi agrees: take some rep for your efforts to make devshed a better place
Reply With Quote
  #4  
Old September 29th, 2005, 08:44 AM
Jcaputo's Avatar
Jcaputo Jcaputo is offline
Kiss My Converse!
Developer Shed Admin.
  
Join Date: May 2003
Location: Davie, Florida
Posts: 1,511 Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level)Jcaputo User rank is Major (30000 - 40000 Reputation Level) 
Time spent in forums: 2 Weeks 1 Day 14 h 18 m 48 sec
Reputation Power: 10
I believe we are done with the syntax highlighting for now - we wont get to these edits for at least 4-6 weeks, but feel free to keep the syntax suggestions coming as eventually we will have time.
Reply With Quote
  #5  
Old December 5th, 2005, 03:58 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,633 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 4 Days 10 h 5 m 36 sec
Reputation Power: 259
Hi, here are other keywords missing from the sql highlighting
sql Code:
Original - sql Code 
  1. AFTER
  2. EACH ROW
  3. BEGIN
  4. DELIMITER
  5. NEW
  6. OLD

those are used for procedures and triggers. Hope will get added sooner or later.
Reply With Quote
  #6  
Old December 5th, 2005, 08:13 AM
thaminda's Avatar
thaminda thaminda is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Sep 2004
Posts: 396 thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 1 Week 3 Days 19 h 45 m 3 sec
Reputation Power: 415
Quote:
Originally Posted by pabloj
After another pass it seems that the "oracle8" highlighting option is just a superset of "sql" with stored procs support, maybe it would be worthwile to merge the two. Here is what I found before under oracle8 highlighting:
oracle8 Code:
Original - oracle8 Code 
  1. UNION 
  2. PROCEDURE 
  3. DECLARE 
  4. CURSOR 
  5. OPEN 
  6. FETCH 
  7. NEXT 
  8. WHILE 
  9. BEGIN 
  10. CLOSE 
  11. DEALLOCATE

oracle8 Code:
Original - oracle8 Code 
  1. #weeklytemp 
  2.  


These words added to Oracle key words list.

Added single line comments option
Comments on this post
aitken325i agrees!
Reply With Quote
  #7  
Old December 5th, 2005, 08:13 AM
thaminda's Avatar
thaminda thaminda is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Sep 2004
Posts: 396 thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)thaminda User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 1 Week 3 Days 19 h 45 m 3 sec
Reputation Power: 415
Quote:
Originally Posted by pabloj
Hi, here are other keywords missing from the sql highlighting
sql Code:
Original - sql Code 
  1. AFTER
  2. EACH ROW
  3. BEGIN
  4. DELIMITER
  5. NEW
  6. OLD

those are used for procedures and triggers. Hope will get added sooner or later.


These words added to SQL key words list.
Reply With Quote
  #8  
Old December 5th, 2005, 08:15 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,633 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 4 Days 10 h 5 m 36 sec
Reputation Power: 259
I can only say A BIG THANK YOU
Reply With Quote
  #9  
Old April 11th, 2006, 05:59 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,633 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 4 Days 10 h 5 m 36 sec
Reputation Power: 259
Just catched a small gotcha in php syntax highlighting, functions like ibase_service_attach and ibase_server_info are not highlighted and linked to the php manual, see this post as an example.
Reply With Quote
  #10  
Old April 11th, 2006, 08:07 AM