Thread: [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