SPT equiv of RECNO in SQL Server & use no. in the tempta

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SPT equiv of RECNO in SQL Server & use no. in the tempta

Message

From

20/09/2006 08:41:05

Bhavbhuti Nathwani
Venus Software Operations
Rajkot, India

20/09/2006 08:33:01

Borislav Borissov
Microcomplex
Sofia, Bulgaria

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: SPT equiv of RECNO in SQL Server & use no. in the tempta

Environment versions

Visual FoxPro:

VFP 8 SP1

Database:

MS SQL Server

Miscellaneous

Thread ID:

01155452

Message ID:

01155473

Views:

Hi Borislav

>How you create Temp table?

My favourite way is as follows:

	=SQLEXEC(lnSQLHandle, "DROP TABLE #outcome", "outcome")
	TEXT TO lcSQL NOSHOW TEXTMERGE
		SELECT ...
		   INTO #outcome
		   FROM ...
		   WHERE ...
	ENDTEXT
	=SQLEXEC(lnSQLHandle, lcSQL, "outcome")

Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________

Map

View

Click here to load this message in the networking platform