Your cmd is incorrect

cmd = [exec InTransit ?']

It can be

cmd = [exec InTransit ?m.TransitID] && no single quote here, it should use parameter

or if you try to embed the ClientCd field into the cmd, it should be no ?, e.g.

cmd = [exec InTransit '] + ClientCd + [']

>Ok, that brought up another library issue but I fixed that the same way. Now it's just giving me "Syntax error" when i try to run the program, no other information. This is the function it points me to:
>
>

FUNCTION 214Listing
>THESQLDB = "TBL_BL"	
>THESQLTABLE = "TBL_BOL"
>THESERVER = goWCServer.oConfig.oWebProcess.cSQLServer
>usr = "sa"
>pas = "Th1nk@123"
>ConnStr = [driver=SQL Server; server=]+THESERVER+[; database=]+THESQLDB+[; uid=]+usr+[;pwd=]+pas+[; Trusted_Connection=No;]
>curHandle = SQLstringCONNECT( connStr )
>cmd = [exec InTransit ?']
>*+ALLTRIM(user.cclientcd)+[']
>lr = SQLEXEC( curHandle, cmd, "sq")  && sq is the cursor the data is loaded into
>
>SELECT;	
>	client_zip,;
>	bol_number,;
>	ref_num,;
>	weight,;
>	pro_number,;
>	customer_name,;
>	customer_state,;
>	customer_zip,;
>	carrier_name,;
>	ship_date,;
>	est_delivery,;
>	app_date,;
>	latest_status_description,;
>	latest_reason_description,;
>	date_last_updated;
>	FROM sq;
>	INTO CURSOR TQuery
>	SELECT TQuery
>	SET CENTURY ON 
>	recs=RECCOUNT()
>		
>loSC = CREATEOBJECT("wwShowCursor")
>loSC.lCenterTable = .f.
>loSC.cHeaderBGColor = "black"   &&"#336633"
>loSC.lAlternateRows = .T.
>loSC.cAlternatingBGColor = "white"  &&"#EFEFEF"
>loSC.cTableBorder ="3"
>loSC.cTableWidth="750"
>DIMENSION laHeaders[15]
>laHeaders[1] = "Ozp"
>laHeaders[2] = "BOL#"
>laHeaders[3] = "Ref#"
>laHeaders[4] = "Weight"
>laHeaders[5] = "Pro#"
>laHeaders[6] = "Customer Name"
>laHeaders[7] = "Dst"
>laHeaders[8] = "Dzp"
>laHeaders[9] = "Carrier"
>laHeaders[10] = "Ship Date"
>laHeaders[11] = "Est_Delivery"
>laHeaders[12] = "Appt. Date"
>laHeaders[13] = "Latest Status"
>laHeaders[14] = "Latest Reason"
>laHeaders[15] = "Last Updated"
>loSC.BuildFieldListHeader(@laHeaders)
>loSC.lSumNumerics = .t.
>loSC.ShowCursor()
>listingtable=loSC.GetOutput()
>
>Response.ExpandTemplate(goWCServer.oConfig.oWebProcess.cBTSAllTBLPath+"214List.htm")
>ENDFUNC

>
>I am using WestWind so if something is unfamiliar to you that's probably why.
>
>
>>If it's a PRG based class, you need to use
>>
>>SET PROCEDURE to \WConnectX\_FP\WebProcess.prg ADDITIVE
>>
>>>WebProcess is another PRG that wasn't in the folder with the PRG in which the code came from. I dropped it and the FXP file in with the main program and tried to do:
>>>
>>>SET CLASSLIB TO \WConnectX\_FP\WebProcess
>>>
>>>But it's telling me "\WConnectX\_FP\WebProcess.vcx doesn't exist" because it in fact doesn't, there was no VCX where I found the two other files.
>>>
>>>Aside from that I don't see WebProcess mentioned in this code anywhere, at least nothing that defines it.
>>>
>>>Can I get it working without the VCX file?
>>>
>>>
>>>>Where is WebProcess class defined and do you have
>>>>
>>>>SET PROCEDURE TO ProgramWhereThisClassDefined
>>>>
>>>>or
>>>>
>>>>SET CLASSLIB TO ClassLibWhereThisClassIsDefined
>>>>
>>>>statement missing.
>>>>
>>>>>When I try to run my program, I get "Class definition WEBPROCESS is not found."
>>>>>
>>>>>Here are the first few lines of code, the error pops up at loProcess=CREATEOBJECT("task",loServer).
>>>>>
>>>>>

#define DISC_NORMAL 0
>>>>>#define DISC_RATE   1
>>>>>#define _MAXLNS 10
>>>>>#define _MAXWLNS 10
>>>>>#define RATE_UNKNOWN 0
>>>>>#define RATE_PAY 1
>>>>>#define RATE_INV 2
>>>>>#define CHANGETHIS this.fp1521()  &&this.BGMAudit()  &&this.fp1601()
>>>>>*#define TESTING 1
>>>>>LPARAMETERS loServer
>>>>>LOCAL loProcess
>>>>>#include WCONNECT.H
>>>>>#DEFINE TIMEOUT 14400
>>>>>#DEFINE TOL_PATH "D:\BTS\Tolerance\"
>>>>>
>>>>>loProcess=CREATEOBJECT("task",loServer)
>>>>>IF VARTYPE(loProcess)#"O"
>>>>>	WAIT WINDOW NOWAIT "Unable to create Process object..."
>>>>>	RETURN .f.
>>>>>ENDIF 
>>>>>loProcess.Process
>>>>>RETURN 
>>>>>
>>>>>DEFINE CLASS Task as WebProcess

>>>>>
>>>>>After that I start making functions. I'm running a local server to test the pages and all of them come back saying there's a syntax error at line 0, so it's obviously zero help. Any ideas?