Dataset Fields extra data types

sfxcc · Post by **sfxcc** » 17.05.2010, 22:26

Does Zeos DBO have suport for Dataset Fields, ADT etc.

If it doesnt have support does it will someday.

Can you add more datatypes to the zeos dbo.

like :

ftImagefile - To load automatic the image file .(not on DB but on a seperate dir).

ftDataset - To load a dataset a zquery or a ztable (dataset decendent)

ftAdt - DB grid have some extra functions to show adt types etc().

ftListCombo - (string but seperate by a char ex ';' for field combobox );

ftTableView - String For Table view definition can be a ex :(Componettostring - what ever we want to ).

ftEncryptString : String or bytes ( witch is encrypted automatic when written recrypted when readed form record ) ( encript function event(on encrypt and on decrypt) or encrypt string on property )

MyprogramsTable (FormName (string),Myform (ftTableView), mypassword (ftEncryptedString),myUserName (ftEncryptedString));

:thanks:

Post by **seawolf** » 17.05.2010, 22:58

ftImageFile .. why don't use blob field?
ftEncryptString .. depends on DB .. i.e. Mysql has a md5 function, FB has no support
ftDataset .. Zeos has a dataset support

sfxcc · Post by **sfxcc** » 18.05.2010, 15:10

ftImageFile - if we change db grid we can check for the ftImageFile get the image and ( Local or remote file) and draw it on the grid (I know u have a imagefield or blob field).
Some times needed for Local Image storage.

I know we have strings to store the path. But this identifies better the fields.

For aa:= 1 to field.count
begin
if field.fieldtype = ftImageFile then
begin
bmp.loadimage(field.asstring);
canvas.draw(bmp);
end;

end;

ftFilename - Samething but to identify is a filename.

FtDataSet - If u say it works is because it does work.

FtEncryptedString - As u say fb doesnt have a automatic field encrytion so when we do.

password.asString := 'ThisisMyPassword';

It uses a predefined key to encrypt or call

OnEncrypt(field,Value);
begin
- Mycode ---
- Value := My encrypedmethodreturnValue.
end;

ftXml - XML field type ...
ftHtml - Html page lie <html> [@A] </html> wher [@A] is replaceble for a give text ......
ftTag - For own tags ...

Being so it can be added functions that doesnt exist on the DB server but it works on any server cause is on the components.

For example local stored proc... who knows..

Useful Functions - who know some one have a great idea ....

If we send the fish some one can have great ideia ... any other sugestions .... ????

(just tring to help a bit ... ) I like this components ill keep using it real great ...

Post by **mdaems** » 26.05.2010, 21:54

I'm afraid these field types are a little to difficult for zeoslib as they don't just 'pump' the data from a query result field into a corresponding TDataset field but perfom actions on the data. For simple excrypting and decrypting it may be possible to implement this, when Delphi knows these types out-of-the-box. Then It may be possible to put the transformation code in the function TField/TDataset uses to retrieve the values from the zeoslib buffers.

Mark