U++ forum: Welcome to the forum

Re: sch file editor [message #37704 is a reply to message #37701]

Sun, 04 November 2012 15:21

dolik.rce
Messages: 1789
Registered: August 2008
Location: Czech Republic

Ultimate Contributor

Hi omari,

It looks interesting, but I don't quite see how it can help anyone. To use it, you need to have some understanding about .sch files and about SQL in general - I'd say that as much as you'd need to write the .sch file yourself. Maybe one thing that might be good about the editor is that it prevents typos and should always generate valid .sch file, but that can be easily checked by trying to compile it.

Is there anything in particular that led you to write this editor? I'm not trying to say it is useless, I'm just curious, because I usually prefer to write everything manually, without specialized editor Wink

After testing, I have few notes to the program itself:
1) It should allow 0-9 and '_' characters in table and column names, it is valid sql and I use them a lot in my schemas Wink

2) You should add a column for default value, that is very common in my schemas too Wink

3) It fails on parsing errors when loading more complex sch files. Aside from perfecting the parser (I understand it is just first version Smile

), you should wrap the load functionality in try/catch block, so the application doesn't crash when user imports malformed text from file or clipboard. If you want to test, you can try with the watchdog scheme, it fails probably because it contains some macros not yet supported by your editor.

Best regards,
Honza

Report message to a moderator