Will a table with two index on one field make the search faster?
Example
TableA
Index on FieldA tag FieldAIDX1
Index on FieldA tag FieldAIDX2
Will it be faster or no effect? or make slower even because of wasted index?
sohrab100
I have a problem concerning the focus of form.
I want to know if all forms are modal, the form sequence should follow one by one? Will it be suddenly active the form at the bottom? Since I have experience that when i have a bottom modeless form 0 and calling modal form1 ->
form2 -> form3...
The Case:
Modeless form "Form1" (A Timer for show current time on top)
Modal form Form2, Form3, Form4
Form1 is set alwayontop=.t. , desktop=.t., windowtype=0
Sequence:
do form form1
do form form2 --modal call--> form3 --modal call --> form4
In normal case, form4 is the active form...
Description: Exit is a UserDefine Method in a Form
My Code
On key label f2 _screen.activeform.exit
Sometime, my client report that they face "Properties 'Exit' is not found", it is related to "EXIT" is a reserved word?
So are there any difference with the command below...
What is the difference of it?
Let's take an example...
Previous State
Key Action
F1 Help()
F2 Save()
When Issuing
1. PUSH KEY
2. PUSH KEY CLEAR
On Key label F1 Help2()
On Key Label F2 Save2()
What is the Current State
And After that,issuing
POP KEY
Then what is the...
When i browse the report .frx as table, i see the field VPOS, HPOS, Height, Width. And from the spec. of .frx and .lbx table structure for Visual foxpro 6.0 and 5.0, i know it represents the location, size of the object, so what is the unit of that value? in pixels? in mm? inches?
sohrab100
For a network program using buffering mode 5, "A" edit (rlock) a record, and "B" try to edit the same record, it return fails (obvious). But after that when "A" is still editing, "B" then append a new record, the record cannot be update using tableupdate...
I am using vfp6, i found the function INDBC() for checking the table whether belongs to current database, but how do it know whether the table is "belongs to other database" or "a freetable" when INDBC() return .f.
Or, how can it detects the table is a free table?
Thanks...
a "user" table with a field surname
data:
surname = 'David/cde'
surname = 'Chan/2345'
i want to extract the portion before '/', i issue the following sql, but the result is wrong.
select surname, substr(surname, 1 ,at('/',surname) from user
what is the problem?
sohrab100
E.g 1
Scan
....
****
++++
++++
EndScan
e.g 2
For
....
****
++++
++++
Endfor
if **** cause an error, i want to catch the error no by on error with a error handling function and skip the rest of the command ++++ and...
When i issue SHFILEOPERATION function for copy file/folder,
how can i know the actual progress value of the process rather than popup the simpleprogress dialog offered from the SHFILEOPERATION?
sohrab100
If i have to database with the same name, e.g DB, in different folder (actually the same program/database (a new and an old one), i want to copy the record from the old to the new, when i use the command "set database to db", i can't set to the database i want, what can i do?
sohrab100
The Model of POS Printer is Epson TM-U210 Series which can be connected a cash drawer with the features that can open a cash drawer through the "Control" font "A" sending to the COM Port POS Printer.
How to print a "Control" Fonts Character "A" to POS...
I have a problem on VFP Program running in Windows 2000.
When I compile program using VFP6.0 SP5 in windows 2000,
some of the bug like fatal exception: "c0000005" or "c0000094", but when i run the win2000 compile exe in win98, i got no error?
Is there any problem in win2000...
I have some function want store it into a DLL file for other foxpro application to use later, how can i create a dll using foxpro and what i need to add?
For example, I have a procedure or function
Procedure proca
****do something
endproc
Function funca
Para para1, para2
****do something...
Will RLOCK() function or SQL Update/Insert/Delete make the table "File access is denied"?
If not, what cause the table being write protected?
sohrab100
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.