basic one

sql Ireland
  • 11 years ago

    Hi,

    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.
    <LOOP>
    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).

Contribute

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.

“Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.” - Brian Kernighan