.next() problem with resultset

[Jokez]

Hi!

I have a problem using jdbc drivern sljc that comes with Filemaker. Sometimes when I do resultset.next() in java it gives me interan error. Is this a known Issue? Is there a way round it?

Regards

Joakim

[elo]

Can you provide more details on the error?

Also, I've only worked with ODBC through Microsoft's ADO, but are you sure you want to do resultset.next?

A single stream of commands can return multiple RecordSets (ADO parlance) in ADO you use the NextRecordSet method to move to the next RecordSet but the MoveNext method to move to the next record in the same recordset.

My code raises exceptions if I call NextRecordSet when there is only one record set/I've reached the end.

For example, if your SQL code is something like:

DEFINE @var1 integer;

SET @var1 = 99;

SELECT * FROM tTable WHERE column = @var1

That would return multiple record sets. Some of which would have NO records. Only the last of which, the SELECT is interesting to you.

In SQL Server 2005 you can use the SET NOCOUNT ON / SET NOCOUNT OFF in your SQL command text to avoid undesired record sets.

Sorry for using such ADO specific terminology, but my guess from my own experience working with ODBC using the ADO API to work with the returned data is that I'm hopefully pointing you in the right direction.