***************************
***************************
Happy Diwali & Prosperous New Year
***************************
***************************
> > 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
> you can get vfp to do that for you with
>
> errcd=sqlexec(yourhandle,'insert into yourtable (yourcolumn) values (?yourcursor.yourfield)')
>
> the ? makes vfp do the replacing in the sql statement.
>
> if you want to create the string yourself, you have to escape the quotes with a backslash.
>
>
> regards
> tushar
-----------------------------------
Rajesh Halyal