FiveTech Software tech support forums

Marc,

Marc Vanzegbroeck wrote:

Code: Select all  Expand view

oSQL:=nil
 

This is not needed.

Marc Vanzegbroeck wrote:How can I close the connection completely with ADO?

Code: Select all  Expand view

oSQL:close()

Should be enough. It might be a timing issue. Try to insert a delay between close() and ferase().

EMG

Hi Otto;

The problem was timing. WinExec() hadn't finished before the check for file() was being executed. I changed WinExec for Waitrun() and that fixed the timing problem.

Thank you,


Reinaldo.

... very beginning and using oRs:Filter conditions to give me my relational records... I would rather not do that, but this problem seems like a IO timing issue with Access. Rick Lipkin That was my second one idea. in fact I do that way but with MySql, I have a PRG with ten tables and not problem ...

... made sense .. but it had no effect .. the magic number seems to be 7 opens and closes and then the 4th table or so refuses to open. I have had timing issues with Access during the data conversion with multiple records being added and updated .. I had to put SysWait() in between the oRs:Update()s ...

... quit the Master Property table and re-open the Property table and once again the relational tables open. Unfortunitly I do not know if this is a timing issue with Access or resource problem ? When I close the detail screen I am closing all the relational tables and I know they are all closing ...

... where it stores the xml document. The problem happens when it chains several calls to that function, and each time sends a new document. The timing was such that it was very quick. I changed this by modifying the called function. Each time it is called, the document it receives is added to ...

Interested, yes, but timing and location would be the issue. Usually to pull this off it takes a lot of people. I used to attend many xbase conferences and they were always fun.

... called. Logic would also say that the if select( cAlias ) = 0 trap didn't work because the alias was still valid at that point. Possibly, it is a timing issue that a sysrefresh() or dbcommit() would solve. Or maybe, ::cAlias is nil and thus select( ::cAlias ) just returns the current workarea ...

Perfect. Thanks for the help

Harvey,

#define TTM_SETDELAYTIME (WM_USER + 3)
#define TTDT_AUTOPOP 2

Those values are defined in c:\bcc55\include\commctrl.h

Antonio: Doesnt work :cry: I need to define the ttm_setdelaytime #define TTM_SETDELAYTIME ??? what value #define TTDT_AUTOPOP ??? what value I placed SendMessage( hWnd, TTM_SETDELAYTIME, TTDT_AUTOPOP, nMakeLong( 6000, 0 ) ) below the endif in the array if endif statement. Nothing happens BUT If I se...

Harvey,

Your code should go outside of that if ... endif unless you plan to use an array for the tooltip info:

Code: Select all  Expand view

SendMessage( hWnd, TTM_SETDELAYTIME, TTDT_AUTOPOP, nMakeLong( 6000, 0 ) )
 

Yes I know. This seems to be the location where the attribures of the tooltip take place but the if statement == "A" is a problem since the tooltip is a "C". I may be way off but i couldn't find any othe place in window.prg where the tool yip is adjusted. if ValType( cToolTip...

Harvey,

That was not a solution, just the section of code where the solution needs to go.

Antonio was requesting feedback on any other properties that we might want to also add at the same time as the timing fix. I haven't looked at the docs yet.

James

Antonio:
Read the information you sent looked at the code. Looked at window.prg and I cant seem to figure out what to do.