Storing and retrieving data from a SQL database
pete at lcsql.com
Sun May 22 13:24:23 EDT 2016
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
> > 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
> > 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:
More information about the Use-livecode