>I've got a SQLEXEC command I'm trying to run, but I get an ODBC error saying The identifier that starts with "Insert into CQIPatient....is too long. Maximum length is 128.
>
>Below is the code:
>
>* Build lcSQL
>lcSQL=["INSERT INTO CQIPatient ]
>lcSQL=lcSQL+[(FacilityID,DeptID,patnumber,lastname,firstname,ssn,room,sex,dob,age) values ]
>lcSQL=lcSQL+[(?gnFacilityID,?gnDeptID,?gcPatientNumber,?thisform.frmlastname,?thisform.firstname, ?thisform.frmssn,?thisform.frmroom,?thisform.frmsex,?thisform.frmAge)"]
>* Exec the SQL Command
>= SQLEXEC(gnConnHandle, lcSQL)
>
>I was afraid that I would have to keep it under 256, but 128 seems really limiting. Is there a better way or a setting I need to make? Thanks for any help
>
>Kirk
Kirk,
Take out double quotation marks.
* Build lcSQL
lcSQL=[INSERT INTO CQIPatient ]
lcSQL=lcSQL+[(FacilityID,DeptID,patnumber,lastname,firstname,ssn,room,sex,dob,age) values ]
lcSQL=lcSQL+[(?gnFacilityID,?gnDeptID,?gcPatientNumber,?thisform.frmlastname,?thisform.firstname, ?thisform.frmssn,?thisform.frmroom,?thisform.frmsex,?thisform.frmAge)]
--sb--