Red '; When it Should be Black.

[forskare]

The '; in red is supposed to be black yet Alpha insists on making it red which I think is supposed to mean there is an error in the code. When the code is run, I get an error message: Expected '.'.

Fn = �EVID NUM';

Perhaps the red is why I'm getting the error message but it should be good code because that is the format Alpha shows in the example. How do I get the '; to be black, thus signaling the code is good to go?

[Al Buchholz]

Re: Red '; When it Should be Black.

Are using a MAC?

The first single quote is � not '

[forskare]

Re: Red '; When it Should be Black.

No, Win 7 Home Premium. I use the same key to insert before and after. That is the way it inserts the ' marks.

What I' trying to do is to place a button in a column which when clicked, will copy the current row to the new row. This is the code Selwyn used to do this in his video based on v10. The only thing I changed is the column name and I'm only show here, the code for one column. The code for the other columns is the same except for the column name. This code works for Selwyn but not for me. I get an error message: Expected ','

Fn = �EVID NUM';
var val = {grid.Object}._getValue (�G', �fn�, {Grid.RowNumber});
{grid.Object}._setValue(�G',fn,-1, val);

[Lenny Forziati]

Re: Red '; When it Should be Black.

Ken, as Al pointed out, your code is using the wrong character for the single quote. Your code shows a backtick (`), which is at the top left of the keyboard, on the key to the left of the 1. The correct character to use is ', which is on the same key as the double quote ("), near the enter key. (Assuming a standard US English keyboard.)

If you use Word or a similar word processor instead of the Alpha Five code editor to write your code, it may be replacing the single quote with a backtick for you behind the scenes.

[forskare]

Re: Red '; When it Should be Black.

If you use Word or a similar word processor instead of the Alpha Five code editor to write your code, it may be replacing the single quite with a backtick for you behind the scenes.

Hi Lenny,

Yes, that is what happened. However, just deleting the` and replacing it with ' while in Alpha doesn't change anything. I had to delete the whole row and retype it. Actually, I deleted the entire code and retyped it using the Alpha place holders and Grid Methods. Now, it works. Well, almost works. Instead of copying the cell values, it puts the row number of the current record into each cell copied. So, if I copied row 10, the number 10 appears instead of the value.

This is the code:

fn = 'EVID_NUM';
var val = {grid.Object}.getValue('G',fn,{Grid.RowNumber});
{grid.Object}.setValue('G',fn,-1,{Grid.RowNumber});

Selwyn's example uses the {Grid.RowNumber} placeholder and that's what's giving the row number. In his example, it copies the cell value and not the row number. Is there a difference between v10 and v11 that's causing this? This is the link to Selwyn's video:

http://blog.alphasoftware.com/2010/0...to-create.html

[Jim Coltz]

Re: Red '; When it Should be Black.

Kenn,

var val = {grid.Object}.getValue('G',fn,{Grid.RowNumber});

says to get the value in the fn field of the current row number and put it into a variable called val.

Your next line

{grid.Object}.setValue('G',fn,-1,{Grid.RowNumber});

says to set the value of the fn field in the first new row (-1) to the value of {Grid.Rownumber}.

I think your second line should be

{grid.Object}.setValue('G',fn,-1,val);

[forskare]

Re: Red '; When it Should be Black.

That make sense. However, I got the code for that line from the example in the Grid Method link which says:

//Set value in 'LASTNAME' field from the Grid part, 'current row'.
//Note that field name must be uppercase.

{grid.object}.setValue('G','LASTNAME',{grid.rowNumber},'Smith');

That's why I included {grid.rownumber}. I replaced {grid.rownumber} with val and now it works. But, I get an error message telling me val is undefined. I don't know why it gives the error message as it does copy the current row properly. How can the val be undefined?

[Clipper87]

Re: Red '; When it Should be Black.

I don't think 'val' is a good choice to name a variable; it may be protected. Not sure but you could try some other variable name.

[forskare]

Re: Red '; When it Should be Black.

I don't think 'val' is a good choice to name a variable; it may be protected. Not sure but you could try some other variable name.

No, it's a good choice because Selwyn used it in his demo., See above link.

I did try other variable names and got the same results. I works but throws the error message that: 'val' is undefined. I'm thinking this is a bug because I don't understand why it would work if - val - is undefined. Is my logic correct? I've got 200+ records to enter and canceling the error message every time is a huge first class pain.

This is the code and I think it's the last line that throws the error message.

fn = 'EVID_NUM';
var val = {grid.Object}.getValue('G',fn,{Grid.RowNumber});
{grid.Object}.setValue('G',fn,-1,val);

[forskare]

Re: Red '; When it Should be Black.

Ahhhh HA!! I opened alphaSports and created an updatable grid based on the based on the Invoice Items table. I created the duplicate or copy code and ran the Working Preview. It worked like a charm. Since the code in my app was correct, I created a new grid and copied the code. It also worked as it should. Then, I simply deleted the problem grind and renamed my test grid.

I have no idea what the problem was but it is now solved. A big THANK YOU to those to responded with corrections needed and suggestions.