Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query to change case.
- Thread starter jlockley
- Start date
jlockley,
You can't use a query, but you can do this with a script quite easily. The article at walks you through the process.
Hope this helps...
-- Lance
You can't use a query, but you can do this with a script quite easily. The article at walks you through the process.
Hope this helps...
-- Lance
- Thread starter
- #3
jlockley,
I understand and that's why I wrote the tutorial, both to provide a FAQ for something that's not readily obvious when you're new to Paradox and to help introduce people to ObjectPAL itself.
Paradox itself is designed to provide the basic framework and ObjectPAL is intended to let you determine the final look of the place. IOW, ObjectPAL skills are very, very helpful, for they help you automate Paradox.
The language may seem a bit strange at first, but once you get the hang of it, you can do a suprising number of things to make Paradox more effective for you.
Hope this helps...
-- Lance
I understand and that's why I wrote the tutorial, both to provide a FAQ for something that's not readily obvious when you're new to Paradox and to help introduce people to ObjectPAL itself.
Paradox itself is designed to provide the basic framework and ObjectPAL is intended to let you determine the final look of the place. IOW, ObjectPAL skills are very, very helpful, for they help you automate Paradox.
The language may seem a bit strange at first, but once you get the hang of it, you can do a suprising number of things to make Paradox more effective for you.
Hope this helps...
-- Lance
Also, by setting the Picture value on the field in question, you can force future entries to match the correct case.
Mac
"Do not delve too deeply in the arts of your enemy and so become ensnared by them"
langley_mckelvy@cd4.co.harris.tx.us
Mac
"Do not delve too deeply in the arts of your enemy and so become ensnared by them"
langley_mckelvy@cd4.co.harris.tx.us
- Thread starter
- #6
jlockley,
Don't worry. You'l get there. Programming is little more than learning a) problem solving, b) the syntax of the language you're working with, and c) learning how the syntax you use affects the environment you're coding for.
Just give it time. Read as much code as you can and then adapt it to your own needs.
I'm pretty much self-taught, too, so I do know how it feels. ObjectPal is a little weird when you first encounter it, however, if you stick with it, it does make sense after a time.
Kind of like English. ;-)
(Note: I didn't say *the* English, who are an entirely different story.)
If you've got any questions, please feel free to post.
Hope this helps...
-- Lance
Don't worry. You'l get there. Programming is little more than learning a) problem solving, b) the syntax of the language you're working with, and c) learning how the syntax you use affects the environment you're coding for.
Just give it time. Read as much code as you can and then adapt it to your own needs.
I'm pretty much self-taught, too, so I do know how it feels. ObjectPal is a little weird when you first encounter it, however, if you stick with it, it does make sense after a time.
Kind of like English. ;-)
(Note: I didn't say *the* English, who are an entirely different story.)
If you've got any questions, please feel free to post.
Hope this helps...
-- Lance
- Thread starter
- #8
Thanks. Tried it, and it seems to work, except that some of the all cap entries are in a key field. Since I don't know which are the newer ones, I need to compare them. I am using Clipmate to do a cut - change case - paste operation. It's bad, but it works. Once the Key field is out of the way, I will try the rest.
Things you learn as you go.
Things you learn as you go.
jlockley,
Hm. You might consider checking the language driver of the table. It sounds like you might be using the default ascii based driver (case sensitive sorting) when you should be using an ANSI (case-insensitive sorting) driver.
The article at covers the issue, though I originally wrote it for a different focus. You may find helpful as well.
Hope this helps...
-- Lance
Hm. You might consider checking the language driver of the table. It sounds like you might be using the default ascii based driver (case sensitive sorting) when you should be using an ANSI (case-insensitive sorting) driver.
The article at covers the issue, though I originally wrote it for a different focus. You may find helpful as well.
Hope this helps...
-- Lance
- Thread starter
- #10
Fantastic. I went in with Clipmate and did a cut /change case/paste operation for the keyed field, which took some time, but it's all in the correct case now.
Thanks for the language tips. With mixed case it won't effect sorting, but Paradox has refused to handle a great deal of cut and paste material from international documents, so that will be a boon.
The case change script worked like a charm on all other fields. More than thanks for that one.
Thanks for the language tips. With mixed case it won't effect sorting, but Paradox has refused to handle a great deal of cut and paste material from international documents, so that will be a boon.
The case change script worked like a charm on all other fields. More than thanks for that one.
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question