>Does the "bug" or "condition" still exist that requires SQL strings longer than 255 characters ( Q163800 ) to be broken up when using SQLEXEC() or was this corrected in one of the SP's?
>
>Thanks,
>Bill

Bill,

I send some really long ones, put together like this:

cSelect = [SELECT * FROM MyTable ]
cWhere = [WHERE SomeField = “Some character value” ] + ;
  [AND SomeOtherCondition = .T. ]
cOrderBy = [ORDER BY Field1, Field2, Field3 ]

cSQLCommandString = cSelect + cWhere + cOrderBy

lWasISuccessful = SQLEXEC(lnHandle, cSQLCommandString, "ResultCursor")