basic one

sql Ireland
  • 11 years ago


    this is probably really basic but in my loop it steps through a cursor that checks for errors and then adds it to a table but the bit that gets me is that the first error is put into the TABLE as below but the next overwrights it, i want to concat all messages together before i do the INSERT but how can store each error as it loops.
    while cursor FIRST to LAST
    select error-message INTO error_message where error_message1 || error_message2 || error_message3;|

    INSERT INTO TABLE values (error_message);

    <END LOOP>

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Programs must be written for people to read, and only incidentally for machines to execute.”