Strange Chars in Column Names

[TerryKellum]

I'm trying to import data over ODBC from a Simba ODBC Driver from a Raima database hosted

on an AIX box.

Our systems vendor failed to consider the possibility way back when they developed their schema,

that it might be a bad idea to use “special characters” in their column names.

After all, they could save 3 bytes on each column! 😮

So…. Here's the calling card that they've left on my lawn…..

SQLyog 640-748 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)

SQLSMALLINT 3

SQLHANDLE 00C61700

SQLHANDLE * 0x0012DE70 ( 0x00c61d78)

SQLyog 640-748 ENTER SQLExecDirect

HSTMT 00C61D78

UCHAR * 0x01AAE950 [ -3] “select AA_ID, PAT_PLAB, Billing#, MR#, Clinic, Room, Bed, Doctor, Admission_Date, Discharge_Date, Diagnosis1, Diagnosis2, Diagnosis3, NotUsed1, NotUsed2, NotUsed3, NotUsed4, NotUsed5, NotUsed6, NotUsed7, NotUsed8, Emergency, Disability, Family_Plan, Verify, PLFLAG1, F_rpt, R_rpt, Active, T_rpt, 7_rpt, D_rpt, Accident_Code, Total_Charges, Total_Payments, Patient_Bal, UnUsed1, UnUsed2, UnUsed3, UnUsed4, UnUsed5, UnUsed6, UnUsed7, UnUsed8, UnUsed9, UnUsed10, UnUsed11, UnUsed12, UnUsed13, UnUsed14, UnUsed15, UnUsed16, UnUsed17, UnUsed18, UnUsed19, UnUsed20, UnUsed21, UnUsed22, UnUsed23, UnUsed24, Admit, Dischrg, Outpat, Result_Chng, Disch_Rep_Prt, Admission_Time, Discharge_Time, Admitting_Doctor, Consulting_Doctor, PLFILLUP from Stays 0”

SDWORD -3

SQLyog 640-748 EXIT SQLExecDirect with return code -1 (SQL_ERROR)

HSTMT 00C61D78

UCHAR * 0x01AAE950 [ -3] “select AA_ID, PAT_PLAB, Billing#, MR#, Clinic, Room, Bed, Doctor, Admission_Date, Discharge_Date, Diagnosis1, Diagnosis2, Diagnosis3, NotUsed1, NotUsed2, NotUsed3, NotUsed4, NotUsed5, NotUsed6, NotUsed7, NotUsed8, Emergency, Disability, Family_Plan, Verify, PLFLAG1, F_rpt, R_rpt, Active, T_rpt, 7_rpt, D_rpt, Accident_Code, Total_Charges, Total_Payments, Patient_Bal, UnUsed1, UnUsed2, UnUsed3, UnUsed4, UnUsed5, UnUsed6, UnUsed7, UnUsed8, UnUsed9, UnUsed10, UnUsed11, UnUsed12, UnUsed13, UnUsed14, UnUsed15, UnUsed16, UnUsed17, UnUsed18, UnUsed19, UnUsed20, UnUsed21, UnUsed22, UnUsed23, UnUsed24, Admit, Dischrg, Outpat, Result_Chng, Disch_Rep_Prt, Admission_Time, Discharge_Time, Admitting_Doctor, Consulting_Doctor, PLFILLUP from Stays 0”

SDWORD -3

DIAG [37000] [Simba][SimbaEngine ODBC Driver]select AA_ID, PAT_PLAB, Billing<< ??? >>#, MR#, Clinic, Room, Bed, Doctor, Admission_Date, Discharge_Date, Diagnosis1, Diagnosis2, Diagnosis3, NotUsed1, NotUsed2, NotUsed3, NotUsed4, NotUsed5, NotUsed6, NotUsed7, NotUsed8, (0)

DIAG [37000] [SimbaLNA][Simba][SimbaEngine ODBC Driver]Syntax Error. (0)

As you can see… Not a happy place…

I would like to suggest that column names be quoted in the query. This should serve to make them more “bulletproof”.

This is a workaround that we use in other applications… 'Twould be great if SQLyog would try this in the next release.

Maybe have a checkbox for “Quoted Columns” ?????

Thanks for a wonderfull tool. I've noticed a few small glitches here and there, and I'll try and document them as I have opportunity.

[Ritesh]

Hmmmmmmm…..Thanks for the information.

Quote:

I've noticed a few small glitches here and there

Waiting for the list 🙄

[Author]

Posts