That was very helpful.
Can you use Insert, Update, and Delete SQL statements with a QofQ?
Sincerely,
Troy
Barney Boisvert wrote:
> You can't. You can emulate the behaviour by running a SELECT * QofQ with a
> WHERE clause that doesn't match the row you want to delete, but that's as
> good as it gets.
>
> Cheers,
> barneyb
>
> > -----Original Message-----
> > From: Troy Simpson [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 18, 2004 11:04 AM
> > To: CF-Talk
> > Subject: How do I delete a row in a query?
> >
> > All,
> >
> > I have manually created a query by adding rows, columns, and
> > then the data.
> >
> > I used query functions like QueryAddColumn, QueryAddRow,
> > QueryNew, and
> > QuerySetCell.
> >
> > How do I delete a row in a query result set?
> >
> > Thanks,
> > Troy
> >
> >
> >
> > --
> > Troy Simpson
> > Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
> > North Carolina State University Libraries
> > Campus Box 7111 | Raleigh | North Carolina
> > ph.919.515.3855 | fax.919.513.3330
> > E-mail: [EMAIL PROTECTED]
> >
> >
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
