Hi All,
I am inserting into a Progress Table using ODBCCommandText.Its a simple insert statement.
My Isolation level is set to "Read Committed". I am getting "02/11/2010 3:02:39 PM Test.aspx.cs : ExecuteInsert() ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol...
Well
I was able to do this
Driver properties are still READ COMMITED
and I changed the SQL select statements to
SELECT COLUMN_NAME FROM TABLE_NAME WHERE FIELD_NAME='123' WITH(NOLOCK)
AND now if though the record is Locked by some other application it would still read the record.
Yes...
Hi All,
We are connecting to the Progress Database from ASP.NET web application using the Progress ODBC Driver.
The isolation Level is set to READ COMMITTED IN THE Driver Properties.
We are trying to retreive the data based on certain conditions from one of the web pages.
However, if...
Well I created a sequence and used this in the insert statement and it worked !!!
INSERT INTO TABLE1 ("Column1") VALUES (PUB.""Sequence1"".nextval)
Thanks
Sreenath
Hi All,
I am developing a web page using .NET which inserts a record in the progress database.
I would want the Progress Database to automatically handle the Sequence Number generation for a primary key in a table similar to a IDENTITY COLUMN in SQL Server.
Is this possible ?
Thanks...
Hi,
We are trying to insert records into Progress DB from .NET application using ODBC Connection.
When we use the Insert into command it works fine within the Progress DB where as through ODBC , it gives the error below:
Err.Number = -2147467259
[DataDirect][ODBC Progress OpenEdge Wire...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.