If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with pass-through insert query
I am trying to run this pass-through insert query but
everytime I try I keep getting ODBC connection Failed and then when I click OK I get an Oracle error "Keyword VALUES missing" Here is the query INSERT INTO PSTRN.Sysadm.PS_KM_Health_Quest (National_ID, DATETESTED, PROFCODE, HEAD508, PRINTER, N001, DATESCANNED, FORMCODE, MR_STUFF, FORMNO, FORMNAME, SIGNATURE, X001, X002, X003, X004, X005, X006, X007, X008, X009, X010, X011, X012, X013, X014, X015, X016, X017, X018, X019, X020, X021, X022, X023, X024, X025, X026, X027, X028, X029, X030, X031, X032, X033, X034, X035, X036, X037, X038, X039, X040, X041, X042, X043, X044, X045, X046, X047, X048, X049, X050, X051, X052, X053, X054, X055, X056, X057, X058, X059, X060, X061, X062, X063, X064, X065, X066, X067, X068, X069, X070, X071, X072, X073, X074, X075, X075, X076, X077, X078, X079, X080, X081, X082, X083, X084, X085, X086, X087, X088, X089, X090, X091, X092, X093, X094, X095, X096, X097, X098, X099, X100, X101, X102, X103, X104, X105, X106, X107, X108, X109, X110, X111, X112, X113, X114, X115, X116, X117, X118, X119, X120, X121, X122, X123, X124, X125, X126, X127, X128, X129, X130, X131, X132, X133, X134, X135, X136, X137, X138, X139, X140, X141, X142, X143, X144, X145, X146, X147, X148, X149, X150, X151, X152, X153, X154, X155, X156, X157, X158, X159, X160, X161, X162, X163A, X163B, X164A, X164B,X165, X166, X167, COMMENTS_200) Select SSNO,DATETESTED, PROFCODE, HEAD508, PRINTER, N001, DATESCANNED, FORMCODE, STUFF, FORMNO, FORMNAME, SIGNATURE, X001, X002, X003, X004, X005, X006, X007, X008, X009, X010, X011, X012, X013, X014, X015, X016, X017, X018, X019, X020, X021, X022, X023, X024, X025, X026, X027, X028, X029, X030, X031, X032, X033, X034, X035, X036, X037, X038, X039, X040, X041, X042, X043, X044, X045, X046, X047, X048, X049, X050, X051, X052, X053, X054, X055, X056, X057, X058, X059, X060, X061, X062, X063, X064, X065, X066, X067, X068, X069, X070, X071, X072, X073, X074, X075, X075, X076, X077, X078, X079, X080, X081, X082, X083, X084, X085, X086, X087, X088, X089, X090, X091, X092, X093, X094, X095, X096, X097, X098, X099, X100, X101, X102, X103, X104, X105, X106, X107, X108, X109, X110, X111, X112, X113, X114, X115, X116, X117, X118, X119, X120, X121, X122, X123, X124, X125, X126, X127, X128, X129, X130, X131, X132, X133, X134, X135, X136, X137, X138, X139, X140, X141, X142, X143, X144, X145, X146, X147, X148, X149, X150, X151, X152, X153, X154, X155, X156, X157, X158, X159, X160, X161, X162, X163A, X163B, X164A, X164B,X165, X166, X167, COMMENTS FROM [Health Questions] Any ideas? Thanks. |
Thread Tools | |
Display Modes | |
|
|