Re: Another ODBC/SQL question

Article View: comp.lang.perl.misc

Article #65

Back to comp.lang.perl.misc Previous Next

#65

From: Yossi Konijn
Date: Thu, 24 Oct 1996 00:00

32 lines
1672 bytes

Ok, I solved the first problem, it was a problem that
ServiceRecords.Status='ON' only receives 1 and 0 and QueryId should be
compared to a number without the quotes.

Still waiting fo help on number 2 (entering a single quote in a text
field using SQL).

Thanks,

Yossi

On Thu, 24 Oct 1996 11:53:41 GMT, yossik@accentsoft.com (Yossi Konijn)
wrote:

>Hi all,
>
>Since last time this group was of great help, I'll try my luck again.
>I'm using ODBC.PL to connect to Access 7.0. I have no problems sending
>INSERTand SELECT SQL commands, but the update appears not to give the
>proper result. This is the command I'm sending:
>
>UPDATE ServiceRecords 
>SET 
>QueryID = '144', CustomerID='123456789012345',
>EmployeeID='YossiK', ServiceDate = '24/10/96', ServiceTime =
.
.
.
>Oh, and while on the subject, does anyone know what escape sequence I
>should use to send a single-quote to a text field? I'm trying to type
>'Can't' but the quotes are confusing Access.

Technical Details

Message-ID: <32719a0a.23151825@news.netvision.net.il>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <54nomb$j88@news.NetVision.net.il>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f591,5d3951a8a6107760
X-Google-Attributes: gid10f591,public
X-Google-Thread: f6611,5d3951a8a6107760
X-Google-Attributes: gidf6611,public
X-Google-Thread: fa0ae,5d3951a8a6107760
X-Google-Attributes: gidfa0ae,public
From: yossik@accentsoft.com (Yossi Konijn)
Subject: Re: Another ODBC/SQL question
Date: 1996/10/24
Message-ID: <32719a0a.23151825@news.netvision.net.il>
X-Deja-AN: 191906276
references: <54nomb$j88@news.NetVision.net.il>
content-type: text/plain; charset=us-ascii
organization: NetVision LTD.
mime-version: 1.0
newsgroups: comp.lang.perl.misc,comp.lang.perl.modules,bit.databases.mssql-l

Reply to Parent Message