mORMot Open Source

wangchong

Member

Registered: 2011-08-15

Posts: 42

How do I access Data using only the forward cursor

I tried the following code but it ran out of memory

SQL := 'SELECT ID,HTML FROM TenderData ';
  Tbl :=FDB.ExecuteList([TTenderData],SQL);

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,240

Website

Re: How do I access Data using only the forward cursor

There is no cursor.
Use paging.
Search the forum first - and you will find e.g. https://synopse.info/forum/viewtopic.ph … 584#p27584