Copyright © 1996-2017 Rayonline.com- All Rights Reserved
CmVodbx32 FAQ

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?

What means [registrations per users basis]?

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, if you own a portable version, which can be run everywhere.
No, if you own a single or 5 registrations users. Those registrations are per users basis.
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.
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. Go top

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. Go top

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>&quot;Esposito&quot;,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" with Modify Structure, 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, FP25 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", with Modify Structure, BEFORE the conversion. For Clipper NTX, DBaseIV  dbf's, the memo fields (.DBT files) are skipped.


The Exported file is: xxxxx.VFP.dbf   Go top

What is registration per user basis?

It is a generated ID from Current Computer Name, Current User Name and Network Station Name.
Any changes into the above names will require a new registration license. 
Go top
Copyright © 1996-2017 Rayonline.com- All Rights Reserved