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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MirekZvolsky
  • Order by date
  1. MirekZvolsky

    LostFocus on a Grid - Ain't There

    >> because the current ActiveControl is still known in the LOSTFOCUS event. By the VALID event it does not know the ActiveControl any more. I've tested it. 1/ Frank, how is this possible? I think Valid always run BEFORE Lostfocus, or not? 2/ Then: If you want save the information inside a...
  2. MirekZvolsky

    Saving changes when record pointer moves in grid

    Hi, I have grid (with readwrite cursor and optimistic table buffering), and I can edit data - in this grid, - in other controls (textboxes,..) refreshed from .AfterRowColChange - in special form called through shortcut or hotkey previous works fine, but: When I move in the grid to the...
  3. MirekZvolsky

    The Easiest Way to Create ZIP File in VFP...(2 lines only)

    Installation problem on Win98 - solution: The problem causes missing ATL.DLL. You can download it for example from http://www.mts.com/nvd/programs/atl.dll as described in http://www.mts.com/nvd/patches.htm You should place it into windows\system folder and run "regsvr32 atl.dll" to...
  4. MirekZvolsky

    how to make an application

    You can create an EXE from project. So use File, New Project. Then use Add and point to the "main" file, i.e. to the program, which you start when you run your application now with the development version. It is not necessary to add other files to the project window, because when you...
  5. MirekZvolsky

    The Easiest Way to Create ZIP File in VFP...(2 lines only)

    Win98SE: First I want say that I have no problem to register xstandard-zip on Win98SE. However in other fox forum (not in eng language), someone said about same problem, as you have. Answer from other person was, that not correct support for ATL (MS-Active Template Library) is installed. So I...
  6. MirekZvolsky

    Asynchronous mode, non-batch mode..

    I don't undestand, what Asynchronous mode has to do with limitation number of records in recordset. You can limit number of records returned in sql select command "SELECT TOP 100.." or "SELECT TOP 10 PERCENT..", however syntax can depend from the database engine (MS-SQL...
  7. MirekZvolsky

    How can I speed up this query

    If it is query into native VFP data (DBF), then it is good to have indexes in tables. Create index tag on -- each expression on left side in WHERE -- each expression on both sides in JOINs -- DELETED() if SET DELETED is ON while running query So in your case index Check_order_header on h_type...
  8. MirekZvolsky

    'Collating Sequence' error message

    In CONFIG.FPW file you probably have CODEPAGE=AUTO or AUTO is a default (if CODEPAGE= isn't in CONFIG.FPW or you have no CONFIG.FPW at all). Add or modify the line in CONFIG.FPW to CODEPAGE=1252 (Windows ANSI). Then standard collating sequence will be used. CONFIG.FPW you can make Included in...
  9. MirekZvolsky

    Do most people write VISUALLY or PROGRAMATICALLY

    I don't know, if grid is good example, for where visual design is better. In VFP8 is the situation better, because different as default controls can be added in visual design, too. However in VFP7 and earlier, if I use visual design, I always had default Columns, Headers and Column controls...
  10. MirekZvolsky

    Object Properties not available in Form Code Window

    Hasn't AddProperty 2 parameters only, 1-st one: property name? Maybe you mean oCt.ADDPROPERTY('gcFromBank','') instead of ADDPROPERTY(oCt,'gcFromBank','')
  11. MirekZvolsky

    How to know you are at last (ordered) record when in grid

    Grid.AllowAddNew - but maybe this is not useable for you. From VFP help: You can make it possible for users to add new records to a table displayed in a grid by setting the AllowAddNew property of the grid to true (.T.). When the AllowAddNew property is set to true, new records are added to the...
  12. MirekZvolsky

    error: function requires row or table buffering mode

    Of course. THISFORM is OK, but THISFORM.Text1 isn't, because first runs Form.Load, then objects(controls) are created, then runs Form.Init.
  13. MirekZvolsky

    error: function requires row or table buffering mode

    There is no problem with use of THIS or THISFORM in Load.
  14. MirekZvolsky

    error: function requires row or table buffering mode

    Try -- SELECT Money -- before TableUpdate or try TableUpdate(.T.,.F.,'Money')
  15. MirekZvolsky

    How to get records in Asynchronous and non-batchmode?

    to pcw66: no, no. VFP isn't busy. Busy is SQL Server. DO WHILE SQLEXEC()=0 use only, if you have no other job for foxpro at that time. Otherwise, you can do for example following: DO WHILE .T. IF oApp.lServerBusy AND SQLEXEC(Hnd)#0 oApp.lServerBusy = .F. WAIT CLEAR ENDIF...
  16. MirekZvolsky

    How to get records in Asynchronous and non-batchmode?

    I never worked with such something, however I understand it so: sqlmoreresults() is designed to take more as one recordset into foxpro cursors, if the sql-command in sqlexec() returns more as one recordset. But sql-command in your example returns 1 recordset (1 cursor) only. So, why to use...
  17. MirekZvolsky

    Clicking on record in grid sets a different one

    Mike, >> Is it possible that you are changing the field on which the table is indexed? The table is created with CREATE CURSOR and has no index. I'm sorry, that I said something about BEGIN TRAN. Now I see the problem occurs without BEGIN TRAN too. If I click to some position...
  18. MirekZvolsky

    Clicking on record in grid sets a different one

    Hello, VFP7, SP1, Win98, DBF-data When I move in grid to another record, I want save data first, which are changed (in all currently opened cursors). To save changes I call in BeforeRowColChange an "saving" procedure. But with this procedure grid behaviour is strange: When I click...
  19. MirekZvolsky

    Picture into a SQL table

    Another possibility on FoxPro side is memo(binary)+STRTOFILE/FILETOSTR. However I don't know, which data type is on sql server suitable for long binary data, but sure there is one.
  20. MirekZvolsky

    how to create class , property, method

    1) You should prepare a class definition based on some baseclass, in your case non-visual baseclass, f.e. Custom. You can make definition programatically or in visual designer. 2) You can define properties (and their initial value) and methods (and their code) that way: DEFINE CLASS UserActions...

Part and Inventory Search

Back
Top