Re: [sqlite] Bind Parameters Documentation

2013-08-20 Thread Richard Hipp 
On Tue, Aug 20, 2013 at 9:24 AM, Filipe Oliveira
wrote:

>
> From my point of view the documentation isn't according to the
> implementation. Can anyone clarify?
>

Undocumented behavior is subject to change.  You are advised to use only
documented behavior.


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bind Parameters Documentation

2013-08-20 Thread Filipe Oliveira 

On 08/12/2013 08:26 PM, Filipe Oliveira wrote:

Hi,

In parameters section of this page 
http://www.sqlite.org/lang_expr.html says that


"A dollar-sign followed by an identifier name also holds a spot for a 
named parameter with the name $. The identifier name in this case 
can include one or more occurrences of "::" ...".


It gave me the impression (because of "in this case") that only 
parameters started with '$' can have occurrences of "::" but the 
tokenizer is accepting them for parameters started with ":" and "@".


Am I misunderstanding the documentation?

Thanks,

Filipe Oliveira

Hi,

For what I can see from the code it is possible to have parameters 
started by '#', '$', '@', and ':' that are succeeded by an identifier. 
This identifier can contain not only occurrences of "::" but also a 
suffix enclosed in "(...)".


tokenize.c - line 316
  /* Fall through into the next case if the '#' is not followed by
  ** a digit. Try to match # where  is a parameter name. */
}
#ifndef SQLITE_OMIT_TCL_VARIABLE
case '$':
#endif
case '@':  /* For compatibility with MS SQL Server */
case ':': {
...

From my point of view the documentation isn't according to the 
implementation. Can anyone clarify?


Thanks,

Filipe Oliveira

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bind Parameters Documentation

2013-08-12 Thread Filipe Oliveira 

Hi,

In parameters section of this page http://www.sqlite.org/lang_expr.html 
says that


"A dollar-sign followed by an identifier name also holds a spot for a 
named parameter with the name $. The identifier name in this case 
can include one or more occurrences of "::" ...".


It gave me the impression (because of "in this case") that only 
parameters started with '$' can have occurrences of "::" but the 
tokenizer is accepting them for parameters started with ":" and "@".


Am I misunderstanding the documentation?

Thanks,

Filipe Oliveira
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users