GOLF(2gg)

🌸 GOLF(2gg) — the current-row page, bestie edition 🌸

okay so this is a page from the 2gg manual (yep, that's the manual name, and it lives in the Development section), and it's about a little cutie called current-row. let's get into it 💖

---

✨ NAME ✨

current-row — a database thing 🗄️💅

---

🎀 PURPOSE 🎀

bestie, this is how you get the row number of the current row inside a query's result-set, or print it out. that's the whole job. iconic behavior honestly 🫶

---

🌈 SYNTAX 🌈

current-row [ to <current row> ]

like, that's it. that's the whole thing. no cap ✨

---

💖 DESCRIPTION 💖

If you call current-row without the to clause, it just prints out the current row number. and the first row is numbered 1 — so it's 1-indexed, we love a girl who starts at 1 💅

If you do use the to clause, then the row number gets stored into the variable <current row> instead. like, you're catching it and keeping it 🎀

⚠️ important one, bestie: current-row must be within a run-query loop, and it always refers to the most inner one. so if you've got loops inside loops inside loops, she's only ever talking about the innermost one. periodt. 🙈

---

🌸 EXAMPLES 🌸

okay so here's the vibe — displaying the row number right before a line that has the first and last name of each employee 🧚✨

run-query @mydb="select firstName, lastName from employee" output firstName, lastName
    @Row #<<current-row>><br/>
    print-out firstName
    @,
    print-out lastName
    @<br/>
end-query

look at her go. the row number, then the name, every single time. ate. 👑

---

🔥 SEE ALSO 🔥

Database — and literally all of these besties:

• begin-transaction
• commit-transaction
• current-row
• database-config-file
• db-error
• mariadb-database
• postgresql-database
• rollback-transaction
• run-query
• sqlite-database

and hey — See all documentation if you want the whole tour 🌈💜

---

and that's the page!! this version was dated $DATE and tagged $VERSION, and yeah, it's still GOLF(2gg) at the end of the day 🦋 mwah, go run some queries bestie 💖✨