Er ging iets niet goed
- Melding:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
- Details: SELECT TOP 80
ih.id AS tweakid,
r.item_id,
r.dbobjectid,
r.coltype,
r.fieldname,
COALESCE(ih.headertitle, br.headertitle) AS headertitle,
r.placeholder,
r.explanation,
r.divclass,
br.boo_samerowasprevious,
r.unitofmeasureid,
r.addroleid,
r.message,
r.triggerfield,
r.displaytype,
r.optionsource,
r.filtercondition,
r.optionorderby,
r.optionsobjectid,
r.optionsbasetable,
ISNULL('(' + ob.strsource + ') src', ob.base_table) as optionstable,
ISNULL(ob.keyfield,'item_id') AS optionskeyfield,
ISNULL(ob.labelfield,'naam') AS optionslabelfield, obd.connectstring as optionsconnectstring,
COALESCE(ih.boo_required, r.boo_required) AS boo_required,
br.boo_unique,
br.boo_hideduplicates as boo_hideduplicates,
r.boo_autopostback,
r.boo_hastriggers,
r.boo_showemptyspan,
r.boo_showtotal,
r.minvalue,
r.maxvalue,
r.textrows,
r.width,
r.colwidth,
r.maxlength,
r.inputmask,
r.validationscript,
COALESCE(ih.defaultvalue, r.defaultvalue) AS defaultvalue,
br.editroleid AS editroleid,
r.expression,
r.microtemplate,
r.decimals,
r.autofill,
r.align,
r.comment,
r.htmlafter,
r.optionsxml,
r.gridspecialsql,
r.grid_coltype,
r.grid_headeroption,
r.grid_colwidth,
r.syncmethod,
r.viewid,
r.viewid_target,
r.viewfilter,
r.boo_lockedforedit,
r.boo_hidden,
r.boo_autosave,
r.boo_htmlencode,
r.boo_newrow,
r.slider_precision,
r.tofieldid,
r.boo_showdefault,
r.fieldname AS fieldname_org,
ISNULL(r.expression + ' AS ' + fieldname,'[' + fieldname + ']') AS field,
ISNULL(r.expression,'[' + fieldname + ']') AS fieldexpression,
COALESCE(ih.label, br.label, r.naamnl, r.naam, r.fieldname, '') as label,
ISNULL(divclass + ' ','') + ISNULL(coltype,'') AS cls,
s.connectstring AS optionsdbsource, o.base_table,
isnull(bo.keyfield,'item_id') as keyfield, isnull(bo.labelfield,'naam') as labelfield,
CASE WHEN o.basedbobjectid > 0 THEN bo.base_table ELSE o.base_table END AS roottable, s.connectstring,
u.expression AS formatExpression,
bo.fieldnamedatelocked, br.boo_showspan, br.id as brruleid
FROM dbrules r WITH(nolock)
INNER JOIN dbobject o WITH(nolock) ON r.dbobjectid = o.item_id
INNER JOIN dbobject bo WITH(nolock) ON o.basedbobjectid = bo.item_id
INNER JOIN dbdatastore s WITH(nolock) ON o.dbdatastore_item_id = s.item_id
INNER JOIN unitofmeasure u WITH(nolock) ON r.unitofmeasureID = u.ID
INNER JOIN dbobject ob WITH(nolock) ON r.optionsobjectid = ob.item_id
INNER JOIN dbdatastore obd WITH(nolock) ON ob.dbdatastore_item_id = obd.item_id INNER JOIN briteviews_dbrules br WITH(nolock) ON r.item_id = br.label_id AND br.item_id = @param1 AND (br.viewroleid IS NULL OR br.viewroleid = 0 OR SUBSTRING(@param2, isnull(br.viewroleid, 1) * 10 + 1, 1) = '1') LEFT JOIN instance_hidefields ih ON r.item_id = ih.fieldid AND ih.instanceid =1 WHERE (boo_showdefault = 1 AND ISNULL(ih.boo_hide,0) = 0) OR ISNULL(boo_show,0) = 1 ORDER BY br.rank : 2 : Parameters: @param1=i:5056, @param2=10000000001110,
- Technische info: ObjectData
- Template: