51 Reply by teco049

(20 replies, posted in General)

DriveSoft wrote:
teco049 wrote:

Perfect work.


Will the RC5 to string or Database problem be solved in the final version or should I use the workaround with converting and storing as Hex values?

Unfortunately no, I will try to solve this in the next release. Just no time in the moment.


No Problem.


Is there time for a "small" additional feature?
You have added the function "Code Folding" in the current version 3.6. For better using, is it possible to add a function "Collapse all"? When I review one function or procedure I collapse manually all unneded parts and have only the part expanded where I am working on it.


If it makes to much work - forget it.

Go to forum: General

52 Reply by teco049

(20 replies, posted in General)

Perfect work.


Will the RC5 to string or Database problem be solved in the final version or should I use the workaround with converting and storing as Hex values?

Go to forum: General

53 Reply by teco049

(5 replies, posted in General)

Dear Dmitry,


I have done some tests:


File encryption works so far.


Text encryption in a Memo field works, but if used to store in a database field or string variable it does not work. Please see attached, there are some test to show you the difference.


Encrypted string to hex: Solution found, but only if first encrypted in a Memo field. No solution if encrypted in a string variable.


Hope it helps you to find out what I have done wrong.


Target is that I convert the encrypted string to Base64 and store the Base64 in a Database. When reading I convert everything back.

Go to forum: General

54 Reply by teco049

(5 replies, posted in General)

Wow,


I am really impressed.

Asking for some new features and in less 24 hrs - here they are.

Absolutlely awesome.

Many, many thanks.


Edit:
There is a little bug: Please see attached. I have add some functions:

Database: A small part of the encrypted text is not correct in the database. Decryption fails if read from database. (Use the sample text, encrypt it, write it to database, read it back - text will be a little bit shorter, decrypt it and at the end some text is not correctly decrypted.)


Mime/Base64: To prevent these problems I have tried to encode it as Base64. But it does not work completely with UTF-8 Text. Any idea why?


HEX: Original Text is converted to Hex with xx Values. The encrypted text as xxxx Unicode Values. I have used an example from the Forum. Any idea how to update for encrypted unicode?


Thank you.


Just for the documentation in our company: How many rounds are you using? (RC5-w/r/b)

Every implementation is over the requested 120hrs. The information is only to make our statistik guru happy. smile


Thank you.

Go to forum: General

55 Topic by teco049

(5 replies, posted in General)

Hi,


I am planning a multi user Application for our production statistics.


Is it possible to get the MAC ID from a Network Adapter? I would like to use the MAC ID for identifying the single users and for automatic logon for restricted users. Using the Hard Disk ID would not work because its for production statistics and for security reasons some people have a better feeling for using the MAC ID.


Does somebody has an encryption source code I can use for encrypting data? XOR is not suitable/safe enough. Anything like RC4/Spritz, Rabbit or RC5? Datas are only important for around 120 hrs. After this time they are worthless, but should be encrypted/secured for this time.

Go to forum: General

56 Reply by teco049

(12 replies, posted in General)

I don't know your project, but I have found out on my projects that the SQLite Database could be slower on a network folder.


Depending on the SQL Statement Structure the Database is up to 10 times slower if the database is located on a network folder as if it is on a local folder.


A software business partner told me this could happen on some older versions of the SQLite engine. Normaly it could slow down only if you have more as 100.000 records in a folder.


Just my two cents...

Go to forum: General

57 Reply by teco049

(3 replies, posted in General)

Hi Dmitry,


Thank you for your information.


Can I backup via script a SQLite Database when 1-2 other users are connected or does I need to switch to MySQL?


Thank you.

Go to forum: General

58 Topic by teco049

(3 replies, posted in General)

Hi,


This morning I have got the information that all data, entered in out application, are lost. After checking the Softwarefolder I have found a fresh and empty sqlite.db file.


After using our nightly backup everything was back.


