I think that it may be the size of one of your fields causing the problem, not the size of your sql statement. I've done an INSERT consisting of at least 662 characters. Maybe your trying to put more data in a field than it can handle.

MOnTe


>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