is this condition can be done using alpha five?

[Andiyanto Bun]

Hi everyone,

in desktop application this situation can be done easily, could this situation be done using alpha five for web-based, any example please?

let's say i have some field on the detail view:

Document ID : ...................
Document Date : __/__/____
Item ID : ...................
Item Description : ......................................
Price : ......................................

in desktop application i am using lost focus event on item ID to get Item description and price, the system will find the price which has still active.

[Rich Hartnett]

Re: is this condition can be done using alpha five?

I'm not sure I understand your question completely, but if you are asking if you can put those fields in a detail view to be filled in, the answer is yes, and very easily.

You could also put them in a regular grid, or a dialog.

The web components are very, very flexible.

[Andiyanto Bun]

Re: is this condition can be done using alpha five?

Hi Richard,

fyi: i am using mysql for the database.
in this matter i cannot use lookup on the detail view for field Item ID, because the price has the table for itself and has efective date.
what i am trying to do now is to put javascript on change event for detail view field ITEM ID, and put this below code :

var mydata=this.value;
{grid.Object}.ajaxCallback('G','1','myxb','',mydata);

i have difficulties on writing myxb function, how to do that?, how to pass Item ID value on the function?

function myxb as c (e as p)
dim cITEMID as c
dim cITEMDESCRIPTION as c
dim cPRICE as c

???? Question 1: how to put the value to cITEMID variable from Item ID field on the detail view ?

???? Question 2: how to fill Item Description field and Price field on the detail view from variable cITEMDESCRIPTION and variable cPRICE ?
end function

Thanks,
Andi

[Rich Hartnett]

Re: is this condition can be done using alpha five?

Oh okay. Unfortunately I'm not the one to help you then, as I do not use SQL. Everything I do is in .DBF tables.

Maybe someone much wiser than me can assist you.

Rich

[Andiyanto Bun]

Re: is this condition can be done using alpha five?

my question is not regarding the sql syntax, but rather than in the ajaxcallback function:

Question 1: how to move Item ID field value on the detail view to a variable let's say to cItemID ?
Question 2: how to move value from variable (let's say cPrice) to Price field on the detail view?

Andi

[peteconway]

Re: is this condition can be done using alpha five?

Everything I do is in .DBF tables.

Gee Rich - we are going to have to do something about that mate!

[Rich Hartnett]

Re: is this condition can be done using alpha five?

LOL, yeah I know Pete ......... one of these days I'll upgrade.

But honestly I've been using DBF tables for over 20 years and they have worked well for me. Most of my tables are small, (the largest one being about 30,000 records), and my applications run fast, so I haven't really been motivated to take on a whole new learning experience.

[Peter.Greulich]

Re: is this condition can be done using alpha five?

Question 1: how to move Item ID field value on the detail view to a variable let's say to cItemID ?

var ItemID = this.value;
{grid.Object}.ajaxCallback('G',1,'myxb','','mydata='+ItemID);

Then in your function you would have:

cItemID = e.mydata

Question 2: how to move value from variable (let's say cPrice) to Price field on the detail view?

In your callback's closing statement something like this:

myxb = "{grid.Object}.setValue(part,name,[row - omit for Search and Detail View]," + js_escape(cPRICE ) + ");"
End Function

[Andiyanto Bun]

Re: is this condition can be done using alpha five?

Thanks a lot peter, it works.

Regards,
Andi