Problem with revExecuteSQL - More

Jan Schenkel janschenkel at yahoo.com
Thu Nov 1 05:27:45 EDT 2007


--- Dave <dave at looktowindward.com> wrote:
> Hi,
> 
> I am using SQLIte, I can't seem to find anything
> that says what the  
> escape sequence character is. Does anyone know if
> this is possible  
> with SQLite?
> 
> Also, is this the same problem that I am getting
> with the ":"  
> characters in the date field? If so, is the solution
> the same?
> 
> Thanks a lot
> All the Best
> Dave
> 

Hi Dave,

I took a quick glance at the sqlite.org website:
<http://www.sqlite.org/lang_expr.html>
where they advise you to use apostrophe instead of
quote, and that you should double the apostrophe when
it occurs within the string.

As for the colon, try using apostrophe first instead
of quotes. SQLite doesn't have real date-time fields
so they're stored as strings anyway.

Hope this helped,

Jan Schenkel.

Quartam Reports & PDF Library for Revolution
<http://www.quartam.com>

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



More information about the Use-livecode mailing list