Am I crazy?

[Kevin James]

Hi Das

How many records in total?
If not too many perhaps you could build a list of all records for export and then step through the lines. 
Of course, if you have a large number of export records you could loop through in blocks of , say, 10,000 records. 

Cheers

Sent from my iPhone

> On 8 Dec 2020, at 3:25 am, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> Today I’m going to try placing a reorganize data command before I try the repeat loop.. it’s so simple that nothing but broken indexes can be the explanation.. and that’s likely as the library touching the datafile has been changed a little from what the datafile is used to… so I think it’s reorganization that is needed, trying that today
> 
>> On Dec 7, 2020, at 7:39 AM, Jeffrey Jones <jjones at synergos.com> wrote:
>> 
>> Hi Das, did you try it with quotes around the 5?
>> 
>>> If pos('5',prsavedviewname)
>> 
>>>> On Dec 6, 2020, at 5:54 PM, Das Goravani <goravanis at gmail.com> wrote:
>>> 
>>> 
>>> Dear Friends, 
>>> 
>>> I have this simple scenario as below in the code. I am finding first on the RSN field, then I am texting on that same field. If a record has a 5 in it’s name, I want to breakpoint on that, and I have such a record, and yet it is never stopping on that breakpoint. It’s as if it is not finding that record. This is part of an export routine.. exporting from my old version which uses the df1, and later I import into a SQL database. The record is not coming through to the SQL database, so I am backing up to here, the export routine, and seeing if it’s getting exported, and it seems it is not being found by this simple loop which should in turn find all records in the file. Shouldn’t it? I mean find first on RSN and then next on RSN should Until Flag False find them ALL should it not?
>>> 
>>> 
>>> Find first on prrsn
>>> Repeat
>>> If pos(5,prsavedviewname)
>>> Breakpoint
>>> End If
>>> Print record
>>> Next on prrsn
>>> Until flag false
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com