Hi.
I have a table with an inactive primary index. I need to read all records to set some default values but the OPEN QUERY statement wants to choose the primary index and then complains that it is inactive. Is there an option to tell the OPEN QUERY statement to not use any index and just plow through every record?
Thanks.
Is there another index that is active? USE-INDEX?
Flag this post as spam/abuse.
Isn’t that what the TABLE-SCAN option was made for?
Isn’t that what the TABLE-SCAN option was made for?
Flag this post as spam/abuse.
Is there another index that is active? USE-INDEX?
No, there isn't one for OPEN QUERY. Only FOR EACH's allow TABLE-SCAN, as you mentioned.
Is there another index that is active? USE-INDEX?
Flag this post as spam/abuse.
You can start session with the -noinactiveidx parameter to prevent the compiler selecting inactive indexes.
Or, you can write a FOR EACH instead of an OPEN QUERY and use TABLE-SCAN ... :)
Still doesn't help him if his table is in a Type 1 area.
Why Progress doesn't allow this on OPEN QUERY I have no idea. It would even be useful in some cases on Type 1 areas but at least I can understand why they didn't implement that.
You can start session with the -noinactiveidx to prevent the compiler selecting inactive indexes.
Flag this post as spam/abuse.
table-scan does not work on type 1 areas. for them, it uses the primary index or the default index.
for each ought to work with open query. don’t know why it doesn’t.
table-scan should work whereever you can say use-index.
regards, knower of even more obscure things.
gus
“In God we trust. All others bring data.” — W. Edwards Deming
> On Jul 1, 2015, at 4:50 PM, TheMadDBA wrote:
>
>[collapse] From: TheMadDBA
> Post: RE: Traverse All Records in a Table with Inactive Index
> Posted in: Forum
> Link: https://community.progress.com/community_groups/openedge_development/f/19/p/18914/67183.aspx#67183
>
> Still doesn't help him if his table is in a Type 1 area.
> Why Progress doesn't allow this on OPEN QUERY I have no idea. It would even be useful in some cases on Type 1 areas but at least I can understand why they didn't implement that.
>
>
> --
> You were sent this email because you opted to receive email notifications when someone created a new thread.
>
> To unsubscribe[collapse] from:
> - ...only this thread, disable notifications at https://community.progress.com/community_groups/openedge_development/f/19/p/18914/67183.aspx#67183.
> - ...all email notifications from Progress Community, navigate to "Settings", click on the "Email" tab, then under the "Email Configuration" section, set Send Notifications to "No".
>[/collapse][/collapse]
Does that include CAN-FIND and FIND? ;-)
Just kidding... please don't add that to the 4GL.
On Jul 1, 2015, at 5:37 PM, TheMadDBA wrote:
>
> Does that include CAN-FIND and FIND? ;-)
but of course!
regards, knower of even more obscure things.
gus
“In God we trust. All others bring data.” — W. Edwards Deming