Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Just using a SELECT statement instead of running query
Message
From
24/06/2011 15:43:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Just using a SELECT statement instead of running query
Miscellaneous
Thread ID:
01515946
Message ID:
01515946
Views:
142
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?
Next
Reply
Map
View

Click here to load this message in the networking platform