Very basic question: getting data from dialog components into a table

[robp]

I've made a number of Grids and linked them with great success, but I cannot figure out how to get data from a page made up of Dialog components to submit to a table in the Alpha 5 database I've created.

Am I correct in assuming there is no easy way, and I need to write a script? Where is the best place to start as far as learning the basics?

Thanks in advance... Rob

[NoeticCC]

Re: Very basic question: getting data from dialog components into a table

Have a look at the web application/server samples that come with Alpha 5, there's some dialog examples in there.

[robp]

Re: Very basic question: getting data from dialog components into a table

I've dug around in the example pages but many of the dialogs don't seem to have anything in the "after validate" area where I would expect to see the script to tranfer the data to a table? I've certainly seen nothing in any of the examples that appears to be writing any values to a table.

Does this action have to be scripted or is it a matter of selecting tables and fields somewhere just like setting up a grid?

[NoeticCC]

Re: Very basic question: getting data from dialog components into a table

I've dug around in the example pages but many of the dialogs don't seem to have anything in the "after validate" area where I would expect to see the script to tranfer the data to a table? I've certainly seen nothing in any of the examples that appears to be writing any values to a table.

Most processing seems to be done in the validate event...

Does this action have to be scripted or is it a matter of selecting tables and fields somewhere just like setting up a grid?

Scripting, unfortunately, but fairly easily - this is code for saving details of failed emails (if the sending fails from WAS) to a dedicated table:

'Now save to Email Failures table:
	t = table.open("[PathAlias.ADB_Path]\mail_failures.dbf",FILE_RW_SHARED)
	t.enter_begin()
	t.Date = Date()
	t.Time = Time()
	t.Sender = Sender
	t.Name = Name
	t.Email_to = Recipient
	t.Subject = Subject
	t.Message = Message
	
	t.enter_end(.t.)
	t.close()

[nicholascutting]

Re: Very basic question: getting data from dialog components into a table

I've dug around in the example pages but many of the dialogs don't seem to have anything in the "after validate" area where I would expect to see the script to tranfer the data to a table? I've certainly seen nothing in any of the examples that appears to be writing any values to a table.

Does this action have to be scripted or is it a matter of selecting tables and fields somewhere just like setting up a grid?

Hello Rob.
I recently made a similar enquiry, and received some great help from Forum Members.
If you give me some further details about your database fields etc, I could point you in the right direction.
Regards.
Nick.

[robp]

Re: Very basic question: getting data from dialog components into a table

Thanks for the feedback Nick,

I just need to get the values from a few simple Dialog elements into a cooresponding table.

I'll try and look you old post up for reference.

NoeticCC's example seems to show me the basics, I just need to dig into the syntax a bit I guess.

What are your thoughts on putting the script in the "validate" vs "after validate" section?

[NoeticCC]

Re: Very basic question: getting data from dialog components into a table

What are your thoughts on putting the script in the "validate" vs "after validate" section?

Btw, I do believe officially these things are done in the Aftervalidate event, it was just in some of the WAS examples I found that it was placed in the Validate event :)

[robp]

Re: Very basic question: getting data from dialog components into a table

OK... I used the script below in the "after validate" but can't get the date or hours fields in the database to show data entered in he dialog. I also got the following error first time around:

Errors in: event.AfterValidate code:
Data value cannot fit into a numeric field of size
t.hours subproperty cannot be assigned to

I made the fields in the table larger and this went away.

t = table.open("daily data",FILE_RW_SHARED)
t.enter_begin()
t.date = date
t.machine = machine
t.operator = operator
t.status_code = status_code
t.work_order = work_order
t.hours = hours

t.enter_end(.t.)
t.close()

[NoeticCC]

Re: Very basic question: getting data from dialog components into a table

OK... I used the script below in the "after validate" but can't get the date or hours fields in the database to show data entered in he dialog. I also got the following error first time around

Might the date thing be related to this? http://msgboard.alphasoftware.com/al...ad.php?t=71687

[Steve Workings]

Re: Very basic question: getting data from dialog components into a table

I haven't watched or studied all of these messages real closely, but let me remind:

Everything on the html page is character type. There are no numeric, date, time types.

So, when recording the variable values from a web page to a table, you need to be mindful of any necessary conversion.

In a typical situation, a couple lines might look like this:

:
t.MyDate = ctod(vDate)
t.MyNumber = val(vNumber)
if vLogicalValue = "True"
  t.MyLogicalValue = .t.
else
  t.MyLogicalValue = .f.
end if
:

The convert_type() function is also appealing, but I've found it best to use a function that is specific to the conversion type rather than the generic convert_type().