HOW TO CREATE A STRING OF VALUES THAT CAN BE USED TO INSERT IN SQL SERVER

From: Rajesh Halyal


	SANGLI India
	Rajesh Halyal

Subject:	how to create a string of values that can be used to insert in SQL server
Thread ID:	110551	Message ID:	110551	# Views:	1	# Ratings:	0
Version:	Visual FoxPro 6		Category:	Databases, Tables and SQL Server
Date:	Friday, October 20, 2006 5:32:29 AM

I am trying to create a string depending on the cursor fields & its
type to be used to pass it to insert command for SQL server.
I am having 2 problems
1> How to include character fields with quotes, square brackets & other
special characters.
2> How to send date fields.
-----------------------------------
Rajesh Halyal

ENTIRE THREAD

how to create a string of values that can be used to insert in SQL server Posted by Rajesh Halyal @ 10/20/2006 5:32:29 AM

RE: how to create a string of values that can be used to insert in SQL server Posted by tushar @ 10/20/2006 6:43:35 AM

RE: how to create a string of values that can be used to insert in SQL server Posted by Rajesh Halyal @ 10/21/2006 4:42:24 AM

RE: how to create a string of values that can be used to insert in SQL server Posted by tushar @ 10/21/2006 8:11:17 AM

RE: how to create a string of values that can be used to insert in SQL server Posted by Pete Sass @ 10/20/2006 2:14:26 PM

RE: how to create a string of values that can be used to insert in SQL server Posted by Ken Murphy @ 10/20/2006 2:24:07 PM

RE: how to create a string of values that can be used to insert in SQL server Posted by Pete Sass @ 10/20/2006 5:19:55 PM

RE: how to create a string of values that can be used to insert in SQL server Posted by Ken Murphy @ 10/20/2006 5:28:18 PM

RE: how to create a string of values that can be used to insert in SQL server Posted by Rajesh Halyal @ 10/21/2006 4:39:39 AM

RE: how to create a string of values that can be used to insert in SQL server Posted by Ken Murphy @ 10/20/2006 2:21:25 PM