Two questions about this:
1) Anybody else how has had a replaced database?
2) When I use one of the backup-scipts here at the forum for SQLite - are they working on a multi user application when users active working on it (only 2-3 users)?


Application is written with MyVisualDatabase 3.5. Changes on the software are not done in the past 3 months.


Thank you.

Go to forum: General

59 Reply by teco049

(7 replies, posted in General)

Got it.

Go to forum: General

60 Reply by teco049

(7 replies, posted in General)

Resend to you just now.
Please let me know if you receive it. Otherwise I need to use an alternative Emailadress...

Go to forum: General

61 Reply by teco049

(7 replies, posted in General)

Dear Dmitry,
Please let me know if you have got my email some days ago with the project zip file.
For whatever reason our Email Provider is blocked by some Anti Spam engines and providers.
Thank you.
Best regards
Teco049

Go to forum: General

62 Reply by teco049

(5 replies, posted in General)

Thank you Dmitry.

Go to forum: General

63 Topic by teco049

(7 replies, posted in General)

Dear Dimity,


I have now a mostly stable situation to create the error message.


Problem: The application is strictly non public and can't be shared on the forum. Can you give me an email adress where I can send you the application and maybe an avi file (VLC Player with XVID Codec requried) with the steps to create the error? Application is in german language.


Thank you.

Go to forum: General

64 Reply by teco049

(5 replies, posted in General)

Dear Dimitry,

Thank you for the answers.


I will try to create the error message stable and reproducable. At the moment it comes occassionaly without a fixed situation.


Could you please so kind and create an option to enable the colapse symbol also with large scipts. Even it would slow down everything, sometimes it is usefull to have it slow but only one of the procedures open to prevent changes in wrong procedures by accident.


Thank you.

Go to forum: General

65 Reply by teco049

(6 replies, posted in General)

I estimate that is is looking for something to catch the keyboard buffer directly like the
cin
command from C++.


Getting directly the information what keys have been pressed on the keyboard to initiate an action regardsless which field has the focus and is active.

Go to forum: General

66 Reply by teco049

(2 replies, posted in Script)

Thank you.

Go to forum: Script

67 Topic by teco049

(2 replies, posted in Script)

Dear Dimitry,


I get the attached error Message from Version 3.4 on a SQL statement which I use to fill a table grid.

Rechnerverwaltung.RSoftware.sqlValue := ('select software.id,software.softwarename from software left outer join softwarerechner on software.id=softwarerechner.id_software where softwarerechner.id_rechner='+inttostr(rechnerid));

Table structure:
SOFTWARE:

isdictionary=0
_Softwarename=TEXT
_Erfassung=DATETIME
_LetzteAenderung=DATE
_Bemerkungen=TEXT
_Freeware=BOOLEAN
_Lizenziert=BOOLEAN
_Demo=BOOLEAN
_Eigenentwicklung=BOOLEAN
_Shareware=BOOLEAN
_Sonderlizenz=BOOLEAN
%CALC_LizenzenTotal=(select count(ID) from Lizenzen where lizenzen.id_Software ^equally^ software.ID)\r\n
%CALC_LizenzenBenutzt=(select count(ID) from SoftwareRechner where SoftwareRechner.id_Software ^equally^ software.ID)\r\n

RECHNER:

isdictionary=0
_Rechnername=TEXT
_IP=TEXT
_Bemerkung=TEXT
_Erfassung=DATETIME
_LetzteAenderung=DATE
_Subnet=TEXT
_Seriennummer=TEXT
_Server=BOOLEAN
_Workstation=BOOLEAN
_Firewall=BOOLEAN
_Router=BOOLEAN
_USV=BOOLEAN
_Webcam=BOOLEAN
_Drucker=BOOLEAN
_NAS=BOOLEAN
_Sonstiges=BOOLEAN
_Notebook=BOOLEAN

SOFTWARERECHNER:

isdictionary=0
>id_Rechner=Rechner
>id_Software=Software

