Andrus wrote:
>
> How I can read and reply to all messages without receiving them all
> to my e-mail mailbox ?
From the Mailing Lists page of the PostgreSQL site
http://www.postgresql.org/community/lists/:
"The mailing lists are also available at the PostgreSQL news server.
However, in order t
On Mon, 2005-07-18 at 11:53, Andrus wrote:
> >> I ran DELETE command from my ODBC client application.
> >> I want to get the number of rows deleted by this DELETE command.
> >
> > I'm sure ODBC provides a way to do that, but you're asking the wrong
> > list about what it is ... try pgsql-odbc.
>
>
On 18/07/2005 17:47 Andrus wrote:
Unfortunately, no result is returned if DELETE command is executed.
There is no SQLRowCount function in FoxPro.
That's probably a feature of the language and will be so regardless of the
database used. I expect it wraps the ODBC APIs up in a more managable fo
>> pgsql.odbc newsgroup has only 5 messages in the whole this year. None of
>> them has got any replies.
> I think you're making the classic mistake of equating the usenet news
> versions of a list with the actual mailing list.
>
> Take a look here:
>
> http://archives.postgresql.org/pgsql-odbc/20
>> Unfortunately, no result is returned if DELETE command is executed.
>> There is no SQLRowCount function in FoxPro.
>
> That's probably a feature of the language and will be so regardless of the
> database used. I expect it wraps the ODBC APIs up in a more managable
> form.
Paul,
If Microsoft S
My ODBC client is Microsoft Visual FoxPro
I ran delete command using its sqlexec() function like:
SQLEXEC(nConnhandle, "DELETE FROM mytable")
sqlexec() function returns the result from ordinary select table in a
cursor SQLRESULT
Unfortunately, no result is returned if DELETE command is execu
>> I ran DELETE command from my ODBC client application.
>> I want to get the number of rows deleted by this DELETE command.
>
> I'm sure ODBC provides a way to do that, but you're asking the wrong
> list about what it is ... try pgsql-odbc.
Tom,
pgsql.odbc newsgroup has only 5 messages in the wh
After an application updates, deletes, or inserts rows, it can call
SQLRowCount to determine how many rows were affected. SQLRowCount returns
this value whether or not the rows were updated, deleted, or inserted by
executing an UPDATE, DELETE, or INSERT statement, by executing a positioned
upda
On Jul 18, 2005, at 7:00 AM, Andrus wrote:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read the DELETE command docs but havent found any function.
Any idea ?
I don't use ODBC, but you should get that directly back
"Andrus" <[EMAIL PROTECTED]> writes:
> I ran DELETE command from my ODBC client application.
> I want to get the number of rows deleted by this DELETE command.
I'm sure ODBC provides a way to do that, but you're asking the wrong
list about what it is ... try pgsql-odbc.
re
Ropel, thank you.
I'm looking for a better solution because
1. Some deletes take big amount of time. This increases run time a LOT
2. This requires the use of transaction if somebody changes data between
SELECT COUNT(*) and DELETE commands.
When transaction isolation level I must set for this ?
At least, you can do a "select count(*) from ..." just before the
delete, better if inside a transaction, if the query itself is not too
much expensive
Andrus wrote:
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read
I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.
I read the DELETE command docs but havent found any function.
Any idea ?
Andrus.
---(end of broadcast)---
TIP 3: Have you che
13 matches
Mail list logo
