Kevin,

So you need to scroll to some record in a TableView?

Re: #53
So TableCursor gets the focus to a particular table and this.uuid further focuses the action to a particular record or records. I surmise you do not have to actually name the table (this.table.getCursor) nor do you need to specify the record(s). It seems the statement this.table.getTableCursor( this.uuid ); merely alerts the program/script that it is to perform some action on the current record.
Does the TableCursor have to be called or reset before using it? What if it is used again for a different record?

Re:#54
In 9.7, unfortunately, no, but we removed coloring in the latest versions.
OK, I can live with the color on these prototype Forms. I will be upgrading, but I am still on my MacMini. Rusian set it up so I could use this ProSerial for 30 days to work with Forms to see if I could put together a replacement for FileMaker. I plan to move to LinuxMint and get StudioPro for that system.

An empty string is a string with no characters, also it is necessary to use the value property for assignment:
records.getField( 'Debit' ).value = "";
I am starting to see certain tools reused. That is good. I note this statement is almost the same as the one you gave me to set up my pre-fill buttons. The pre-fill buttons statement was this.records.getField( 'Name' ).value = 'KROGER'; and this one drops the "this." before "records." Does "this" limit the statement to one particular record while the one without can deal with multiple records?

Re: #55 & 56
Exactly what I needed. Will give it a try today

Is it possible to respond to each post individually, but I couldn’t figure out how to click somewhere around the Comment box to do so? Which would you two prefer - individual comments to a particular post or periodic comments to multiple posts?

Sergey,

Go to ... I was trying to create a script based on what Joe wanted. Joe was starting at a TableView. Would see a record he wanted to open in formLayout. So I created a button on the TableView and entered the go to script. I like starting at the basics before adding complexity. I figured it would automatically scroll to the record. It is OK it doesn't because that wasn't what Joe wanted it for. He wanted to see a record, enter the record number, and click on a button and go to that record in a different form. I initially had the variable line above the Import. Assign record number entered into box to variable, import form, go to record using the variable. That didn't work. Remove complexity of the variable and hard code a record number to see if that even works. It did not. The formLayout opens, but opens at the first record. No errors.


Kevin

Joe,

Does the TableCursor have to be called or reset before using it? What if it is used again for a different record?

TableCursor is just the "records" of the table.
When we click prev/next buttons we use the same TableCursor, just the current position is switched.
So it is really used for multiple records.

records = this.table.getTableCursor( this.uuid ) is equivalent to
records = this.records

so usually it is enough to write this.records and the form gets cursor on its own.

We don't specify the table name as it was defined during the form creation or later using the Records combo box in the top-right corner of the Form Editor area.

Does "this" limit the statement to one particular record while the one without can deal with multiple records?

A current record is always modified, that is not because of this.
We can use "records" without "this" because previously we assigned TableCursor to this variable.

Is it possible to respond to each post individually, but I couldn’t figure out how to click somewhere around the Comment box to do so? Which would you two prefer - individual comments to a particular post or periodic comments to multiple posts?

It is possible with the "Add Comment" button, but it seems not convenient for long answers, so let's keep as it is.

Kevin,

Ok, thank you, I think I understood.
So the task is to open a columnar form at a specified position.

Here's how to open a form with a specified record.

1) Create method in the child form, e.g. show_record, with code:

this.records.position = arguments[0];

It assigns the first argument to the cursor position

2) Call this method in a parent form after import:

import '/city_detail' as dlg

dlg.show_record( 5 );

dlg.exec();

Sergey and Kevin

I was working this afternoon on Clearing the form by inserting NULL or an empty string.

I tried two scripts for my CLEAR button and each of them returned an error message:

