Resultset is empty

[ztminhas]

Hello

this is the first time I have encountered this problem. My base file is on a server share. I open the file (which is mapped to a drive) and run my macro which first deletes the data in the table. This succeeds. I reimport data from oracle. This succeeds. I then try to open this table as a resultset and even a rowset. The resultset is consistently empty despite the fact that there is data. The sql is hard coded. I can run it as a query and even a view and I can view the data from both the query and view. Yet the resultset/rowset is empty.

It is embedded Firebird with LO windows 32 bit paf version 7.4.5 running on windows 11.

Thank you as usual

[RobertG]

An example of your macro code is needed. How do you run through the result by macro?

[ztminhas]

Hello. The problem was in my code. Lesson learned

1. The problem is mostly the programmer
2. when the problem is the programmer small mistakes make big problems

lesson learned