Pages: 1

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

ingoberg

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

ingoberg

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

ingoberg
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

ingoberg
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

ingoberg

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

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

ingoberg
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

ingoberg
Replies: 1

Hi,
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

ingoberg

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

ingoberg

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

ingoberg

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

ingoberg

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

ingoberg

Thanks! Would you mind implementing the following function:

sqlite3_value_numeric_type

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

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

ingoberg
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

ingoberg

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

ingoberg

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

ingoberg
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

ingoberg
Replies: 1

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

Pages: 1

Board footer

Powered by FluxBB