Bugs item #1000540, was opened at 2006-01-31 14:50
You can respond by visiting:
http://pgfoundry.org/tracker/?func=d...oup_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Ludek Finstrle (luf)
Summary: GenerateBDDirectMethod fails in VS studio 2005 with ODBC

Initial Comment:
1) i create new table in my databaze
2) I have installed 8.102 odbc driver and update it with latest dll libreries 8.108.
3)In visual studio a vreated simply database viewer with datagrid wirh ODBC driver.
4) it generate commands for update, select, insert and delete with GenerateBDDirectMethod = true
5) i added new column to my table and create new select with this new column
6) after this i lost update, insert and delete commands and GenerateBDDirectMethod is now to false and i cant set i to true. But horhers unchanged tables is OK.

Here is SQL select command:
SELECT "id_list", "zakazka", "nazev", "dat_prijeti", "dat_predani", "predano", "typy", "poznamky", "barva", "kontakt", "faktura"
FROM "public"."list"

connection string:
Dsn=test;database=test;server=192.168.0.227;port=5 432;sslmode=prefer;uid=stoupa;readonly=0;protocol= 6.4;fakeoidindex=0;showoidcolumn=0;rowversioning=0 ;showsystemtables=0;fetch=100;socket=8192;unknowns izes=0;maxvarcharsize=254;maxlongvarcharsize=8190; debug=0;commlog=0;optimizer=1;ksqo=1;usedeclarefet ch=0;textaslongvarchar=1;unknownsaslongvarchar=0;b oolsaschar=1;parse=0;cancelasfreestmt=0;extrasysta bleprefixes=dd_;lfconversion=1;updatablecursors=0; disallowpremature=0;trueisminus1=0;bi=0;byteaaslon gvarbinary=0;useserversideprepare=0;lowercaseident ifier=0


And here is table scheme:
CREATE TABLE list
(
id_list int4 NOT NULL DEFAULT nextval('list_id_list_seq'::regclass),
zakazka varchar(15),
nazev varchar(45),
dat_prijeti date,
dat_predani date,
typy text,
poznamky text,
barva varchar(15),
kontakt varchar(45),
predano varchar(10),
faktura varchar(20),
CONSTRAINT id_list PRIMARY KEY (id_list)
)
WITHOUT OIDS;
ALTER TABLE list OWNER TO postgres;

Thats all Jirka

----------------------------------------------------------------------

>Comment By: Dave Page (dpage)
Date: 2006-05-14 09:24

Message:
Continued in bug 1000630, with logs from 08.02.0002

----------------------------------------------------------------------

Comment By: Patrick Donelan (patspam)
Date: 2006-05-11 02:38

Message:
Please also refer to my bug (http://pgfoundry.org/tracker/index.p...125 &atid=538) which deals with the same issue.

I have reproduced the problem in 08.02.0002.

Cheers,

Patrick

----------------------------------------------------------------------

Comment By: Dave Page (dpage)
Date: 2006-04-28 09:00

Message:
Please test version 08.02.0002 (available from http://pgfoundry.org/frs/?group_id=1000125) and report whether or not the problem still exists.

----------------------------------------------------------------------

Comment By: Ludek Finstrle (luf)
Date: 2006-02-06 15:44

Message:
Yes I see it. I have been ill since Friday.

to others: As you can see I communicate privately with this user. I'll post the results here ASAP. It's faster for us to communicate in mohter tongue ;-)

----------------------------------------------------------------------

Comment By: Nobody (None)
Date: 2006-02-06 08:31

Message:
I sent you couple mail to you in friday. So check your mail ;-P

----------------------------------------------------------------------

Comment By: Ludek Finstrle (luf)
Date: 2006-01-31 20:50

Message:
It would be the best if you send me the compiled minimalistic reproduceable application.

I need at least mylog output. I have to see what's going wrong. Maybe you may enable Parse Statement option (broken in 08.01.0102).

Feel free to contact me direactly via mail in czech ;-)

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=d...oup_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings