Special Characters in EQuIS LogPlot Interface

When exporting data to LogPlot, the default filename for the *.DAT file will be the SYS_LOC_CODE selected from the Location tab in the EQuIS for LogPlot Interface. If a SYS_LOC_CODE contains a special character such as the forward slash "/", backward slash "\", pipe "|", or double quote " " " upon Export, the EQuIS LogPlot Interface will update any SYS_LOC_CODE containing those special characters with an underscore, '_' in the file path, e.g., a SYS_LOC_CODE of MW-14/01 will be saved as MW-74_01.dat in the My EQuIS Work folder by default.

However, using a single quote in the SYS_LOC_CODE may result in an error message like the following when selecting the location in the EQuIS LogPlot Interface. Other special characters that should be used with caution are:

: * ? < >

For more on special character use within EQuIS, see Special Characters in the EQuIS Database.

Incorrect syntax near '98'.

Unclosed quotation mark after the character string ' ORDER BY sys_loc_code,star

Incorrect syntax near '98'.

Unclosed quotation mark after the character string ' ORDER BY sys_loc_code,start_depth'.

at EarthSoft.Common.Data.Connection.Fill(DataSet ds, String tableName, IDbCommand Command)

at EarthSoft.Interfaces.LogPlot.LogPlotUI.PopulateSampleData()

at EarthSoft.Interfaces.LogPlot.LogPlotUI.grdLocation_AfterSelectrow(Object sender, AfterSelectChangeEventArgs e)

at Infragistics.Win.UltraWinGrid.AfterSelectChangeEventHandler.Invoke(Object sender, AfterSelectChangeEventArgs e)

at Infragistics.Win.UltraWinGrid.UltraGrid.OnAfterSelectChange(AfterSelectChangeEventArgs e)

at Infragistics.Win.UltraWinGrid.UltraGrid.FireEvent(GridEventIds id, EventArgs e)

at Infragistics.Win.UltraWinGrid.UltraGrid.SelectNewSelection(Type type, Selected selected)

at Infragistics.Win.UltraWinGrid.UltraGrid.InternalSelectItem(ISelectableItem item, Boolean clearExistingSelection, Boolean select)

at Infragistics.Win.SelectionStrategyExtended.OnMouseDown(ISelectableItem item, MouseMessageInfo& msginfo, Boolean forceDrag)

at Infragistics.Win.ControlUIElementBase.ProcessMouseDownHelper(Object sender, MouseEventArgs e)

at Infragistics.Win.ControlUIElementBase.ProcessMouseDown(Object sender, MouseEventArgs e)

at Infragistics.Win.Utilities.ProcessEvent(Control control, ProcessEvent eventToProcess, EventArgs e)

at Infragistics.Win.UltraWinGrid.UltraGrid.OnMouseDown(MouseEventArgs e)

at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)