× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
SachinPrakash reported 2013-01-21T20:02:06Z  · last modified 2013-02-04T18:32:09Z

Return line # & position when syntax error is returned by Informix


customer request
Dev
Jenny Nishimura
JennyNishimura
QA
Priority Minor
Complexity Unknown
Component Q Analyzer
Version 12.0

I think this is possible to do. Look at: http://www.cursor-distribution.de/aktuell.11.70.xC6/documentation/ids_jdbc_bookmap.pdf and search for "syntax error". 

We need to use (IfmxConnection conn).getSQLStatementOffset() ). This will return us the cursor position but no the line #. We'll then have parse the submitted sql to determine the line # & the location w/ in the line # where the error occurred. We do this for Oracle: OracleExceptions.getErrorLineNumber

 

Issue #8222

Closed
Fixed
Resolved 2013-01-21T23:56:27Z
 
 
Completion
No due date
Fixed Build 31025
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017