hair-pulling frustration

[Ralph DiMola]

Neil,

With user input and Richard's moderating this thread has started to bear
some fruit. After writing HW diagnostics for years I know how challenging is
to come with thorough testing scenarios. I don't know what your QC process
for databases is but might I suggest using challenging queries. I would be
happy to set up a stack to test them along with the DBs. For example:

SELECT Table1.*, Table2.*,Table3.* FROM Table1 LEFT JOIN Table2 ON
Table1.Designation = Table2.Designation LEFT JOIN Table3 ON Table1.State =
Table3.State AND Table1.County = Table3.County WHERE (Table3.Region = 'Foo')

or

ATTACH DATABASE "Table3.db" AS Table3DB
SELECT Table3.*,Table1.* from Table3DB.Table3 JOIN Table1 ON Table3.CourseID
= Table1.CourseID JOIN Table2 ON Table2.County = Table1.County AND
Table2.State = Table1.State WHERE (Table3.Favorite or Table3.frog <> '')

Mr. Haworth and all you other DB gurus out there, what other testing
scenarios do think should be included in the RR DB QC process?

The way I look at it the more we help RR the more we help ourselves.

 
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 Neil Roger
Sent: Thursday, November 13, 2014 2:59 PM
To: How to use LiveCode
Subject: Re: hair-pulling frustration

Hi Richard,

I've  attempted to replicate the semicolon issue without any success. 
This could be why we have not come accross it during testing in-house. 
The script that I tested with is-

global gConnectionID
on mouseUp
    global gConnectionID
    if gConnectionID is not a number then
       answer error "Please connect to the database first."
       exit to top
    end if
    put "Table1" into tTableName
    put "SELECT * FROM " & tTableName into tSQL

    put revDataFromQuery(,,gConnectionID,"SELECT * FROM Table1;") into tData

    if item 1 of tData = "revdberr" then
       answer error "There was a problem querying the database:" & cr &
tData
    else
       put tData into field "Data"
    end if
end mouseUp


Both the inclusion and exclusion of the semi-colon return data as 
expected. If possible, could you supply a stack for me to test with and 
I will happily look into this further.

Kind Regards,

Neil Roger
-- 
LiveCode Support Team ~ http://www.livecode.com
--







On 13/11/2014 19:09, Dr. Hawkins wrote:
> revDataFromQuery(,,17,"SELECT * FROM vader_darth______001_dna;")
> yields
> Message execution error:
> Error description: value: error executing expression
> Hint: ")


_______________________________________________
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