|
top
I am a registered user,
if I upgrade with the new DEMO version , do I need to register again?
I am a registered
user, can I install my registered copy to an other drive or computer?
When I open the
Windows-Explorer and I choose a DBF file with the double click, the program starts and I
have an error message : Error opening database, wrong memo, index, driver or file is used
by an other user.
I cannot replace the value of a field record
when I use the replace function of the program and when I enter only a string value. Do
you have a work around?
Can I use my own UDF (User Define
Functions) with the programs?
In VISTA, how can I remove the annoying UAC (
User Access Control ) prompt window, even if I am an administrator.
My UDF-DLL.dll file causes the program
to crash. If I remove it from my program directory, everything is fine
When I set relations, how can I see
only link data or Set Selective Relations?
How can I go through
all marked records, in large databases, it's hard to manipulate?
How can I replace Fields in Parent with
Data from the Child Table like the old Clipper Syntax?
What are the patterns of Exporting or
Importing .CSV and XML files?
What are the patterns of Exporting or
Importing files to/from Visual FoxPro?
In VISTA, I cannot drag and drop
files into the program?
I am a registered
user, if I upgrade with the new DEMO version , do I need to register again?
No
For all registered users, if you install the upgrade into the
original directory of previous installation of CmVodbx32. Even if upgrade stated that is a
DEMO version, registered users won't have a DEMO installed but a full registered working
version. Restrictions apply for major upgrades, you may have to pay a small fee. Go top
I am a registered
user, can I install my registered copy to an other drive or computer?
Yes, the software can be installed at the office, at home or
at customers sites. The limitation is a legal one. You cannot incorporate this program to
those you sale to your customers. You can use it at customers sites but it must be deleted
after use or you can leave it there but don't forget to delete the file
<cmVodbx32.lic>, the program will become a DEMO again.
Copy the installation program and the <cmVodbx32.lic>
file into a 1.68 floppy disk ( With version 4.xx, you can format a standard 1.44 to 1.68
MB floppy disk ). Run the installation program on an other computer, the
<cmVodbx32.lic> file will also be installed and you will get a registered version..
Go top
When I open the
Windows-Explorer and I choose a DBF file with the double click, the program starts and I
have an error message : Error opening database, wrong memo, index, driver or file is used
by an other user.
The program use the default RDD to open the DBF files. For
example if the default is set to DBFCDX and you have a memo field (.dbt file which is the
default extension of NTX and MDX driver), it will give an error. Also if the default is
exclusive files and you try to open and other instance of the same file, you will also get
an error. In this case change the default driver into the program. Go
top
I cannot replace
the value of a field record when I use the replace function of the program and when I
enter only a string value. Do you have a work around?
Yes, (but it is a standard behavior) in the <With> part
of the dialog enter -> "My string to replace"
with the quotes
For logic value enter -> .t. or .f. for
the values of TRUE or FALSE
For numeric value enter -> 666 or number
without quotes. ( Note: For countries that use
"," coma as decimal separator, you must enter the "." dot separator.
This a the limitation of the macro compiler. However you will still view the result as the
"," comma separator in your browser view)
. Go top
Can I use my own UDF
(User Define Functions) with the programs?
Yes, You can create your own UDF-DLL.DLL file. Download the
file UDF-DLL.zip file
as a sample to see how to create it. Go top
In
VISTA, how can I remove the annoying UAC ( User Access Control ) prompt window,
even if I am an administrator.
This program requires to be run as administrator.
In Vista you can disable the UAC ( User Access
Control ) from your Control Panel in the Account folder. However, this will
disable this option for your whole machine, including the normal users that do
not have administrator rights.
You can disable this prompt window for
administrators only by
changing the following HKEY_LOCAL_MACHINE with the RegEdit.exe program ( this
change requires that RegEdit to be run as administrator ) :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
The value of "ConsentPromptBehaviorAdmin" must be 0 ( zero ).
Value 0 = No prompt at all.
Value 1 = Prompt that requires to enter an administrator password ( even if you
are an administrator ).
Value 2 = ( Default ). Prompt that requires an acceptance only.. Go top
My UDF-DLL.dll file
causes the program to crash. If I remove it from my program directory, everything is fine?Download new version of the UDF-DLL.zip file dated 2000/11/25
or later.
When I set
relations, how can I see only link data or Set Selective Relation?
As examples:
________________________________
Shell Option dialog = SetSelectiveRelation OFF
Create and open 2 DBF's named CDX1 in area 1 and CDX2 in area 2 with an
index on "FIRST" field in area 2
Set the relation from CDX1 to CDX2 on the FIRST field.
To see only link data use this method:
On CDX1 set
filter: .not. 2->(eof())
To simulate the Set Selective relation:
On CDX2 set
filter: FIRST= 1->FIRST
________________________________________
Shell Option dialog =
SetSelectiveRelation ON
Most of the above is done automatically.
Warning:
Any attempt to make a relation back to the parent database will cause a
crash and end the program. This error is so low in RDD code that it
cannot be trapped.
How can I go
through all marked records, in large databases, it's hard to manipulate?
Press F4, click the checked box [ Marked record only ] and
use the slide bar or right or left key.
Go top
How
can I replace Fields in Parent with Data from the Child Table like the old Clipper Syntax?.
Ex:- REPL NAME WITH CHILD->NAME
First from the option dialog, you set the set
selective relation to "OFF"
Second you set the relation to the child dbf ( with an index "on" )
From the parent dbf , you call the utility dialog, and click on the replace button. Than
choose the field and from the other expression dialog and insert 2-> last
( you use the area number, instead of the "DBF NAME ->" expression.)
With ("BY") 2-> last , all field records not in child dbf will be empty
Before calling the last dialog, set the "FOR" condition 2->(eof() != .T. )
and the last dialog "BY" 2->LAST
In this last case, only field records with relation will be replaced.
Go top
What are the patterns of Exporting or Importing .CSV and XML files?
XML - Export and Import
Depends on fields selection. Default is all. Ex:
<?xml version="1.0"
encoding="ISO-8859-1"?>
<RECORDS generated="20051113T08:58:24">
<RECORD record="1">
<FIRST>Randy;zz;</FIRST>
<LAST>"Esposito",esposito</LAST>
...
</RECORD>
...
</RECORDS>
Notes: Date fields are in string format
2005-11-22 = 20051122
Logic
fields are in string format .F. = 0 and .T. = 1
Memo Array and Object fields are
irrelevant and will show an equivalent string without content.
CSV - Export and import ( EXCEL )
Depends on fields selection. Default is all. Ex:
FIRST;LAST;STREET;CITY;STATE;HIREDDATE;MARRIED;AGE;SALARY;NOTES
"Randy;zz;";"""Esposito"",esposito";"3900
;Peachtree ;Street N E";Bayside;NE;1970-10-03;0;55;147418.79;"This is
MEMO
Record no:1"
Notes: Date fields are in the string format,
the same as your file explorer.
Logic
fields are in string format .F. = 0 and .T. = 1
Memo Array and Object fields are
irrelevant and will show an equivalent string without content.
The First line will display field
names.
The field delimiter is the ' ; '
character.
CSV - Export and import ( Access and Sql )
Does not depends on fields selection. All fields must match the sequence. Ex:
Randy;zz;,"""Esposito"",esposito",3900 ;Peachtree ;Street N
E,Bayside,NE,1970-10-03,0,55,147418.79,"This is
MEMO
Record no:1"
Notes: Date fields are in the string format,
the same as your file explorer.
Logic
fields are in string format .F. = 0 and .T. = 1
Memo Array and Object fields are
irrelevant and will show an equivalent string without content.
The First line will NOT
display field names.
The field delimiter is the ' , '
character.
Go top
What
are the patterns of Exporting or Importing to/from Visual FoxPro?
Visual FoxPro conversion to FoxPro 2.5
Fields we convert:
Ref:
http://msdn2.microsoft.com/en-us/library/Aa975386(VS.71).aspx
Field type:
C - Character
Y - Currency
N - Numeric
F - Float
D - Date
T - DateTime
B - Double
I - Integer
L - Logical
M - Memo + Memo (binary)
0 - Null Field , for old type VFP
Fields we DO NOT convert ( those fields are skipped ):
G - General
General = The most common use for General fields is to store graphics. A General field is
a specialized Memo field. FoxPro stores a General field in the same .FPT file used by
other Memo fields in the table, but you cannot use it the same way. It is primarily used
to store references to bound OLE objects
C - Character (binary)
P - Picture
How the conversion is done:
0 -> N , 1 , 0
T -> C , 19 , 0 (format "2003-11-03 18:52:12")
I -> N , 11 , 0 (max 10 characters + the sign "-" (minus))
B -> N , 18 , x ( x = existing number of decimals)
M -> M , 10 , 0 ( see note )
Y -> N , 18 , 2
F -> N , y , x ( x = existing number of decimals, y = existing length of field)
All others stay the same
Note: For memo size block, VPF has default of 64 bytes, therefore the conversion will
leave it that way. Your new xxx_F25.fpt file will have 64 bytes memo block. If you want to
convert this to the normal FP25 32 bytes block size, then use my software
"cmVodbx32", AFTER the conversion.
The Exported File is: xxxxx.FP25.dbf
FoxPro 2.5,Clipper,DBaseIV,all+.dbv memo conversion to Visual FoxPro
Fields we convert:
Field type:
C - Character
N - Numeric
F - Float
D - Date
L - Logical
M - Memo + Memo (binary)
Fields we DO NOT convert ( those fields are skipped ):
O - Object field
How the conversion is done:
M - M , 4 , 0 (From 10 bytes to 4 bytes ... see note1 )
All others stay the same
Note1: For memo size block, PF25 has default of 32 bytes, therefore the conversion will
leave it that way. Your new xxx_VFP.fpt file will have 32 bytes memo block. If you want to
convert this to the normal VFP 64 bytes block size, then use my software
"cmVodbx32", BEFORE the conversion. For Clipper NTX, DBaseIV dbf's,
the memo fields are skipped.
The Exported file is: xxxxx.VFP.dbf Go top
In VISTA, I cannot drag and drop files
into the program?
Since this program must be run as administrator, when the UAC ( User Account
Control ) is on, then the file explorer must also be opened as administrator
Ref: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=736086&SiteID=1
Go top
|
