|
Home > Archive > FoxPro Help and Support > January 2006 > how to update an sql server table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to update an sql server table
|
|
|
| I would like to update and add a couple of 100s of records on an sql server
table.
whats the easiest way of doing this using SQL Pass through and VFP?
(i've not done this before).
| |
| Jack Jackson 2006-01-16, 3:24 am |
| On Mon, 16 Jan 2006 10:34:54 +1100, "Nikki" <castelo@geo.un> wrote:
>I would like to update and add a couple of 100s of records on an sql server
>table.
>whats the easiest way of doing this using SQL Pass through and VFP?
>(i've not done this before).
TEXT TO cSQL TEXTMERGE NOSHOW
INSERT into ....
ENDTEXT
nErr = SQLEXEC(nHandle, cSQL)
Repeat for each insert/update
| |
|
| Just what I feared!
Well, if there isn't another way, so be it.
Thanks.
"Jack Jackson" < jacknospam@pebblerid
ge.com> wrote in message
news:p84ms19q2fr53q3
vl971cb8o9fu9crr40v@
4ax.com...
> On Mon, 16 Jan 2006 10:34:54 +1100, "Nikki" <castelo@geo.un> wrote:
>
>
> TEXT TO cSQL TEXTMERGE NOSHOW
> INSERT into ....
> ENDTEXT
> nErr = SQLEXEC(nHandle, cSQL)
>
> Repeat for each insert/update
>
| |
| Cindy Winegarden 2006-01-17, 3:24 am |
| Hi Nikki,
I assume you've considered appending records to a view?
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"Nikki" <castelo@geo.un> wrote in message
news:uH9MuviGGHA.1388@TK2MSFTNGP11.phx.gbl...
>I would like to update and add a couple of 100s of records on an sql server
>table.
> whats the easiest way of doing this using SQL Pass through and VFP?
> (i've not done this before).
>
| |
| JohnnyCinco 2006-01-18, 1:24 pm |
| I can give you some code I already have to do Customer files.
I also have one for Inventory files.
Let me know if you want the code.
You can always adjust the field names and table names.
Anyway, let me know if you want them or what.
Laters
"Nikki" <castelo@geo.un> wrote in message
news:%231cpEMmGGHA.1032@TK2MSFTNGP12.phx.gbl...
> Just what I feared!
> Well, if there isn't another way, so be it.
>
> Thanks.
>
> "Jack Jackson" < jacknospam@pebblerid
ge.com> wrote in message
> news:p84ms19q2fr53q3
vl971cb8o9fu9crr40v@
4ax.com...
>
>
|
|
|
|
|