Hi James,

Let's start with some definitons. A SELECT *is* a query. What you are asking is, "Just using a SELECT statement instead of calling a Stored Procedure"

In theory, a Stored Procedure will be precompiled and run faster than issuing a SELECT statement. If you're going to run it over and over, you may notice a difference. If run on ocassion, it really won't matter much for a query as simple as the one you have.


>I have code that logs into a server and database and runs a SP from that database, but what would I have to take out if I just wanted to select fields from the same database instead?
>
>

FUNCTION r214input
>THESQLDB = "TBL_BL"	
>THESQLTABLE = "TBL_BOL"
>THESERVER = goWCServer.oConfig.oTask.cSQLServer
>usr = 
>pas = 
>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,;
>	appt_date,;
>	latest_status_description,;
>	latest_reason_description,;
>	date_last_updated;
>	FROM sq;
>	INTO CURSOR TQuery
>	SELECT TQuery
>	SET CENTURY ON 
>	recs=RECCOUNT()

>
>Would I just replace what is already in CMD with the select statement?