Hello,

Please consider to buy a license. You use the demo script for long time.

It is a shame I think.

Kind Regards,

Hello,

We have separated our products in different divisions – PHP and JavaScript developed and supported from gurrido.net and jqSuite for ASP.NET Webforms and jqSuite for ASP.NET MVC developed and supported from trirand .net from other side.

I think you should post your question here : http://www.trirand.net/forum/

or to the appropriate support – support at trirand dot net

Kind Regards,

Hello Kris,

Thank you for your recommendations and good words.

Now to the questions.

1. Actually the program (Guriddo jqGrid)  need to know when the user finish with update in order to perform the action of saving. This usually is marked with enter key. If you tell us another way how to do this we will be glad to implement it. Actually maybe is a good idea to have a possibility to define a custom saved key, but this is the same as using enter or tab key.
2. In cell edit when the user press enter the data is saved and the user stay on that cell. When a tab key (or shift tab) is pressed tha data is saved and the user is moved to the next editable cell. You can check this.
3. Yes this is possible. There is a undocumented grid property  restoreCellonFail. The default is true. If you set it to false you will get the described behavior. The only exception on this is that the dialog is not positioned next to the cell when a afterSubmitCell event is used, but this can be easy implemented as on user validation.

Kind Regards,

• This reply was modified 10 years, 6 months ago by tony.

Hello,

Please read it carefully.
Is this one row from the response (in the example)?
If this is the case, you may need to use jsonmap property in colModel.

By example in colMode you have set name = Privateering,

but in the response, this property has a value object with another properties = StartTime End Time and etc – which one should be displayed in the grid?

Please provide two or more rows from the response as described in the documentatuion link – rows property in reader.

Regards,

Hello,

Before to make any fix, could you please send us the server response, which causes the problem or give us a link to the problem?

Thank you.

Kind Regards,

Hello,

Please remove any echo and print_r commands.

You have in the code

Remove or comment this.
 
Kind Regards,

Hello,

Thanks for investigation.

I think that this is a partial solution. To implement more common solution we need to upercase the searched column. This way it is not needed to insert the data in the DB in uppercase format – (I refer your previous post).

Since this is a common problem we will publisha updated version which will implement some of your code and much more. You then will not need to insert data inthe DB.

We will notify you at end of this week with the updated code and instructions how to use.

Kind Regards,

Hello,

Do you have read the article that I point you. At the end of article we have:

Starting with Firebird 2.1.2 (or earlier, at least 2.1.2 is what the Release Notes seem to tell), you can use a new Case Insensitive Collation named UNICODE_CI for the UTF8 character set (Unicode).

So when your default character set is UTF8, your table declaration might look like this:

CREATE TABLE PERSONS (

1	CREATE TABLE PERSONS (

PERS_ID INTEGER NOT NULL PRIMARY KEY,

1	PERS_ID INTEGER NOT NULL PRIMARY KEY,

LAST_NAME VARCHAR(50) COLLATE UNICODE_CI, FIRST_NAME VARCHAR(50) COLLATE UNICODE_CI

1 2	LAST_NAME VARCHAR(50) COLLATE UNICODE_CI,   FIRST_NAME VARCHAR(50) COLLATE UNICODE_CI

);

1

);

Your Index is a regular index declaration without any specials:

CREATE INDEX IDX_PERSON_LASTNAME ON PERSONS (LAST_NAME);

1	CREATE INDEX IDX_PERSON_LASTNAME ON PERSONS (LAST_NAME);

And your search expressions need no UPPER or whatsoever:

SELECT * FROM PERSONS WHERE LAST_NAME = :SEARCH_STRING

1	SELECT * FROM PERSONS WHERE LAST_NAME = :SEARCH_STRING

That’s it.

• This reply was modified 10 years, 7 months ago by tony.