Pages: 1

#1 Re: mORMot 1 » Transfer Data (MSSQL) » 2015-01-30 09:51:16

Kais2000

Of course I am open for any better solution.
Is there any example for " directly connect from the client to the server, via HTTP, and use the local MSSQL database as storage on the server side" ?
Thank you very much!

#2 Re: mORMot 1 » Transfer Data (MSSQL) » 2015-01-29 14:01:05

Kais2000

Yes, thank you, the "just use ..." suggests a quick and easy implementation.

I aleady found

     AClient.Add()

and even better   

      AClient.BatchStart(TPerson);
      AClient.BatchAdd(APerson,true);
      AClient.BatchSend(Res);

I only found TSQLRestClient and TSQLRestServer, but I need to store the data in my local MSSQL Database.
So my question is:

- Should I use TSQLRestClientDB? And how do I connect ?

#3 mORMot 1 » Transfer Data (MSSQL) » 2015-01-28 10:27:22

Kais2000
Replies: 5

Hi, I am a newbie and I could need some help.
I would like to transfer data over the internet into identical MSSQL tables.
I can easily get data from the server like this:

    

...
   aModel   := DataModel;
   aClient  := TSQLHttpClientWinHTTP.Create(SERVER,SERVER_PORT,aModel);
   AMyTable := TMyTable.CreateAndFillPrepare(aClient,'ID>0');

   while AMyTable.FillOne do
     begin
    

     Memo1.Lines.Add( AMyTable.MyDataField );

     end;

    AMyTable.Free;
    aClient.Free;
    aModel.Free;
...

Now I would like to store the data on my Server.
My first thought was the "oldfashioned" way: 

...while AMyTable.FillOne do
     begin

     MyAdoQuery.SQL.Add('INSERT MyTable (MyDataField) Values( ' + AMyTable.MyDataField + ')')

     end;
   MyAdoQuery.ExecSQL;

My second thought:
mORMot is such a great piece of software architecture, they probably have impelemented this task in a much more elegant way.

Thank you for any hints /examples.

Pages: 1

Board footer

Powered by FluxBB