|
-
Aug 26th, 2007, 11:06 PM
#2
Re: Multiple values in a single MEMO field
Your idea makes me laugh. It may work but that is a very bad idea because it will be very slow to query.
* Memo field is non-indexable.
* LIKE operator is much slower than other comparision operators, particular on long string and/or large table. Use it only when you have no other choice.
* Check box values are 0 and -1, need to be converted to 0 and 1 when stored.
If you think that is a smart idea then I would suggest:
* Reserve first 10 characters for 10 checkboxes and that may be something like : "1010011000", no need to use Split or Join when read and write.
* On query, use:
WHERE (Mid(YourMemo,2,1) = "1") '-- that is CheckBox2 is checked
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|