k around the problem through
cursor.setFetchSize (1)
The cursor will then get only one row per network request. This is slower, but it
doesn't seem to confuse the python driver as much when LONGs are part of a row.
Daniel Dittmar
--
Daniel Dittmar
SAP Labs Berlin
[EMAIL PROTECTED]
> --
This is a forwarded message
From: Sim Zacks <[EMAIL PROTECTED]>
To: "Dittmar, Daniel" <[EMAIL PROTECTED]>
(Sorry, I noticed I hit reply before and didn't send it to the list)
I am using the python module you mentioned with Python version 2.2.1.
It occurred again wh
t prints all the comments in
the tables. I have also checked the row[0] and it is also populated.
The loop runs once, it prints out "statement executed" but when it
doesn't update the table.
Also in a try...except block it doesn't get to the except part.
Sim Zacks
IT Ma
Have you tried using Any instead of In? Someone posted that there was
a bug that Any and In were showing different results even though they
should return the same.
Have tried not exists like shown:
select count(a.id)
I defined a COMMENTS column as a LONG, and now we need to be able to
search the column so I would like to convert it to a VARCHAR
I tried ALTER TABLE MODIFY COMMENTS VARCHAR(8000) and it said the
field types were incompatible.
I tried creating a new column and updating it
UPDATE TBL1 SET COMMENTS
I am using MaxDB 7.5.00.12
I am trying to create a view that has the last record of each
application in the database and I get the following error:
"Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed
General error;-9000 POS(1) System error: Not yet implemented:SELECT IN
FROM PART OF
Sim
____
Sim Zacks wrote:
> Elke,
>
> A simple example of the power of including joins in an Update
> Statement:
>
> Update Tbl1 set tbl1.field1=tbl2.field2*.10,
> from Tbl1 join tbl2 on tbl1.PKfield=tbl2.tbl
Elke,
A simple example of the power of including joins in an Update
Statement:
Update Tbl1 set tbl1.field1=tbl2.field2*.10,
from Tbl1 join tbl2 on tbl1.PKfield=tbl2.tbl1FK
This will update all the joined rows in tbl1 to 10% of the values in
tbl2.
I don't see how that is possible using any of th
While I don't have a MaxDB instance I can test this on, I have a
couple ideas for you. (By the way I have been using the FROM clause in
MSSQL Updates for a long time and don't see how you can live without
them.) In Access you can put the join statement in the table name
spot, such as "UPDATE TABLE1
The SQL statement would be
select parent_fk from child
group by x,parent_fk
having count(*)>=2
That would be ansi SQL,I have never tried something like this in MaxDB
Hello list,
I have a rather simple parent/child
e to use so called
Passthrough-Queries. This means Access will send the query, without any
processing, to the selected source.
Peter
-Ursprüngliche Nachricht-
Von: Sim Zacks [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 17. Mai 2004 09:40
An: [EMAIL PROTECTED]
Betreff: MaxDB with Access Lin
I am trying to convert a project from Access to MaxDB backend with an
Access frontend.
I am having a slight problem with case sensitivity and the Like
predicate. Access won't pass the Upper function through and returns an
error that it is an undefined function. I tried using StrConv, the
Access fu
12 matches
Mail list logo
