bb.donnay-software.com

Hi Bob, The problem arises in networks with XP, Vista and Windows 7 in a mixed environment. According to the Alaska site it is for networks with Windows 2008 servers. If we have problems with indexes we always install the SMB2 solution, and up to now, the problem was solved each time. http://www.ala...

Hi,

In your new code you still have a lot of
dbskip(), reccount(), delete, ... without alias. You still could optimize it a lot.

Replace commands as DELETE with dbdelete().

Hi Bob,

For instance it may show a file opened that has 400 records in it but the index shows 3,000,000. Very weird.

This seems as an index problem. I suppose your users are using Windows 7? I would try the SMB2 solution of Alaska.

Hi, Use aliasnames to make your code readable. IF M_KodPr > 0 .AND. M_Znach <> 0 SELECT InfPortCls APPEND BLANK REPLACE Kod_pr WITH M_KodPr REPLACE Name WITH M_Name REPLACE Znach WITH M_Znach ENDIF DC_GetProgress(oProgress, RecNo(), nMax) SELECT (Ar_Model[M_CurrInf]) DBSKIP(1) ENDDO DC_GetProgress(o...

Hi, Why are you doing the following? DCADDBUTTON CAPTION Ar_Model[1] ; SIZE K+LEN(Ar_Model[1]) ; ACTION {||InfPortCls1(), DC_GetRefresh(GetList)}; PARENT oToolBar ; TOOLTIP 'Генерация информационного портрета в модели: '+Ar_Model[1] Instead of infportscls1() you can use infportscls(1). This way you ...

Hi,

Don't bother.

After posting my message I saw that I was using oBrowse and oPickBrowse.

Hi, I have a problem with the refresh of a DCBROWSE. It's a browse of an array. I have a DCGET which has in the VALID the following: aadd(aData, { getvalue, xxx }) ,; oBrowse:gobottom(),oBrowse:forceStable() ,; oBrowse:refreshall(),DC_GetRefresh(GetList),.T. } I want the browse to display the last e...

Thanks Roger,

Problem is solved.

Finding the last row of a sheet isn't very simple to find. In case anyone ever needs this, the following seems to work correctly:

oUsedRange := oSheet:usedrange
nMaxLines := oUsedrange:rows:count()

Hi,

I'm using activeX to read some XLS files.

When the import is done, I have a 'oExcel:Destroy()'. If I check with Taskmanager, it looks as Excel remains active after this destroy.

Some hints to prevent this? Or correct way to stop Excel?

Hi, Using a field to TAG looks as a bad idea to me. In a multi-user environment, you can never be sure who has tagged the record. I'm tagging with an array, in which I put the record numbers. In the ITEMSELECTED you call a function which checks if the record number is in your array or not. I never u...