INSERT problems...

Article View: borland.public.vdbase.data.sql

Article #17

Back to borland.public.vdbase.data.sql Previous Next

#17

From: Michael Sigal
Date: Wed, 03 Feb 1999 00:00

30 lines
1333 bytes

Hello,

I am trying to do a simple INSERT statment to a Paradox table, and am
running into a slight problem.

My SQL statement is as follows:

INSERT INTO test(firstName, lastName)
VALUES('Fred', 'Smith')

If my table is empty, this statement works perfectly; however, if my
table is not empty, I get the following error:

Error Diagnostic Information
 ODBC Error Code = S1000 (General error)
 [Microsoft][ODBC Paradox Driver] Operation must use an updatable query.

Is there something I'm missing here?  I've done this with Microsoft
Access without a problem, but would prefer not to work with Access.

Any help would be appreciated,
Michael Sigal

-- 
=============================
  MSigal Interactive Design
-----------------------------
 www.PardonMedia.com/MSigal
      msigal@home.com
=============================

Technical Details

Message-ID: <36B8EA8A.882536C2@home.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,f30b9c2898aa319b,start
X-Google-Attributes: gidff5a1,public
From: Michael Sigal <msigal@home.com>
Subject: INSERT problems...
Date: 1999/02/03
Message-ID: <36B8EA8A.882536C2@home.com>
X-Deja-AN: 440393477
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: MSigal Interactive Design
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql