new_x

Thank you for kind reply. Just to explain further. In fact I am required to develop a web service to put data into learning platform Moodle. The data (student ID, number etc.) should be read in GUI (edit boxes) or from a postgresql db and must be inserted into Moodle platform. I will look into DMVCFramework . thank you

I am trying to learn to write a Delphi REST Web Service program (both the server and the client side). Currently my platform is Delphi 11 Community Edition supporting Internet Direct (Indy) 10.6.20. I searched through the Internet have not found sample codes or explanations. All I found is some videos using DataSnap project but In delphi 11 I could not Find File->New->Other->Data Snap. The only option is “Soap Server Application”. If my current version of Delphi does not support REST, Could you then provide SOAP based (server and client) source code and explanation. Since I am newbie, could anyone share source code and explanations. Thanks in advance

Hi Peter, That is very nice to contact a person from Team-B, regards, and thank you for your comment.

Thank you Lajos, by the way for the second part of my question ("are all the codes/packages listed in GetIt safe to use") do you have any idea? Regards

Hi all, I planned to use AES encryption in a project. I searched and found that there are some packages available as third party available via GetIt. (No native support in Delphi for encryption/decryption). I returned to Delphi after several years (The last version I used was D7). My question is "Is every package listed in GetIt safe to use", the second question is "is there any package that you suggest" thank you in advance.

Thanks all of you for your comments.

As I stated above I am novice at using Delphi, At which point in code, I should call entrance_time.AsDateTime?

I am novice at using Delphi. How to assign that event? I am using FDConnection, FDQuery, DataSource and DBGrid, when querying the DB data, I am constructing SQL query statements (select * from ...) based on user input, then executing that SQL statements with FDQuery showing the result in the DBGrid. Which component does have that event? Thanks

I thought that I should store both enterance_time, exit_time values as Integer. Whenever a new record comes, I want to check if that new record's date time values falls into already stored records' date time values. This way it should be simple to compare date time values in Delphi am I right?

I am using FireDAC to handle a simple DB Program, I am using TFDConnection, TFDQuery and TDataSource and TDBGrid components to handle DB operations. It is a simple visitor recording DB application, visitor table is created as; 1- create table visitors (name nvarchar(30) not null COLLATE NOCASE, lastname nvarchar(30) not null COLLATE NOCASE, enterance_time integer not null, exit_time integer not null); 2- for the time record insertion into the table I used, DateTimeToUnix(Now()) values for the enterance_time and exit_time fields. But I do not know how to show normal date time string (like mm/dd/yyyy hh:mm:nn) in the DBGrid correponding fields when I want to list the records of the table to show to the user. So if I restate the problem "how can we display the date and time values in "mm/dd/yyyy format if the datetime value is stored in the Sqlite db as INTEGER" Regards,

Thank you for your replies. I decided to use FireDAC components and now there is no error. Best regards,

My Delphi version Delphi 11 CE, I tried to put breakpoints on the code. Just clicked on the blue dots on the left. But the Delphi behaved like there were no breakpoints when run. I put the breakpoints on the lines that the code had to call so I expected Delphi to stop at that breakpoints. But did not work. I also used Ctrl+D (formatter) but it did not make any change. Regards

I used the FireDAC and everything seemed to be okay now. Thanks for your kind replies. By the way there was not any logged event in windows event viewer (Windows -> Application logs) Best Regards,

I have been trying to build a DB program by using sqlite. I downloaded ‘sqlite-dll-win64-x64-3430200.zip’ from sqlite home page, this is the current sqlite db implementation for windows 64 bit. This zip file just contains a dll and def file. I also downloaded the 32 bit tools file of the sqlite db (sqlite-tools-win32-x86-3430200.zip) . from this zip file I use “sqlite3.exe” (which is 32 bit I think). I copied the sqlite dll file into my Delphi app folder. Then to create a db file, I used following command in command prompt; sqlite3.exe sample.db then I found the following VCL code obtained from embarcaderro site; In the design time the SQLConnection1’s driver property is set to ‘sqlite’ procedure TForm1.Button1Click(Sender: TObject); begin SQLConnection1.Params.Add(‘Database=sample.db’); try // Establish the connection. SQLConnection1.Connected := true; executeButton.Enabled := true; outputMemo.Text := ‘Connection established!’; except on E: EDatabaseError do ShowMessage(‘Exception raised with message’ + E.Message); end; end; If I compile the VCL app as 64 bit Windows Application, and run it and press the button1 then the code waits a little bit then the whole app closes. (Without giving any error message) But if compile the Delphi application as Win32 application everything goes as expected without any error. Connection is established successfully. Any idea, Best Regards,

I was shocked how I did that mistake. Thanks a million for your reply.