Re: [GENERAL] problem updating from form

2011-01-02 Thread Karen Springer
Hi Adrian, Yes, the complaints have increased with the number or rows and the number of users accessing the DB. The problem record looks like this. BarCode: W205179 PartNumber: 380-013 LRU: 380-013 PartsListRev SerialNumber MTN DocNum: 150-2380-XXX Comments SupplierNo DrawingNoRev WorkOr

Re: [GENERAL] problem updating from form

2011-01-02 Thread Karen Springer
to the latest on my test machine hoping it would help. The users have the older psqlodbc. I will ask the pgsql-odbc group next. Thank you for your suggestions! Best regards, Karen On 01/02/2011 9:41 AM, Tom Lane wrote: Karen Springer writes: I have a problem that has me stumped. We ha

[GENERAL] problem updating from form

2011-01-02 Thread Karen Springer
Hi, I have a problem that has me stumped. We have a table that is the main table in a production Microsoft Access application. Our users are complaining that sometimes they enter data in the form, move off of the record & then upon returning to the record the data reverts back to what exist

[GENERAL] View fields are cast as text and link to Access as a Memo field

2008-01-29 Thread Karen Springer
Hi, I have a table CREATE TABLE "HR"."Participant_Names" ( "PIP" int4 NOT NULL, "LastNAME" varchar(32) NOT NULL, "FirstName" varchar(20) NOT NULL, "NameUsed" varchar(20), CONSTRAINT "pkey_PIP" PRIMARY KEY ("PIP"), ) WITHOUT OIDS; and a view CREATE OR REPLACE VIEW "HR"."tvw_EmployeeNames_A

Re: [GENERAL] recursive function

2007-07-09 Thread Karen Springer
W4 This function will return toplevelparentbc ChildBarCode W1W2 W1W3 W1W4'; Karen Pavel Stehule wrote: Hello please, look on http://people.planetpostgresql.org/merlin/index.php?/archives/2-Dealing-With-Recursive-Sets-With

[GENERAL] recursive function

2007-06-13 Thread Karen Springer
Hi, I am struggling to write my first recursive function and think I'm missing something basic. I have written 2 functions that work if I pass over one parameter, but if I try to pass over a series of parameters say in a view for every field in the table it seems to run but never displays da