fwiw, just ran runsql.taf against one of our rbase db's... worked just fine.
sel * from location where locno='003'
Brent Skean
Current Solutions
-----Original Message-----
From: Dan Stein <[EMAIL PROTECTED]>
To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
Date: Saturday, January 18, 2003 6:40 PM
Subject: Witango-Talk: Execute SQL taf still a problem
>I have used this for awhile as a way to do a query, update, insert etc to
my
>DB but I always have a problem with
>Select * from registration where Lname='Cat'
>
>The debug code shows
>
>Select * from registration where Lname=' 'Cat' '
>
>Or if I put in Select * from registration where Lname=Cat
>
>It gives me Select * from registration where Lname= Cat
>
>Which is also an error
>
>Even if I try and double quote things it does not work
>
>What am I doing wrong and is there another solution
>
>I am on Witango 5 and MSSQL 2000
>
>If someone could connect this taf to any table on their system and get it
to
>run or suggest a better way for me to set up a single taf to do simple
>queries I would be most happy. I am usually doing selects, sometimes
updates
>a rarely deletes.
>
>I do think there is a need for a taf that would allow remote DB access.
>Someone had one for RBASE but we need on that is more DB agnostic.
>
>
>
>
>--
>Dan Stein
>Digital Software Solutions
>799 Evergreen Circle
>Telford PA 18969
>Land: 215-799-0192
>Mobile: 610-256-2843
>Fax 413-410-9682
>FMP, WiTango, EDI,SQL 2000
>[EMAIL PROTECTED]
>www.dss-db.com
>
>
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
