[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