Its for a n:n relation. One "Rechner" can have many "Software" and one "Software" can be installed on many "Rechner"
DB Browser for SQLite is working with this statement, but not MyVisualDatabase.
Any idea?


Complete project is in german language and can be send only to you by email. Its not a public application.

Go to forum: Script

68 Topic by teco049

(5 replies, posted in General)

Hi to all,


I have the problem, that sometimes when I select a line at a datagrid I get the error "Index out of bounds" but everything seems to work.
When I select the same line again, no errormessage comes.
Has anybody else this problem?


I use a lot of scripts because I need some test and other things in the background.
At the current application I have around 1000 lines and approx. 35% are still not done.


Is there any known limit in size for a scipt? The script.dcu has a size of 200kb, the scipt.pas a size of 47kb and the forms.xml is 319kb.


The scipt editor show normal a symbol to colape a procedure. At the large scipt this symbol is missing.


Any way to get it back? I have 45 procedures and not colapsing the procedures I am not currently editing makes it confusing to locate the current position in the bulk of procedures.


Thank you for help in advance.


Edit: I am using Version 3.4

Go to forum: General

69 Reply by teco049

(3 replies, posted in General)

My ideas - but maybe working only with scripting

Idea A:
- make all records read only and a button for enabling edit
- add a field to the table which will be used for indicating locked for edit
- add a timer for closing edit after a time. Just for the case that the software crashs

Idea B:
- add a field to the table which will be used for indicating locked for edit
- add a timer for closing edit after a time. Just for the case that the software crashs
- Create a script which fill the field with an edit status when a user starts to edit or - as alternative - when a user first views a record.
This would work more or less as a first come - first edit solution.

Go to forum: General

70 Reply by teco049

(3 replies, posted in Script)

prahousefamily wrote:

Check Database have or haven't

SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'DBName'

Create Database If Haven't

CREATE DATABASE IF NOT EXISTS 'DBName';

Input  datebase name  if want check  in 'DBName'

Works perfect with the internal SQLite.
But....
For connecting MySQL Server you need to have an exsting Database.
Only at design time you can create a new database.
I need this for connecting via script to MySQL.

Go to forum: Script

71 Topic by teco049

(3 replies, posted in Script)

Hi to all,
I haven't found a script solution how to connect to MySQL without opening a database.
It would be cool if it could be possible to connect to MySQL, checking if a database is existing and if not to create it. Would make it easier for end-users.
Any ideas?

Go to forum: Script

72 Topic by teco049

(1 replies, posted in General)

Hi Dimitry,
I have read on a advertising that it should be possible to convert a standart delphi application to a webapplication using the indy framework, inside RAD Studio.
Because MyVisualDatabase is based on Embarcadero Delphi - as you have written here at the forum - I would like to ask if there is a develpment plan to add the Indy framework or something similar to MVD.
It would be a huge advantage if it would be possible to create a webapplication this way.
Thank you.

Go to forum: General

73 Reply by teco049

(5 replies, posted in Script)

Sorry for "hacking" into this topic but how to connect MySql and Sqlite at the same time?
I have a database currently on Sqlite and want to move to to MySql.
Any option to connect both Types of Database in one application?
Thank you.

Go to forum: Script

74 Topic by teco049

(2 replies, posted in General)

Hi,
I have a little question.
For a software I have some table. Two of these tables have a n:m relation.
.
Example:
.
A) One person can work on many projects
B) One project can have many persons who are working on it
.
My question is, how can I create a tablegrid who shows me all projects a person is working for and when I click on a project at this table grid the person table grid should change and show all persons working on this project.
.
Early planing stage, no examples created yet because I do not know how to handle this question.
Thank you.

Go to forum: General

75 Reply by teco049

(3 replies, posted in SQL queries)

Dear Dimitry,
thank you for the information.
Does this work only for datasets or also for single values/variable?
The attached demo shows how to work with different datasets which means results of SQL Queries.
Thank you.

Go to forum: SQL queries