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


Attachment: runsql.taf
Description: Binary data

Reply via email to