I know it runs against Rbase but not against MSQL 2000
--
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
> From: "Brent Skean" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Sat, 18 Jan 2003 19:13:42 -0800
> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
> Subject: Re: Witango-Talk: Execute SQL taf still a problem
>
> 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
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
