CAPI.Exec / StringLength problem

x-castranuk_-_(deleted)

Hi,Has anyone found a way to CAPI.Exec() an SQL command longer than 255 characters ?! I can build a string with more than 255 in, but when the Exec function gets it, it's only got the first 255........I URGENTLY need a way to execute a 300 char+ statement !!Dave

eLink User

Message from David Slimmon via eLinkHi there,Our support team in Waterloo tried the following script (in which the query was over300 charaters) and it worked for us using Livelink version 8.1.3 with the October1999 monthly patch.---------------------------------CAPIConnect cConnect = CAPI.AllocConnect( CAPI.CT_MSDBLIB, "canyonero", \ "KC813", "KC813", "livelink" )echo( GetNodeData( cConnect, 2000 ) )function Dynamic GetNodeData( CAPIConnect c, Integer nid ) String s = "Select extendeddata,dataid,ownerid,parentid,Upermissions" \ + ",Gpermissions,Wpermissions,Spermissions,CreateDate, PermID" \ + ", CreatedBy, Name, OriginOwnerID, OriginDataID, UserID," \ + " GroupID, ReservedDate, VersionNum, Dcomment, Dcategory," \ + " SubType, ExAtt1, ExAtt2, Ordering, ReleaseRef, Major," \ + " Minor, DateAssigned, DateStarted, Status, Priority, GIF " \ + ", DateExpiration, DateDue, DateCompleted" \ + " from dtree where dataid=:A1" RecArray retval = CAPI.Exec( c, s, nid ) return retval[1].ExtendedDataendHave you opened a customer support ticket on this issue?Regards,Dave______________________________________O P E N T E X T C O R P O R A T I O NOttawa, Ontario Canadahttp://knowledge.opentext.com> -----Original Message-----> From: eLink Discussion: Development Discussion> [mailto:development@elinkkc.opentext.com]> Sent: Thursday, December 02, 1999 5:59 AM> To: eLink Recipient> Subject: CAPI.Exec / StringLength problem>>> CAPI.Exec / StringLength problem> Posted by CasTranUK on 12/02/1999 05:49 AM>> Hi,>> Has anyone found a way to CAPI.Exec() an SQL command longer than 255> characters ?! I can build a string with more than 255 in, but when the> Exec function gets it, it's only got the first 255........>> I URGENTLY need a way to execute a 300 char+ statement !!>> Dave>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Discussion: Development Discussion> http://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=viewLivelink Server:http://knowledge.opentext.com/knowledge/livelink.exe