阅读下一行的表格 [英] Read table's next row

问题描述

这是我的问题。

我有一张这样的桌子


" DK5" " 184：00 QUOT; " 168：00" " 00：00" 0 0 0 1

" F02" " 185：00 QUOT; " 152：00" " 00：00" 0 2 0 2

" SX1" " 184：00 QUOT; " 107：00 QUOT; " 00：00" 3 0 0 3


我想读到每一行直到表的末尾。

在这里我想要另一个循环，读取下一列''价值。


C语言中没有for循环。我找不到合适的词语来google it。


谢谢！ ：）

解决方案

这是我的问题。

我有一张桌子是像这样


" DK5" " 184：00 QUOT; " 168：00" " 00：00" 0 0 0 1

" F02" " 185：00 QUOT; " 152：00" " 00：00" 0 2 0 2

" SX1" " 184：00 QUOT; " 107：00 QUOT; " 00：00" 3 0 0 3


我想读到每一行直到表的末尾。

在这里我想要另一个循环，读取下一列''价值。


C语言中没有for循环。我找不到合适的词语来google it。


谢谢！ :)

如果你想循环记录使用游标

你是在尝试使用C还是MSSQL？

我使用MS SQL。


如果我用光标如何识别行的结尾？

@@ fetch = 0？


谢谢

This is my problem.
I have a table which is like this

"DK5" "184:00" "168:00" "00:00" 0 0 0 1
"F02" "185:00" "152:00" "00:00" 0 2 0 2
"SX1" "184:00" "107:00" "00:00" 3 0 0 3

I want to read every row until the end of the table.
Inside this I want another loop that reads next column''s value.

there are no for loops as in C language. I can''t find the appropriate words to "google it".

Thank you! :)

解决方案

This is my problem.
I have a table which is like this

"DK5" "184:00" "168:00" "00:00" 0 0 0 1
"F02" "185:00" "152:00" "00:00" 0 2 0 2
"SX1" "184:00" "107:00" "00:00" 3 0 0 3

I want to read every row until the end of the table.
Inside this I want another loop that reads next column''s value.

there are no for loops as in C language. I can''t find the appropriate words to "google it".

Thank you! :)

if you want to loop through the records use cursor

Are you trying in C or MSSQL?

I use MS SQL.

If I use cursor how it will recognize the end of the rows?
@@fetch=0?

Thanks

这篇关于阅读下一行的表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！