Storing and retrieving data from a SQL database

[Peter Haworth]

Glad you figured it out Paul.

I'll check out the SQLiteAdmin problem.

On Sun, May 22, 2016 at 7:48 AM Paul Dupuis <paul at researchware.com> wrote:

> On 5/20/2016 10:38 PM, Peter Haworth wrote:
> > Tabs shouldn't be a problem so I suspect something else.
> >
> > Have you tried using LC to select the data after updating it?  As
> mentioned
> > in an earlier post, if you use revDataFromQuery to do the SELECT, be sure
> > to use something other than tab/return for the column/row delimiters.
>
> There was a bug in my code (typo in a variable name). Query parameters
> do handle tabs just fine.
>
> Thank you for walking me through the move to using parametrized queries.
> I've been doing SQL in Livecode for ... many years .. but never tried
> query parameters before.
>
> > I'm wondering if whatever program you used to "directly check" the data
> has
> > a problem with the tabs (fingers crossed it wasn't SQLiteAdmin!).
>
> I am using SQLiteAdmin 1.3.6 (and generally love the tool!). I did just
> notice, when using it to help debug this issue, that I could not paste
> text from the clip board into a field when entering a new record.
>
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>