>> 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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.