|
Home > Archive > SQL Anywhere database > April 2005 > Memo field with data from another record
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Memo field with data from another record
|
|
|
| I have a memo field which the users can not directly access. Rather, they
add a note which I add a datetimestamp line and then add the note to the
existing memo value.
I have two records that *impossibly* contain the same notes, Such as:
Record #1:
Kim, Diana Wrote on 04/09/05, 01:27:10 p:
*** Pax Flying with R-40596***
----
Kim, Diana Wrote on 04/09/05, 01:26:05 p:
wts: 166 120
Record #2:
Kim, Diana Wrote on 04/09/05, 01:27:10 p:
*** Pax Flying with R-40596***
----
Kim, Diana Wrote on 04/09/05, 01:26:05 p:
wts: 166 120
No other issues have been reported.
Looking for direction/advice if I should do an unload/reload, validate, etc.
TIA,
-k-
| |
| Breck Carter 2005-04-12, 8:23 pm |
| Show us the table definition. Is there a primary key?
> I have a memo field which the users can not directly
> access. Rather, they add a note which I add a
> datetimestamp line and then add the note to the existing
> memo value.
>
> I have two records that *impossibly* contain the same
> notes, Such as:
>
> Record #1:
>
> Kim, Diana Wrote on 04/09/05, 01:27:10 p:
> *** Pax Flying with R-40596***
> ----
> Kim, Diana Wrote on 04/09/05, 01:26:05 p:
> wts: 166 120
>
> Record #2:
>
> Kim, Diana Wrote on 04/09/05, 01:27:10 p:
> *** Pax Flying with R-40596***
> ----
> Kim, Diana Wrote on 04/09/05, 01:26:05 p:
> wts: 166 120
>
> No other issues have been reported.
>
> Looking for direction/advice if I should do an
> unload/reload, validate, etc.
>
> TIA,
> -k-
>
>
| |
| Breck Carter [TeamSybase] 2005-04-13, 7:23 am |
| It is most likely an application error. The primary key is not
autoincrement, so the application must provide different values when
it inserts the "duplicate" rows (the rows with identical values in
ReservationNotes).
Breck
On 12 Apr 2005 20:18:26 -0700, "Kumar" <ddsnospam@maui.net> wrote:
>Sorry. v9.0.2/latest build
>
>Yes, there is a primary key (an integer field).
>
>I'm not sure how to generate a "table definition", but I did an unload of
>the table's structure only and have attached it (sorry in advance if I
>shouldn't attach items in the ng, but it is small). The field of issue is
>the "ReservationNotes" field... a "Text" datatype
>
>btw, I have confirmed that no messages appeared on the server during the
>timing of the posting of these record(s). The only entry for days has been
>the Starting/Finishing of checkpoints.
>
>TIA,
>-k-
>
>
><Breck Carter> wrote in message news:425c3821.6977.1681692777@sybase.com...
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| Okay... we use a middleware piece (Asta) that generates all the sql.
I'll assume that something got gabbled there. Anyway, you've never seen
such an issue cased by the DB itself, correct?
TIA,
-k-
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:etpp51hjl3tk56s
ua1cgahi3rc6ce5nhck@
4ax.com...
> It is most likely an application error. The primary key is not
> autoincrement, so the application must provide different values when
> it inserts the "duplicate" rows (the rows with identical values in
> ReservationNotes).
| |
| Greg Fenton 2005-04-13, 8:23 pm |
| Kumar wrote:
>
> I'll assume that something got gabbled there. Anyway, you've never seen
> such an issue cased by the DB itself, correct?
There is no issue. Unless you have a UNIQUE constraint on that column,
there is nothing stopping the application from inserting multiple
instances of the same value into a column.
Of course, there could be something like a trigger that is duplicating
the insert but even here I consider this an "application" issue
(triggers are created as part your app's configuration).
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|