Correct, slip of the fingers, I do know that a SELECT is a type of query.
Is that would I would do though, remove what's in the CMD and put the SELECT in there instead of below? I'll probably put it in a stored procedure later, but for now I just want to test the code and get that part working since I have a harder time with VFP than I do with SQL.
>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")
>>
>>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?