How to insert rows into table via sql with correct updating the rownumber

(0) Share

Report

Posted on by Stephan P

Hi everyone. We use XAL3.50 with an sql server 2008 database.

I need to insert serveral rows in a xal table, so I have to fetch the correct rownumber from the xalseq table to give it to the new row. Does anyone know how xal is working on this problem and how I can solve it using a sql routine? Thanks in advance.

All responses (2)

Answers (0)

Fredrik Reuterskiöld 55 on at

Like (0)

Report

Re: How to insert rows into table via sql with correct updating the rownumber

try this one

SELECT [SEQID]

,[DATASET]

,[SEQNO]

FROM [xal].[dbo].[XALSEQ]
Suggested answer

Henrik Hansen 340 on at

Like (0)

Report

Re: How to insert rows into table via sql with correct updating the rownumber

Hello Stephan,

There is a stored procedure sp_xal_seqno on the database that can be used to increment the rownumber in the xalseq table.

Best Regards

Henrik Hansen