Storing and retrieving data from a SQL database

[Ralph DiMola]

I know I'm late to the game... When I'm working with binary data
(non-parameterized queries) all I escape on insert/update is the single
quote. Nothing to be done when reading. I've had no problem
storing/retrieving binary data using SQLite/MySQL.

Ralph DiMola
IT Director
Evergreen Information Services
rdimola at evergreeninfo.net

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
Of Peter Haworth
Sent: Sunday, May 22, 2016 1:24 PM
To: How to use LiveCode
Subject: Re: Storing and retrieving data from a SQL database

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
>
_______________________________________________
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