#1 Re: mORMot 1 » UpdateField function » 2011-09-26 16:42:45

Thanks for being so responsive! I have no idea how you are able to do this. I just hope that someone else of your caliber is able to get involved.

#2 Re: mORMot 1 » UpdateField function » 2011-09-26 12:55:06

The problem is that the FieldValue parameter is an integer value and not a RawUTF8

#3 mORMot 1 » UpdateField function » 2011-09-25 20:04:35

Replies: 5

I just downloaded the latest version of the framework. In my old version, the TSQLRestServerDB had the following function, which I used in my app:

function UpdateField(Table: TSQLRecordClass; ID: integer;
      const FieldName: shortstring; const FieldValue: RawUTF8): boolean; override;

In the most recent version that I downloaded, this function appears to have beenn changed to:

function UpdateField(Table: TSQLRecordClass; Where: integer;
      const FieldName: shortstring; FieldValue: integer; ByID: boolean): boolean; override;

Is there another function that I can call in the new version that works the same as the old one or should I abandon this approach to updating record values?

#4 mORMot 1 » Add a record to the TSQLTable Object » 2011-07-07 19:57:23

Replies: 1

I have a grid that I use to display thousands of records. I retrieve the records with a call such as cust:= TSQLCustomer.CreateAndFillPrepare(globalClient, ''). After I have retrieved the records and displayed in my grid, I would like to add a new record, but the problem is that I don't want to have to call .CreateAndFillPrepare after having added the new record to the database. I know that the records that are retrieved via the TSQLCustomer object are stored in the FillTable (TSQLTable). Is there anyway to add the new record to this table after the record has been successfully added to the database or is this perhaps the wrong approach?

#5 Re: mORMot 1 » CopyRecord » 2011-02-04 03:25:17

I was going to override the method because it did not copy blob fields.

#6 mORMot 1 » CopyRecord » 2011-01-30 13:02:22

Replies: 6

Would you mind making the CopyRecord method of the TSQLRecord virtual so that i can override it?

#7 mORMot 1 » Database compatibility » 2011-01-29 14:37:17

Replies: 1

I've been using your framework and its been going great. I know that you planned to make it compatible with some other database engines aside from SQLite. How is that work coming along? Do we have anything to look forward to soon?

#8 Re: mORMot 1 » Overall RTTI usage » 2011-01-05 03:03:39

Thanks - This is great. I extended my TSQLRecord class with two methods GetFieldValue and SetFieldValue, which simplifies my life a lot when I set and receive  values from a data grid that I create on the fly.

#9 Re: mORMot 1 » Overall RTTI usage » 2011-01-04 14:42:05

Is there anyway that RTTI can be built into the TSQLRecord class so that it is easy to extract Field Types and Field Values? (Perhaps it is and I failed to see it). For example, it would be nice to be able to pass a field index and get field value in return.

#10 Re: mORMot 1 » Aggregate function » 2010-12-18 02:28:48

You were right ->>>> (Perhaps you didn't declare it as cdecl (the USEC compiler define is private to SQLite3.pas).)

#11 Re: mORMot 1 » Aggregate function » 2010-12-17 03:51:45

For some reason I'm not able to create my own aggregate function when I implement it outside the SQLite3 unit. I get an error complaining about some of the arguments that I'm passing in the sqlite3_create_function_v2 (even if they are identical to the samples that you provide in the SQLite unit.). However, when I bring my function into the SQLite3 unit, everything is ok. Do you know why?

#12 Re: mORMot 1 » Aggregate function » 2010-12-17 03:40:16

Thanks! Would you mind implementing the following function:


This function allows me to determine if the value is numeric or not.

#13 mORMot 1 » Aggregate function » 2010-12-16 02:07:01

Replies: 7

Thanks a lot for a great framework. Could you please demonstrate how to implement a custom aggregate function (e.g. combining strings, calculating stats etc).

#14 Re: mORMot 1 » SQLite3 Framework Indexes » 2010-12-12 02:14:31

I did override InitializeTable and the field argument was always empty string and it was only called once (not once for every field in the table). Also the CreateSQLIndex method of the server only accepts 1 field. It would be nice if it was an array.

#15 Re: mORMot 1 » Demos » 2010-11-28 21:39:50

For example, how should I use the TSQLTable object. Should I be using it to create, update and delete records? Should I use it to store records before I do a batch update? Should I be using the NewRecord method of the Table object?

#16 mORMot 1 » Demos » 2010-11-26 19:03:41

Replies: 3

I'm interested in understanding this framework, but it is hard with these demos.

#17 mORMot 1 » modify table structure » 2010-11-26 18:09:04

Replies: 1

How do I modify model / database? For example, how do I add a new field to a table?

Board footer

Powered by FluxBB