I've tried to use AdoDB with ignite ODBC driver.
Connect passed fine.
Insert operator for City passed fine
Select * from City does not return Recordsed. Formally Fields properties are
filled fine but EOF BOF = True.
If I try GetRows the error happen
"Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record."
I've tried different values for RecordSet.CursorType,
RecordSet.CursorLocation, but without success.
In Excel I can select this table througth ODBC connect.
Is it possible to use ADODb with Ignite odbc driver for Select?
Hi I use SQL Api
Table configuration was taken from example
CREATE TABLE City (
PRIMARY KEY (ID, CountryCode)
) WITH "template=partitioned, backups=1, affinityKey=CountryCode,
CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City";