Title: Re: Witango-Talk: Query Problem
|
That's the query generated by Witango in the
insert action.
----- Original Message -----
Sent: Monday, August 25, 2003 12:37
PM
Subject: Re: Witango-Talk: Query
Problem
John Why the �
� around Tracking number.
Witango SQL Query:
INSERT INTO Orders_Tracking
(Order_Number,Tracking Number) VALUES ('@@local$Order_Number','@@local$Item_Description')
Try
on 8/25/03 10:52, John Shaw at [EMAIL PROTECTED] wrote:
Hello
again,
I've been
using this Insert for years and it stopped working last week. It might
have something to do with upgrading to Witango. [Order_Number] and
[Tracking Number] are both varchar fields. Does this have something to
do with the space in my field name? Thanks
Witango SQL Query:
INSERT
INTO Orders_Tracking (Order_Number,"Tracking Number") VALUES
('@@local$Order_Number','@@local$Item_Description')
MS-SQL2000 Error Message:
[SQL Server]Unclosed quotation mark before the
character string ') VALUES
('2003081172288','1ZA761R70141736284')'.
________________________________________________________________________
TO
UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--
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: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
|
