Submitting a new record generates new records in another table

[Skeith]

A particular part of my alpha project handles task management. I have one dbf table with project information and another with individual tasks assigned to those projects. Every project created will need the same five tasks. Is there a "simple" action javascript that when a new project is created, the 5 tasks are created as new records in the tasks table?

[Steviev]

Re: Submitting a new record generates new records in another table

Hi Shane..

I would just attach an Xbasic Enter new record command to the Save button for the project..

[Skeith]

Re: Submitting a new record generates new records in another table

Thanks Steve... When I use the xbasic genie to create the script I need It produces this:


'Open the table that you want to update...
dim tbl as p
tbl = table.open("jobduedateprojects",FILE_RW_SHARED)

tbl.enter_begin()
tbl.PROJECT_NA = "Test"
tbl.TASK = "Production"
tbl.enter_end(.t.)
tbl.close()

However when I insert this into the server-side xbasic of an onclick event I get the error:



It says it can't find the file but the table is definitely there and named correctly. Any idea where I screwed up?

[Steviev]

Re: Submitting a new record generates new records in another table

Hi Shane..

Your attachment won't open but the code looks right - but you may need to take the linking id field from the main table and insert this into the new record using a variable..

[Skeith]

Re: Submitting a new record generates new records in another table

Hi Shane..

Your attachment won't open but the code looks right - but you may need to take the linking id field from the main table and insert this into the new record using a variable..

So I have since been able to avoid the original error that was happening where it could not find the database by changing the name of the table I was trying to insert a record into. Apparently "jobduedateprojects" was too long. When I changed it to "projtasks" the script quit throwing errors and I was able to enter a new record.

The wall I am running into now is I need to pull the information in a text box from the current dialog as a variable and pass it to the xbasic code that is creating the new record. I have fought this for 2 days and have read everything I can find. Variables are slightly above my experience, but if I could find a close enough example I believe I could make it work.

The xbasic that is running correctly is:

dim tbl as p
tbl = table.open("c:\alphaweb\projtasks.dbf",FILE_RW_SHARED)

tbl.enter_begin()
tbl.PROJECT_NAME = convert_type(projnam,"Character")
tbl.TASK = "Production"
tbl.enter_end(.t.)
tbl.close()

with "projnam" as my variable, where should I define "var projnam = {dialog.object}.getValue("Project_Name")" so that the xbasic code picks it up? I have the xbasic firing with onclick of a button.

[GGandhi]

Re: Submitting a new record generates new records in another table

http://screencast.com/t/ntv8n4cn
take a look at this

few suggestions if I am permitted to.
you are on version12 with lots of goodies and eye candy.
consider sql backend.
you can do lots of things with that. yes I know you can upgrade later on.
but it won't be as good as you do from the beginning.
if for some reason you must use dbf, then it is your choice.

[Skeith]

Re: Submitting a new record generates new records in another table

Thank you Gandhi! That was exactly the type of example I needed. I was able to adjust the code accordingly and produce the records that I needed.