mORMot Open Source

There you go [replace > with >= and < with <= ... I hope this will work]:

Baby := TSQLBaby.CreateAndFillPrepare( aClient, 'BirthDate>=? and BirthDate<=?',[DateTimeToSQL(StartOfTheDay(dt)),DateTimeToSQL(EndOfTheDay(dt))]);

You could try this:

Baby := TSQLBaby.CreateAndFillPrepare( aClient, 'BirthDate>? and BirthDate<?',[DateTimeToSQL(StartOfTheDay(dt)),DateTimeToSQL(EndOfTheDay(dt))]);

As the servers were running fine, no mORMot code updates were needed.
New features would require a restart naturally, but no new features were needed for these servers.
The servers were collecting climate data (temperature, RH, ...) in buildings.

Please try my version of your sources.

For me, these work ... ;-)

https://github.com/LongDirtyAnimAlf/moctes

With a fresh trunk (installed with fpcupdeluxe), the mORMot (TestSQL3.lpi) compiles and runs fine on my system (win10, 32bit).

Your latest commit works out-of-the-box on Android.
Thanks !

Just replace the code inside the function with this code (the old code):

function IdemPropNameUSameLen(P1,P2: PUTF8Char; P1P2Len: PtrInt): boolean;
{$ifdef PUREPASCAL}
var i,j: integer;
begin
  result := false;
  j := 0;
  for i := 1 to P1P2Len shr 2 do
    if (PCardinal(PtrInt(P1)+j)^ xor PCardinal(@P2[j])^) and $dfdfdfdf<>0 then
      exit else
      inc(j,4);
  for i := j to P1P2Len-1 do
    if (PByteArray(P1)^[i] xor ord(P2[i])) and $df<>0 then
      exit;
  result := true;
end;

Works for me 100%. I hope also for you !

The (very) hard way ... ;-)
E.g.:
    ndx := GlobalJSONCustomParsers.RecordSearch(aCustomRecordTypeName);
    __android_log_write(ANDROID_LOG_DEBUG,'mORMot CreateFromTypeName ndx: ',PChar(InttoString(ndx)));

So, adding lines that are visible in ADB.

Normally, I make a custom ShowError function that directs this inserted debug-info to a place where I can easily study it.
Than, I am able to easily compare CPU-OS systems. So, I compare expected output on working systems with non-working systems.
As I said, the hard way ... especially on Android !

With latest FPC, mORMot, LAMW, I experience exactly the same error !!

Edit:
With latest FPC, mORMot, LAMW, on arm linux (RPI3) , all goes well !!
So, no alignment issue as it seems.

You have to use 1.6.1c to install/update Lazarus !!
Only 1.6.1c will patch Lazarus to be suitable for wince.

Yep.
I guess there is little change that this patch will make it into Lazarus.
And, due to the reaction, I am not going after it.

However.
https://github.com/newpascal/fpcupdelux … ag/v1.6.1c
This release will patch Lazarus to enable building for wince.
(I do not know if you are on windows, but I can prepare other releases as well ... let me know if you are interested)

I just did (few minutes ago) a brand new trunk install, with x86_64 cross-compiler for Linux and mORMot on Win10 with fpcupdeluxe-x86_64-win64 V1.6.0q
I could not reproduce your problem.

What happens if you try to compile mORMot Sample 02 for both Windows as well as for Linux 64bit ?

NewPascal got updated few hours ago.
I just did an install (NewPascal + mORMot) through GIT (with fpcupdeluxe) and all works out of the box.

@warleyalex

>I'm not a lawyer, but for my taste this is far too near a
>copyright violation. Using this as a base for a library would definitely
>give bad publicity.

The above sounds bad.
Pas2js has been sponsored work AND has been open sourced. So, care is needed.

But I think that Lazarus integration is a very logical (and very much needed) next step.
And, as Ab already stated, pas2js + Lazarus + mORMot will be groundbreaking !

It would therefor be good to have full cooperation of Mattias and co already beforehand.
Would you mind asking him/them how he/they see a future integration of pas2js into Lazarus.

About your code.
As I do not have TMS, I cannot judge any potential copyright violation.
But again, we should not cause a fight about this. Much better to have a good start in full agreement with the pas2js team !!

My 2 cents.

Hi Ab,

This is a very welcome and very important feature !
This feature would also validate an announcement on the official Lazarus forum I think !!

For me, using a non-encrypted database has always been very tricky in case of client apps.

To prevent a long conversation and long posts, I would like to suggest that you share your code somewhere.
And also the output (or screen-dumps) of your compile-efforts.
That would make life easier (for me), and increases the changes that we can help you !

@triguinhu

Again, I need more info to be able to help you !
What Lazarus and FPC version. How did you install FPC/Lazarus/LAMW. What Android version is your target. What Android SDK/NDK/Ant are you using.

You take your time ... ;-)

But serious: you must give me more info (about the errors encountered) to allow me to be able to help you.

Hint:
Use fpcupdeluxe to install FPC trunk and Lazarus.
(mORMot needs recent FPC trunk)
Use fpcupdeluxe to install cross-compiler for Android.
Install LAMW. You could also use fpcupdeluxe for that: install module LAMW.
Of you go !!

FCreatedAt: TModTime; ---> FCreatedAt: TCreateTime;

What you ask for is not that easy ... ;-)
A good master-detail design with decoupling of logic and (Grid-)GUI (MVC) asks for considerable effort, even for an expert.

mORMot has a MVC example.
And a Grid.

Good !
Please be confident: much work has been done and will be done to keep FPC and the mORMot a perfect combo !

Well, at the moment, I have 0% knowledge of Docker, other than heard of it and a website visit.

However, there is always a way out with fpcupdeluxe:
a: first get the FPC/Laz-sources in a way convenient for you.
b: point fpcupdeluxe towards these sources and let it do its job.

http://forum.lazarus.freepascal.org/ind … 39133.html

You can use fpcupdeluxe to install only NewPascal FPC.
Then point CT towards this FPC.