Обсуждение: [Fwd: In the Soup]
Thomas Good wrote: > > When I pare my main() module down to simply declaring a communication > area (include sqlca.h) and then connecting to the db (which succeeds) > and subsequently running exec sql delete from $table where > $attribute=value; I get no stderr. But, alas, I get no record removed > either. Meanwhile, the same sql cmd when run from psql rm's the > record. > Anyone who can get ecpg to delete records will earn my undying > gratitude (or a rack of good belgian ale ;-) I am able to do data > retrieval no problem via ecpg and this morn am writing a usr interface > to do inserts and updates (we'll see how that goes...) But record > removal eludes me. > Help (Bruce! Tom! - Anybody!!?) (and thanks!) > Tom Good Meskes, Michael wrote: > > Thomas, could you please re-send me the original bug report. I seem to > have lost it under the about 3000 mails wainting for me. Thomas G., can you send Michael your pared-down test case? Thanks... - Tom
Hmm...I don't have the original as I managed to get it going... my exec sql commit; line was misplaced (my error not Michael's). I apologize for wasting your time... I am *very* stuck on updates that use a call to gets(). scanf() works fine but... when I need the usr to give me a string for a record update gets() behaves oddly. The src compiles and links, connects, queries for a list of records and then uses printf() to ask for usr input. At this point, it leaps ahead of the current stanza, inputting a null into the attribute in question. I have tried making the call to gets() simple: char usr_buffer[81]; ... printf("Enter blah blah blah: "); fflush(stdin); gets(usr_buffer); and I have tried allocating memory (and making the usr-buffer var a pointer...) but this also fails. Finally, I tried making the call to gets() part of a separate usr defined function. This also compiled without error but displays the same symptoms. I raised this once (or twice ;-) but felt a bit sheepish over my delete blunder so I didn't really want to push the issue. Having said that, I do wonder if it really is stupidity on my part or something Michael could have a look at...? I will send him my code, off-list... Thanks alot for your patience Tom, you're quite a guy. ----------- Sisters of Charity Medical Center ---------- Department of Psychiatry ---- Thomas Good, System Administrator <tomg@q8.nrnet.org> North Richmond CMHC/Residential Services Phone: 718-354-5528 75 Vanderbilt Ave, Quarters 8 Fax: 718-354-5056 Staten Island, NY 10305
Tom Good writes: > I am *very* stuck on updates that use a call to gets(). > scanf() works fine but... > when I need the usr to give me a string for a record update gets() > behaves oddly. The src compiles and links, connects, queries for a > list of records and then uses printf() to ask for usr input. We've solved this one in private mail. It was no bug in ecpg. So there's no need for a patch in 6.3.2. Michael -- Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH meskes@topsystem.de | Europark A2, Adenauerstr. 20 meskes@debian.org | 52146 Wuerselen Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44 Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10