get-next-row

Arguments: &key db ignore

The db, which defaults to the value of *mysql* must be a mysql object such as returned by connect. This function returns a list of items in the next row. It returns nil if there are no rows left.

If ignore is specified true (it defaults to nil), then t is returned rather than a list of items if there is an unread row. If you have gotten all you wanted out of a query but haven't reached the end of the result set (i.e get-next-row hasn't returned nil yet) then you still must continue to call get-next-row until get-next-row returns nil (this keeps your client code in sync with the MySQL server). If you are just calling get-next-row until it returns nil then passing the argument :ignore t will tell get-next-row to not bother decoding the items in this row, which will save you some time and reduce consing.

See mysql.htm for information on the Allegro MySQL facility.

Copyright (c) 1998-2019, Franz Inc. Oakland, CA., USA. All rights reserved.
This page was not revised from the 8.2 page.
Created 2012.5.30.