Re: [sqlite] Syntax clarification
The .add indicates you're using some kind of dictionary type of class like
a tStringList and would append that string to the end of that dictionary.
The .Text would replace the contents of the dictionary with that string.
On Friday, December 28, 2018, Dave Delage wrote:
> I've searched without success for this answer. I use SQLite3, Zeos and
Delphi so maybe this isn't a perfectly sqlite3 question but here goes:
>
> What are the pros/cons of query.sql.text := 'some string'; versus
query.sql.add('some string');
>
> Dave
>
>
>
>
>
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Syntax clarification
> On Dec 28, 2018, at 3:25 PM, Dave Delage wrote:
>
> What are the pros/cons of query.sql.text := 'some string'; versus
> query.sql.add('some string');
That sounds like a Delphi (Pascal?) question, not anything about SQLite itself.
I haven’t used Pascal since the 1980s, but it looks like the first form assigns
a string directly while the second appends to a string. Use whichever one is
appropriate...
—Jens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
