Hi,

Sorry I don't know what you want to do. What you marked as "query" is not
just one query, but a list of statements. And I don't know how this is
related to the update count.

Maybe you want to use a user defined function? If yes see the documentation
there.

Regards,
Thomas


On Thu, Oct 9, 2014 at 8:35 AM, Omer Seyithan <[email protected]> wrote:

> This is query;
>
> ------------------ query ------------------
> ------------------ query ------------------
>
> SET @StartDateTime = $StartDateTime;
>
> SET @RecordCount = (SELECT COUNT(*) FROM WindowTitle WHERE SyncID IS NULL);
>
> INSERT INTO SyncLog
> (
>  EntityType
> ,StartDateTime
> ,RecordCount
> )
> SELECT
>  'WT'
> ,@StartDateTime
> ,@RecordCount
> WHERE @RecordCount > 0;
>
> SET @MaxID = (SELECT ID FROM SyncLog WHERE EntityType = 'WT' AND
> EndDateTime IS NULL LIMIT 1);
>
> UPDATE WindowTitle AS it
> SET SyncID = @MaxID
> WHERE it.GUID IN (
> SELECT GUID
> FROM WindowTitle
> WHERE   SyncID IS NULL
> ORDER BY DateCreated ASC
> LIMIT 100
> )
> AND @RecordCount > 0;
>
> SELECT IFNULL(@MaxID, -1) AS MaxID;
> ------------------ query ------------------
> ------------------ query ------------------
>
> I want to get result set on JAVA side. But, when I am trying that, it's
> giving no result (as null)
> But, if I tries as just a SELECT query like; "SELECT * FROM WindowTitle"
> it's happening.
> How can I get any result after the updates or Insert queries.
>
> -- some updates
> -- some Inserts
> -- just a select query (end of the script)
>
> Please help me :))
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

Reply via email to