... The builder converts {LF} into {CR}{LF} and your informal expressed intention isnt implemented: newlines consting only of an {LF} dont convert a '_' into...
Bingo! Thank you. I didn't consider that the Builder environment actually changed my file, but now that you mention it, I have noticed it doing strange...
I am new here, but since I was helped, I will try to reciprocate. I believe you need to change {Printable} to {ANSI Printable} to get characters above 127. ...
Geo, Please let me know if you still need help with the engine. I can look into it over the weekend. Thank you, Vlad ... noticed ... whitespace. ... by a...
Copy and paste the following first grammar into GOLD: "Start Symbol" = <Program> <Program> ::= <First Opt> 'a' 'b' <First Opt> ::= <Second Opt> 'a ... <Second...
I'm new to the GOLDParser product. I am looking to extend an existing grammer that was passed on to me by the company I am working for. Basically, it is a...
Hi Wayne, I am working on a grammar as well. How far along are you? I added some basic stuff like multipart names, complex joins, SQL statements as column...
Hi Mike I am a noob myself but may be able to help: Assuming you have left the sql89 grammar fairly intact try this: Terminal: Asteric = {#64} Rules: <Variable...
Hi, To create a grammar that uses '//' to comment a line i do Comment Line = '//' And if I want both, symbol '#' or symbol '//' to comment a line, how do I do...
To what extent have you tested your grammar against real SQL statements? Would you be interested in getting a pile of SQL statements and/or sharing the...
Hey Wayne, I have started to test my grammar at a fairly fundemental level. It is working good so far. I have not refactored any of the rules in the grammar...
Do these parse with your grammar? ... CREATE FUNCTION dbo.fnSetSplitSV (@String VARCHAR(MAX), @Delim VARCHAR(5)) RETURNS TABLE AS RETURN ( WITH Splitter (Num,...
I have created a testing suite that uses the cathlia parser and runs through all the .sql I have to test with and outputs issues. -Wayne _____ From:...
Hey Wayne I am not familiar with the cathila parser (I am noob). To directly answer your question I can not parse the SQl you provided just yet. I have...
The MS SQL Help is EBNF so you really can't use it and it is wrong in spots. I can't remember what I started with however, I am not done yet. -Wayne _____ ...
I realize it is EBNF but it is helpful and easy to convert from one notation to the other. Two quick questions I forgot to ask: 1) How are you handing UDF's...
SQL Server does not parse the provided Query: Msg 156, Level 15, State 1, Procedure fnSetSplitSV, Line 30 Incorrect syntax near the keyword 'WITH'. ... Thanks ...
... I am using 2005: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard ...
"Is this what you would call a bug in the EBNF or just a lexical error?". That is what I call a bug in the EBNF, if your BNF matches the EBNF, however SQL...
I can't tell exactly what you are working on so this might not be any help at all. If you have a DB that's already populated then this is not really going to ...
There are two separate SQL Statements in there, one is a CREATE FUNCTION, the other is a stand-alone CTE. If you want to try them both you need to do them one...
BTW, hard-wiring 'dbo.' into the schema name is probably not a good idea. You could create a UDF like the following: CREATE FUNCTION AdventureWorks.AddOne (@i...
I guess I am making the subtle distinction that the EBNF expresses valid syntax and in fact a syntax error is not thrown, instead a lexical type of error is...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
