Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement