Re: prepared sql statements

Sorry, I know nothing about that API. It doesn't really have much to do
with ADO does it?

kaushal wrote:
sir actually the thing is that i am using "odbc api" which is a part
of vc++ so i have asked it to vc group . i know the syntaz of insert
into statement but when i m using the feature odbc api that is
"prepared sql statements" the problem happens. which already i had
described
so please if u have any solution then tell me.

Bob Barrows [MVP] wrote:
kaushal wrote:
i had made the simple application to insert a single record to
visula foxpro table(assume that table is having only one field)
using prepared statement but now when i have to insert more than
one data each time i have to bind that row and each time i have to
use SQLExecute function, so is it possible to insert multiple data
by just using single time execution of SQLExecute() function if it
is possible then plz help me.

I don't know. It depends on if Foxpro supports batched sql
statements. You might try asking in a foxpro group.

In other databases, you can use a union query to insert multiple
records:

insert into table (col1)
select val1
union all select val2
union all select val3

Again, I don't know if foxpro supports this.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Foxpro index files and their differences
    ... newsgroup with future questions. ... The basic types of indexes in VFP are structural ... > Microsoft FoxPro Technical Support ... >>using the copyto function. ...
    (microsoft.public.fox.helpwanted)
  • vfp8 parameters and variable question
    ... to find "working" newsgroup and/or forum about foxpro (btw, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Infos für Newsgroup-Teilnehmer [2004-04-24]
    ... posten hat vergleichbar damit, daß man seiner Familie erklärt, ... daß er in einer Newsgroup durch viele ... EVENTS nahelegen, als ihn FoxPro ad akta legen zu lassen, weil ... zeitigen Maßregelung wie RTFM auf die Antwort hinzuweisen, ...
    (microsoft.public.de.fox)
  • Re: foxpro
    ... > Can someone direct me to a foxpro or DBF newsgroup. ... Hi Shank, ... I see you're reading the Microsoft newsgroups via Outlook Express. ... FoxPro and Visual FoxPro. ...
    (microsoft.public.sqlserver.programming)
  • Re: prepared sql statements
    ... prepared statement but now when i have to insert more than one data ... It depends on if Foxpro supports batched sql statements. ... you can use a union query to insert multiple records: ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)