ODBC Error during SQL INSERT command

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

ODBC Error during SQL INSERT command

Message

From

08/08/2007 14:21:55

Raza Malik
Universal Accounting Software
Edgewater, New Jersey, United States

03/08/2007 16:41:39

Christof Wollenhaupt
Foxpert
Norderstedt, Germany

General information

Forum:

Visual FoxPro

Category:

Client/server

Title:

Re: ODBC Error during SQL INSERT command

Environment versions

Visual FoxPro:

VFP 7 SP1

Miscellaneous

Thread ID:

01245884

Message ID:

01246851

Views:

Hi Christof...

As you suggested, I did add the SQLCOMMIT command.

=SQLPREPARE(gnC, tcSQL)
nRtnValue = SQLEXEC(gnC, tcSQL, tcCursor)
IF lnRtnValue < 1
  =AERROR[laError]
  tcError = laError[2]
  _Cliptext = tcSQL
ELSE
  =SQLCOMMIT(gnC)
ENDIF

Map

View

Click here to load this message in the networking platform