Hi all,

I am having a situation where I am reading a file called db.sql containing tables,unique,sequence,index,etc.

Basically my application can read and write all this.

Whenever db.sql is having views or stored procedures my aprser is giving error.

I made changes in parser to read views,

but of no use since application is not having any information about redng writing views,procdures further.

Now the only solution i am having to ignore them writing(appending) " -- " in front of views or procedures. so that my parser(while reading) and complete application while writing(generating database from db.sql schema) can simply ignore it.

Please give me some ideas to make this happen.

Its like:

"its reading from stream of characters from the file, and then sending to the parser."

In between i need a mechanism from which i can do my ignorence portion please give me hints,solutions whatever is possible in this stage.

My work is pending for a long time..



Thanks.



Vijendra Singh