Logo SQLinForm

 

Problems pasting into SQL Input window

Problems pasting into SQL Input window
March 13, 2017 06:40PM
Hello,
Sometimes with large blocks of SQL there are problems pasting into the SQL input window. Sometimes a middle part of the SQL will appear again at the end and sometimes I just get garbage characters at the end. In either case nothing appears in the SQL Output window.
I have the latest JRE and SQLInform engine release 5.1.31 and SQLInform GUI release 5.1.27. One example that I cannot get to work is as follows:

SELECT TableName, s_GUID, CenterID,BCertMatchStatus,BCertMatchDate,DuplicateOf,BCERTNO,CLNAME,CFNAME,CMNAME,CSUFFIX,CPLNAME,CPFNAME,CPMNAME,CPNICK,CPTITLE,CADOPTED,CDOB,MRaceNS,CSEX,COUTCOME,StillbirthTiming,FetalMaceration,CPLURALITY,CLADDATE,COMMENT,BIRTHHOSP,BOH,BWT,BLGTH,BHEAD,BCMULT,BCMULTMD,BCYTOGENE,BCYTORESULTS,BSSN,BMEDR,BDIE,DOD,DAUTOPSY,DOA,FDCERTNO,OAUTOPRESULT,DRESULTPEND,DRESULTUNCON,MFNAME,MLNAME,MMNAME,MMAIDEN,MNICK,MOCCUPA,MEMPLR,MWPHONE,MDOB,MAGE,MLANGUAGE,MLANGOTHER,MSSN,MPHONE,MAPHONE,MFCARE,MINTERPN,MINTERPPH,MINTERPREL,MEMAIL,FFNAME,FLNAME,FMNAME,FTITLE,FNICK,FEMPLR,FWPHONE,FDOB,FAGE,FRaceNS,FLANGUAGE,FLANGOTHER,FSSN,FPHONE,FAPHONE,FMCARE,FOCCUPA,FINTERPN,FINTERPPH,FINTERPREL,HLMP,HEDDSource,HEDD,HULTRAS,HUSDATEWKS,HUSDATEDAYS,HGSTATUS,HGAGE,HGAGEUNIT,HGAGESOURCE,HGASMULTI,HFAMHIST,H1STDEGREE,H1STFAMVBDX,H2NDDEGREE,H2NDFAMVBDX,HOTHDEGREE,HOTHFAMVBDX,HTERM,HPREM,HUNKLIVE,HSPABORT,HINDAB,HSTILBORN,HUNKABORT,HMULTIBIRTH,HCONGANOM,DateEntered,DateUpdated,CLNameSdx,CFNameSdx,CmNameSdx,DComme
nts,DCERTNO,DCLINKAGE,DCAUSE,DCSOURSE,FDCSOURCE,FDCCAUSE,NDInexLink,SkipBirthUpdate,AllStudyIneligible,NoMajorDefects,Gen_COMMENT,Gen_DComments,Gen_OAUTOPRESULT,s_ColLineage,s_Generation,s_GUID,s_Lineage FROM (SELECT "tblPatient_Conflict" AS TableName, MSysConflicts.s_GUID, CenterID,BCertMatchStatus,BCertMatchDate,DuplicateOf,BCERTNO,CLNAME,CFNAME,CMNAME,CSUFFIX,CPLNAME,CPFNAME,CPMNAME,CPNICK,CPTITLE,CADOPTED,CDOB,MRaceNS,CSEX,COUTCOME,StillbirthTiming,FetalMaceration,CPLURALITY,CLADDATE,COMMENT,BIRTHHOSP,BOH,BWT,BLGTH,BHEAD,BCMULT,BCMULTMD,BCYTOGENE,BCYTORESULTS,BSSN,BMEDR,BDIE,DOD,DAUTOPSY,DOA,FDCERTNO,OAUTOPRESULT,DRESULTPEND,DRESULTUNCON,MFNAME,MLNAME,MMNAME,MMAIDEN,MNICK,MOCCUPA,MEMPLR,MWPHONE,MDOB,MAGE,MLANGUAGE,MLANGOTHER,MSSN,MPHONE,MAPHONE,MFCARE,MINTERPN,MINTERPPH,MINTERPREL,MEMAIL,FFNAME,FLNAME,FMNAME,FTITLE,FNICK,FEMPLR,FWPHONE,FDOB,FAGE,FRaceNS,FLANGUAGE,FLANGOTHER,FSSN,FPHONE,FAPHONE,FMCARE,FOCCUPA,FINTERPN,FINTERPPH,FINTERPREL,HLMP,HEDDSource,HEDD,HULTRAS,HUSDATEWKS,HUSDATEDAYS,HGSTATUS,HGAGE,
HGAGEUNIT,HGAGESOURCE,HGASMULTI,HFAMHIST,H1STDEGREE,H1STFAMVBDX,H2NDDEGREE,H2NDFAMVBDX,HOTHDEGREE,HOTHFAMVBDX,HTERM,HPREM,HUNKLIVE,HSPABORT,HINDAB,HSTILBORN,HUNKABORT,HMULTIBIRTH,HCONGANOM,DateEntered,DateUpdated,CLNameSdx,CFNameSdx,CmNameSdx,DComments,DCERTNO,DCLINKAGE,DCAUSE,DCSOURSE,FDCSOURCE,FDCCAUSE,NDInexLink,SkipBirthUpdate,AllStudyIneligible,NoMajorDefects,Gen_COMMENT,Gen_DComments,Gen_OAUTOPRESULT,s_ColLineage,s_Generation,s_GUID,s_Lineage FROM MSysConflicts INNER JOIN tblPatient_Conflict ON MSysConflicts.s_GUID = tblPatient_Conflict.ConflictRowGuid UNION ALL SELECT "tblPatient" AS TableName, MSysConflicts.s_GUID, CenterID,BCertMatchStatus,BCertMatchDate,DuplicateOf,BCERTNO,CLNAME,CFNAME,CMNAME,CSUFFIX,CPLNAME,CPFNAME,CPMNAME,CPNICK,CPTITLE,CADOPTED,CDOB,MRaceNS,CSEX,COUTCOME,StillbirthTiming,FetalMaceration,CPLURALITY,CLADDATE,COMMENT,BIRTHHOSP,BOH,BWT,BLGTH,BHEAD,BCMULT,BCMULTMD,BCYTOGENE,BCYTORESULTS,BSSN,BMEDR,BDIE,DOD,DAUTOPSY,DOA,FDCERTNO,OAUTOPRESULT,DRESULTPEND,DRESULTUNCON,MFNAME,MLNAME,MMN
AME,MMAIDEN,MNICK,MOCCUPA,MEMPLR,MWPHONE,MDOB,MAGE,MLANGUAGE,MLANGOTHER,MSSN,MPHONE,MAPHONE,MFCARE,MINTERPN,MINTERPPH,MINTERPREL,MEMAIL,FFNAME,FLNAME,FMNAME,FTITLE,FNICK,FEMPLR,FWPHONE,FDOB,FAGE,FRaceNS,FLANGUAGE,FLANGOTHER,FSSN,FPHONE,FAPHONE,FMCARE,FOCCUPA,FINTERPN,FINTERPPH,FINTERPREL,HLMP,HEDDSource,HEDD,HULTRAS,HUSDATEWKS,HUSDATEDAYS,HGSTATUS,HGAGE,HGAGEUNIT,HGAGESOURCE,HGASMULTI,HFAMHIST,H1STDEGREE,H1STFAMVBDX,H2NDDEGREE,H2NDFAMVBDX,HOTHDEGREE,HOTHFAMVBDX,HTERM,HPREM,HUNKLIVE,HSPABORT,HINDAB,HSTILBORN,HUNKABORT,HMULTIBIRTH,HCONGANOM,DateEntered,DateUpdated,CLNameSdx,CFNameSdx,CmNameSdx,DComments,DCERTNO,DCLINKAGE,DCAUSE,DCSOURSE,FDCSOURCE,FDCCAUSE,NDInexLink,SkipBirthUpdate,AllStudyIneligible,NoMajorDefects,Gen_COMMENT,Gen_DComments,Gen_OAUTOPRESULT,s_ColLineage,s_Generation,s_GUID,s_Lineage FROM MSysConflicts INNER JOIN tblPatient ON tblPatient.s_GUID = MSysConflicts.WinningRowGuid) AS Q
Re: Problems pasting into SQL Input window
March 13, 2017 09:52PM
Hi bbhulsey,
thanks for your feedback. I tried to format your SQL and it worked on my side. Could you please store your profile settings and send them (file name = sqlinformx.cfg in folder sqlinform_userdata) to info at sqlinform dot com. Maybe there is an issue with one specific option.

Thanks for your help
Guido
Author:

Your Email (Optional):


Subject:


Spam prevention:
Please, solve the mathematical question and enter the answer in the input field below. This is for blocking bots that try to post this form automatically.
Question: how much is 20 plus 1?
Message: