Multiple instances of 4D Server v17

Does anyone have experience of this type of situation? I have 3 copies of 4D Server v17 running on a Mac serving say database1, database2 & database3. I have a 2 user license for 4D server so can connect client1 to database1 and client2 to database1. When I try to connect client1 to database2 I

Re: Import mysql dump into 4D v15, build database structure & import data

Hi Narinder I have found that the SQL EXECUTE SCRIPT command will import records into a pre-existing database structure. So INSERT INTO `nmiep_action_logs` (`id`, `message_language_key`, `message`, `log_date`, `extension`, `user_id`, `item_id`, `ip_address`) VALUES (1,

Import mysql dump into 4D v15, build database structure & import data

In 4D v15 there is an SQL EXPORT DATABASE command which exports the database as an SQL dump file. Is there an equivalent function to import an SQL dump file, create the database structure in 4D, and import the data into it? ie the equivalent of the import function in phpmyadmin? Or does anybody

Re: STARTTLS - send secure email 4D v15.5

Hello Keisuke Thank you for your clarification. You imply that the only way to request a secure TLS connection is by using "0" and hope that the server requests a switch to SSL. How is it possible to tell that the email was sent securely? Is it possible to ensure that the email is ONLY sent if

RE: STARTTLS - send secure email 4D v15.5

Hello Mike Many thanks for your code. I wonder, have you ever used it with: $error:=SMTP_Send ($smtp_id;1) // to force use of ssl? It's when I do this that I get the timeout error and no send. Michael Jarosz -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

STARTTLS - send secure email 4D v15.5

Has anybody successfully used 4D to send secure emails via STARTTLS & a Microsoft Exchange/Office365 mailbox? I am trying to do this using 4D 15.5 and this code from the docs, but if I pass 1 in the SMTP_Send parameter I get error "10064 - no response has been received within the timeout period",

Re: Restricting a query

Many thanks Chip This is a really simple solution and works like a dream! Regards Michael Jarosz -- View this message in context: http://4d.1045681.n5.nabble.com/Restricting-a-query-tp5753437p5753463.html Sent from the 4D Tech mailing list archive at Nabble.com.

Restricting a query

I have a table which contains records for 10 different clients. I'd like to give a client the ability to search the table for only his records and not be able to see any of the other clients' records. Is it possible to do this using the standard 4D Query editor by always applying an additional

Which 4D version is a data/structure file?

Is there an easy way of identifying which version of 4D was used to create a data or structure file? I am thinking here of when you receive a demo 4D database and you want to know which version of 4D to use to open it with. This could be any version between 2004 and v16, and I want to avoid

4D hosting & NHS Information Governance

We are building a 4D app that will collect data from patients in the UK and send it to their Doctor. We therefore need to handle the data safely and securely and fully comply with NHS Information Governance guidelines. I wondered if anyone has gone down this road before and could give me some