Transactions - Form::clicked:3: SyntaxError: Expected token `)'

The two scripts were:

records = this.table.getTableCursor( this.uuid );
records.getField( ‘Date’ ).isNull = true;
records.getField( ‘RefNo ).isNull = true;
records.getField( ‘Name’ ).isNull = true;
records.getField( ‘Amount’ ).isNull = true;
records.getField( 'Debit' ).isNull = true;
records.getField( 'Credit' ).isNull = true;
records.getField( 'Stmt' ).isNull = true;
records.getField( 'Comment' ).isNull = true;
records.updateRecord();


records = this.table.getTableCursor( this.uuid );
records.getField( 'Date’ ).value = "";
records.getField( ‘RefNo’ ).value = "";
records.getField( ‘Name’ ).value = "";
records.getField( ‘Amount’ ).value = "";
records.getField( 'Debit' ).value = "";
records.getField( ‘Credit’ ).value = "";
records.getField( ‘Stmt’ ).value = "";
records.getField( ‘Comment’ ).value = "";
records.updateRecord();

I will attach a copy of the form.

You can see I was also trying to make the GoTo button work but I couldn’t, gave up, and moved on. I haven’t had a lot of time today.

Joe

Pardon me. As I was closing I think I see what happened. Once again smart quotes snuck in. I had opened another editor and forgot to disable the smart quotes.

Sergey & Kevin,

I opened Lesson 6 on filtering (roducts:vstudio:tutorials:forms:lesson6" target="_blank" rel="nofollow">http://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentinaroducts:vstudio:tutorials:forms:lesson6) and read through it. It seemed above my level of competence.

I dropped back to Lesson 5 (roducts:vstudio:tutorials:forms:lesson5" target="_blank" rel="nofollow">http://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentinaroducts:vstudio:tutorials:forms:lesson5) on Simple Filtering and it seemed more on my ability level, so I gave it a shot.

I left the Line Edit box in place and simply changed the name showing (I don't really understand what this type of button does, so I am using it as a de-facto label. I then went to Database>Tables>Transactions>TransNo and pulled that field onto my form. I followed the directions and changed its Data Mode to Filter and Apply. I saved and executed. It works like a charm. Any TransNo I enter will immediately show in the form. I can enter new ones one after the other and they will pop up. That is great.

BUT PROBLEM - I cannot use the other navigation buttons |< < > >|. The other buttons Update, Clear, etc. work - even the Kroger button. I have to Close the form and re-Execute to be able to use the navigation buttons again

Yes, this is because filtering changes the set of shown records.
You can clear a filter with a button.

But the only way to implement "Go To" functionality exactly as you described is in reply #55
It is just one or two lines of code

Sergey,

>"Go To" functionality

Wow. Thanks.

rn = parseInt( this.RecordNumber.text ) - 1;

import '/frm_Transactions_Main' as dlg

dlg.gotoRecord( rn );

dlg.exec();

On the TableView, I have a LineEdit not associated with a field named RecordNumber. In TableView, one sees row numbers and that is what probably one will enter into the LineEdit, thus the subtraction of 1 (Sergey had previously written: "(record numbers are 0-based)". Assign to a variable.

It works.

Again, thank you for your assistance.

Kevin

Sergey
Re: #55 & #66

I have gone back to Tutorial 6 and implemented it as set out, but I keep getting an error message: [clicked] ReferenceError: leSearch is not defined

Here are the screen shots. I added the new Horizontal BoxLayout directly below the form.

Joe

Joe,

I have attempted this lesson yet, but looking at the code and the error message ...

I think this:

var search = leSearch.text;

Should be this:
var search = this.leSearch.text;

The other thing it might be is I (capital i) vs l (small L) ... the field name and the code might contain different characters.

Kevin

Wish there was a way to view a post before posting or an edit. (Maybe there is and I don't see it.)

The edits:

I haven't attempted this lesson yet, but looking at the code and the error message ...

I think this:

var search = leSearch.text;

Should be this:

var search = this.leSearch.text;

The other thing it might be is I (capital i) vs l (small L) ... the field name and the code might contain different characters.

Kevin,

I tried: var search = this.leSearch.text;
I got another error message: [clicked] TypeError: Value is undefined and could not be converted to an object

I also went back and made sure the Properties>Name of the line edit box was leSearch with an "l" (lower case L). I did the same in the script for the button.

Joe

Sergey
Re: #56

If you declare a field like that (without AUTO_INCREMENT):
...
TransNo INTEGER PRIMARY KEY
...
TransNo becomes an alias for ROWID, and therefore auto-incremented.
Each inserted row gets TransNo=max(TransNo)+1;
So if the new record is deleted, its TransNo will be used for the next INSERT.


I did this for my TransNo field. I turned off AUTO_INCREMENT. Now if I delete a record, even if I have Updated it, the TransNo for the next Add is the last TransNo used +1. Such a simple solution. Thanks.

Joe

Kevin & Joe,

Yes, this.leSearch is a correct form (this was optional previously).
I'll revisit this example now.

Sergey,

Is there a way to display the variable values as the code works it way through? Or some code that creates a pop up with the variable value?

When I see this:

var condition = '"' + fldName + '"' + this.cbCriteria.currentText + "'" + search + "'";

I am thinking the final result will be:

"Name"LIKE'Kroger'

I don't see any spaces being built in. Or is that what is occurring upstream with all the replace code.

Kevin

Kevin,

Right, it generates it like this, and SQLite and Valentina support such a query.

Popup can be found in the Standard Dialogs->Information template
QMessageBox.information( 'Title', condition );

Also, we can print to console (but it is necessary to open it beforehand):
console.log( condition );

I got the complex filter working here. Did update leSearch. And I put in spaces between the field and operator and search term. I had one typo that was breaking things.

Joe, looking through your screen prints again ... I see you have the discard filter named tb_ ... but in the code there isn't an underscore.

Sergey, thanks for the info regarding the QMessageBox and console.