Access 97 ja SQL

Article View: ee.prog

Article #30

#30

From: T�nis Aruste
Date: Tue, 28 Sep 1999 00:00

14 lines
1091 bytes

Probleem Accessi andmebaasi kasutamisega l�bi ODBC & SQL-i. Nimelt �ritan
SELECT lausele panna tingimust " nimi LIKE 'x*' ", mis idee poolest peaks
andma k�ik x-ga algavad nimed. Kui vastav lause k�ivitada Accessi enda
keskkonnas testimiseks loodud Query sees, on k�ik OK ja nimed tulevad
robinal. Kui lause saadetakse Accessi l�bi ODBC, ei tagasta p�ring �htegi
x-ga algavat nime, kuigi neid eksisteerib. Mida ma olen kahe silma vahele
j�tnud????

Accessi ODBC draiveri ver. on 3.51.171300
Access 97 SR-1

t�nis

PS! Vastuseid ootan privas

Technical Details

Message-ID: <7spp3v$l0o$1@galaxy.data.ee>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ESTONIAN,CP1257
X-Google-Thread: f8b3f,ada97a1639615e67,start
X-Google-Attributes: gidf8b3f,public
X-Google-Thread: 101f2d,ada97a1639615e67,start
X-Google-Attributes: gid101f2d,public
From: "T�nis Aruste" <tonis.aruste@mail.ee>
Subject: Access 97 ja SQL
Date: 1999/09/28
Message-ID: <7spp3v$l0o$1@galaxy.data.ee>
X-Deja-AN: 530196082
Distribution: Estonia
Organization: EUnet Estonia
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: ee.prog,ee.arvutid.microsoft