Problem with revExecuteSQL - More

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

--- Dave <dave at> 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 website:
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

"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 

More information about the Use-livecode mailing list