0 votes

Dear all,

I would like to know what are all the letters in Datatype, Usage and EditStyle are used for, some on them I know, but for other I don't. And is there any combinations that are forbidden in Efficy ?

And most important are the EditStyle influencing the Full Search Method ? I ask that question because 2 fields in a customer database araise error when searching using the Full Search Method. Those 2 fields are of DATAYPE = I, Usage = R and EDITStyle = K .. I checked with standard fields with DataType = I and Usage = R and the only difference I saw was on Edit Style which was = L.
The issue is that those 2 fields are considered like "string fields" in the FullSearch Method.
PS : we are using Efficy 10 R7987

EditStyle I found in Effiy :
U = ?
P = ?
K = AlphaNumerical Lookup (I think)
M = Memo
C = Currency (I think)
J = Lookup with search (I think)
A = ?
E = Edit Box (I think)
L = Standard HTML Lookup
G = ?

DataType I found in Efficy:
H
I = Integer
D = Date
M = Memo
? = ???
A = Alphanumeric
B = Boolean
C = Currency (float)
T = ?
N = Numerical (float)
L = Lookup by Key (Integer)
S = Small Integer

Usage I found in Efficy:
EMPTY (' ') > ?
V = ?
R = Lookup by key (I think)
P = Virtual fields calling an SQL Function (I think)
K = Key of a table
Q = ?
C = Calculated : the calculation rule in RULETEXT column (I think)
L = Alphanumerical Lookup (I think)

Best Regards,
Stéphane RONCIN

asked in Database by (1.8k points)

1 Answer

+2 votes
Best answer

Ok I took sometimes to do all fields combination on my local computers ... here is the answsers:

EditStyles

DataTypes

Usages

answered by (1.8k points)
edited by
Good work, Stéphane ;)
It may help you to fill your doc:
USAGE:
CALCULATED = 'C'
INLINEPROC = 'Q'
LOOKUP = 'L'
LOOKUPBYREF = 'R'
PRIMARYKEY = 'K'
PROCEDURE = 'P'
VIRTUAL = 'V'
ENCRYPTED = 'E'
INLINESQL = 'S'
NORMAL = ' '

EDITSTYLE:
CHECKBOX = 'C'
EDITBOX = 'E'
EDITBOX URL = 'W'
GROUPBOX = 'G'
LABEL = 'A'
LOOKUP = 'L' // lookup values with free values
LOOKUP LIST = 'K' // lookup without free values
LOOKUP SEARCH = 'J' // lookup with search drop down
MEMO = 'M'
MULTIVALUE = 'U'
MULTIVALUE SEARCH = 'V'
PICTURE = 'P'
RADIOGROUP = 'R' // lookup shown as radio group
RICHEDIT = 'F'

TYPE:
ALPHANUM = 'A'
BLOB = 'B'
CHARACTER = 'H'
CURRENCY = 'C'
DATE = 'D'
DATETIME = 'T'
INTEGER = 'I'
INT64 = 'G'
LOGICAL = 'L'
MEMOTEXT = 'M'
NUMERIC = 'N'
SMALLINT = 'S' // not used
Thank you Anthony, I updated my answer by adding the new usages/datatypes/editstyles you gave me ;)
Usage 'S' will be used in Efficy 11 to increase DB performances (instead of using stored procedures) with USERS and FULLUSERS

DataType 'G' will be used in Efficy 11 for FILESIZE (because of new large files feature)

EditStyle 'F' is for RTF

Remark: you have typos: input type="texte" should be "text" ;)
1,173 questions
1,432 answers
1,726 comments
325 users