Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009

    Question Unanswered: From MSSQL to PSQL

    I have a small problem with rewriting something sql

    I usually code Mssql but I stand in the situation that I have a client who is going to use some software, but they have a pervasive database. and I will I have a record locked. but I must also return the fule record.

    in Mssql, I would write:
    UPDATE [TableName] WITH (ROWLOCK) SET [CellName] = [CellName] + 1 OUTPT INSERTED.*

    I hope some of you there can help me

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 4
    THe (ROWLOCK) and "OUPT INSERTED.*" syntax is not supported with PSQL. PSQL will automatically lock the record while it updates.
    Try it without the invalid syntax and see if it works for you.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts