Correct way to loop through all entries of a database resource?

[zw]

Been having reading through the tutorials and the forum for 1-2 hours now, but I just don't understand what's the proper way to work with databases. Unfortunately the wiki lacks information on how to work with databases.

How do I loop through databases?

How do I update records? Is there a way to run select and update statements like with normal SQL DBs?

Any help is appreciated!

[zw]

Btw, I figured how to use the parse line function to read the first entry from the DB, but I don't know how to proceed to the next entry.

Tutorial 3 which is about databases doesn't explain how to loop through all the lines, it only uses parse line and that's it (which doesn't work for me).

[andy231]

You just need to put that parse line in loop or at thread start and untick resuse resource so it will take new resource everytime you execute it.

[zw]

Thanks @andy231, going to give this a try.

[ruzne]

@andy231 said in Correct way to loop through all entries of a database resource?:

линию в цикле или на запуск потока и отключить ресурс повторного использования, чтобы каждый раз, когд

How about limiting the number of elements in the resource?