Re: [Database] Retrieving sql statement result

2010-04-28 Thread Marcello Bertoli
On 28/apr/2010, at 11.12, Sarah Reichelt wrote: If you check the result after your revExecuteSQL statement, it should contain the data you need. Hi Sarah, thank you for your answer. the result of revExecuteSql doesn't seem to contains the information the sql engine answers and I need to

[Database] Retrieving sql statement result

2010-04-27 Thread Marcello Bertoli
Hi all, I have a question about runrev database commands. Is there a way to get the result of a sql statement that doesn't retrieve data (is not a select)? For example: In a postgresql scenario I need to execute the statement: listen foo and I need to retrieve the result. It seems that the

Re: Datagrid sorting

2010-04-26 Thread Marcello Bertoli
On 23/apr/2010, at 21.46, Andre.Bisseret wrote: Actually, to do a multi-criteria sorting (here two criteria) one must sort firstly by the second criteria, then by the first one. So that one gets the names in alphabetical order inside each date. So a mixt of my two proposal seems to do the

Re: Datagrid sorting

2010-04-26 Thread Marcello Bertoli
On 26/apr/2010, at 15.13, Andre.Bisseret wrote: A while later, trying to comment it, I discovered that it was working without any wait as well!!! I must confess that I am unable to explain why. I must add that the data grid I am using for trials has only 9 rows (3 dates with 3 names

Re: Datagrid sorting

2010-04-26 Thread Marcello Bertoli
On 26/apr/2010, at 18.01, Trevor DeVore wrote: on SortDataGridColumn pColumn switch pColumn case invoice date SortDataByKey invoice date, ... SortDataByKey invoice number, ... HiliteAndStoreSortByColumn pColumn break default

Re: Datagrid sorting

2010-04-23 Thread Marcello Bertoli
Hi Andre, thanks again for your kind interest in solving this tricky issue. I tried your code but the result is the same. It automates the process of clicking on two column headers. What I would like to accomplish is different. I would like to sort with more than one criteria my datagrid rows

Re: Datagrid sorting

2010-04-22 Thread Marcello Bertoli
Hi Andre, thank you very much for your answer. I tried your code but it doesn't do the job. It is like pushing the column header of the datagrid two times (first the number one and the the date one). My data come from a sql base so I can (as Steven said) make the query do the work of the

Datagrid sorting

2010-04-21 Thread Marcello Bertoli
Hi all, I need to sort the lines of a datagrid with more than one criteria. For instance: The datagrid represents invoices with these columns: - invoice date - invoice number - invoice title When I click on the invoice date header I would like to sort the lines of the invoice datagrid first

Re: Cross-Platform encoding issues

2010-04-02 Thread Marcello Bertoli
Hi Devin, Thank you very much for your help. I'm working on the same project as Jacopo. The problem is that we need to filter only an occurrence of the euro character, not the whole field. The user can write in many situations the euro character where he wants, as many time he wants. Besides

Re: Datagrid edit cell question

2010-03-25 Thread Marcello Bertoli
Thanks Trevor for your help. the dgColumnIsEditable did the trick! Marcello On 24/mar/2010, at 20.37, Trevor DeVore wrote: On Mar 24, 2010, at 3:33 PM, Marcello Bertoli wrote: I have some questions about editing data directly inside datagrids. The scenario is a datagrid where the user

Datagrid edit cell question

2010-03-24 Thread Marcello Bertoli
Hi all, I have some questions about editing data directly inside datagrids. The scenario is a datagrid where the user can edit only certain columns. I've accomplished this turning off the allow text editing of the datagrid and allowing the text editing of the column I want in the mouseDoubleUp