4k limit...Arrrgh..... What about varchar firlds??? I'd better call RBTI. Will report back later....
| "Marc" <[EMAIL PROTECTED]>
Sent by: [email protected] 05/04/2005 12:17 PM
|
|
Dawn
I thought there is still a 4k limit to the row of data
even if there is 5 note fields? Am I wrong on this?
Marc
----- Original Message -----
From: Dawn Oakes
To: RBG7-L Mailing List
Sent: Wednesday, May 04, 2005 10:18 AM
Subject: [RBG7-L] - Re: Note fields
Bob,
I have one table with 5 note fields representing departmental instructions for our shop orders. Links to our shop orders table with the job# as the PK / FK. Works great.
Dawn
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 11:15 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: Note fields
Mike,
That was the plan, and I have used that technique in the past when linking a single note field to another table full of text and ddate fields. My real worry is the multiple note fields in one table. Or......do I have multiple tables with one note field and a ref#???
Thanks for your input
Bob C.
| "MikeB" <[EMAIL PROTECTED]>
Sent by: [email protected] 05/04/2005 10:46 AM
|
|
I use one table with a RefNo column to link...
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, May 04, 2005 8:27 AM
Subject: [RBG7-L] - Note fields
> Hi all,
> I am back to creating a medical dictation system that has many categories
> for a single dictation.
> For example, some of the fields would be "Current Problem", "Past
> History", "Physical Exam", "Plan", etc, etc.
>
> All of these fields have a variable amount of data, from a sentence to
> paragraphs. I would like to use a combination of note and varchar fields
> in a table for these fields, maybe 8 or 10. Is this going to be a good
> thing to do???
>
> I heve never put more than one note field in a table, and in the past have
> tried to isolate the field into a different table in case of pointer
> corruption, but in this case.....is this a safe thing to do?? Lately I
> have not had any corruption issues. Is there a better way to do this?
> Opinions all welcome!
> Thanks,
> Bob C
