mORMot Open Source

longge007

Member

Registered: 2010-06-22

Posts: 107

Write a new example (how to use the TSQLManyRecord)

sir,
   do you have time to write a new example about how use the TSQLManyRecord. i make the project based on Client/Server,(httpClient and HttpServer).
Server Side have Realtime table(Memorytable) and historical table.
there are 3 Clients or more,and every Client Side only have one temporary table about 100 records and write individual 100 records to Server realtime table.Now
i don't know how to select all realtime records from Realtime table and store them into Historical table ,i want to store data every 3 seconds.

i don't know whether or not use the TSQLManyRecord Class,and if i can, how to build the system struct.now i am empty and confused with this.

table fields

 TSQLSampleRecord = class(TSQLRecord)
  private
    fDescription: RawUTF8;
    fName: RawUTF8;
    fWave: TSQLRawBlob;
    fTime: TTimeLog;//TDatetime;

  published
    property Description: RawUTF8 read fDescription write fDescription;
    property Name: RawUTF8 read fName write fName ;
    property Wave: TSQLRawBlob read fWave write fWave;//store Float array[0..2047]
    property Time: TTimeLog read fTime write fTime;,

  public
  function WaveAsstring(aClient: TSQLRestClientURI): RawUTF8;//web dev.
  end;

Can you give me some 'Crazy idea',:)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,225

Website

Re: Write a new example (how to use the TSQLManyRecord)

I don't have much time now for that.

But take a look at this thread: http://synopse.info/forum/viewtopic.php?id=164

There is already such a "Many to many" example, written by http://synopse.info/forum/profile.php?id=198], available at
http://code.google.com/p/synopse-sqlite-demo/

longge007

Member

Registered: 2010-06-22

Posts: 107

Re: Write a new example (how to use the TSQLManyRecord)

thanks a lot,