File encoding/ EOF/EOL diff. between Notepad and Textpad

[jnsunkersett]

Hi,

I prefer Textpad over the Ms Windows default editor - Notepad.

What is the exact difference between files saved using Notepad and Textpad ... I am suspecting some difference between

* End-of-Line character or
* End-of-File character or
* File-Encoding

To detail my problem, I have described my problem;

I require an editor to develop database SQL scripts; I apply them using dbMaintain (www.dbmaintain.org)

1. But when i save my sql script; using textpad and execute using dbMaintain, I get an error:
... Client_Attribute_alter_script.sql: Last statement in script was not ended correctly.

2. If I open and save the same script using Notepad, I am able to execute it easily using dbMaintain.

3. I am bid to find out why, I opened and saved the successfully executed script using Textad ... and dbMaintain gave the same error.

can you please help me?
~jeevan

https://sourceforge.net/projects/dbmain ... ic/5645230

[bbadmin]

You could try enabling the option to "Automatically terminate the last line of the file" on the Editor page of the Preferences dialog box.