INSERT problems...

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Michael Sigal Wed, 03 Feb 1999 00:00

#17

Author: 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
=============================

Re: INSERT problems...

#18

Author: Steve Koterski
Date: Thu, 04 Feb 1999 00:00

35 lines
2106 bytes

On Wed, 03 Feb 1999 16:32:10 -0800, Michael Sigal <msigal@home.com> wrote:

>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.

Your SQL statement appears to be within acceptable parameters for SQL. Does
the same statement work when using the native Paradox driver that comes
with Visual dBASE and the BDE? If so, you might want to ask your question
of Microsoft, the apparent producer of your ODBC driver. It would appear
that there is something wrong with that ODBC driver if it does not accept
such simple, valid SQL.

Besides, why are you using an ODBC driver at all, when the BDE supplies you
with a native driver?

//////////////////////////////////////////////////////////////////////////
Steve Koterski                       "For people who like peace and quiet:
Technical Publications               a phoneless cord."
INPRISE Corporation                                             -- Unknown
http://www.inprise.com/delphi

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads