General information
Category:
Forms & Form designer
>Why don't you have two logical fields in the table to begin with? They take up the same amount of space in the DBF as your string does. It would make it much easier to work with.
Because there's more than 2 things on the checkbox. There can be up to 250. It's much easier to save it as a string and do the manipulation than to try and maintain a table with 250 fields that may or may not be there.
>But I don't think a view is going to exactly help you because the view won't be able to convert the logical back to char to store in the table. You could use a view that does the char->logical conversion then in the "Save" process SCAN the cursor and do REPLACEs on the table the view is based on.
I ended up using a cursor, not a view, because it couldn't update by itself. I take care of the updating in the click of the checkbox.
It's working great, now. Thanks everyone for your help!
-Michelle
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only