error on save data to table from dialog

[GoStern]

I have modified the standard invoice dialog form for my application. After following all the instruction on the videos, I still can not get the submit button to work. I get this error " parentnode is null or not an object" (see attached screen shot) I can not find any information on this in the documentation. I have created a test dialog with on attached table and this does not work either. Does anyone know what I am missing?

The function inserted into the submit button is: " ExecuteServerSideAction("Save Data::Save_Submitted_Data_to_Table_s_1") "

Thanks

error.JPG

[GGandhi]

Re: error on save data to table from dialog

hello

i do not know why it is not saving. i just tested and works as expected. so few questions.

are all the data bindings proper?
if you are using master, detail then all the tables are created properly and data bindings applied properly to all the fields?

since the executeserversideaction ends in 1 it looks like you have two functions defined the one 1 ending the newest. delete all the other functions leave this alone or delete this too and rebuild new function.
make sure all the data bindings are correct before doing the server side javascript.

[GoStern]

Re: error on save data to table from dialog

Hi Gandi,

Thanks for your comments. I think I found what the problem is. I am setting up an order entry dialog. The order number is auto increment, so I leave it blank. The line items for the order are a one to many link tied to the order table on the order number field. Since this is blank, I am getting the error when saving. How do I get the order number to update from the server side with the next order number in sequence? (I have a desktop system that has been working for 10 years - I am now trying to get portions of it on the web)

Gordon

[GGandhi]

Re: error on save data to table from dialog

hello

this is just a guess.
you have copied the dialog from the template and modified then created the tables to match your dialog definition. alphafive does not create tables properly. the linking field is not going to be correct. sure it does create auto increment primary fields in both tables, but it does not link the primary key from the order table to the detail table. so study your tables and see how they are done modify them to be proper.

the way i do, i create tables for my specifications and then create the dialog to match the tables and there is no problem.
the primary key is auto increment in both the master and the detail. you should not be entering the data into those fields, in fact you don't even need to see them.

if after checking the table definition, still you are not sure please post back i will post a video for you showing it indeed works well.

ps: check to see if the detail table created by alpha contains the primary key from the header table as foreign key, more than likely no. add that field then redesign the dialog all should work

[GoStern]

Re: error on save data to table from dialog

Hi Gandi,

Thanks again for you reply. I did not create tables, I used my existing tables from my desktop app to link to the fields on the template. I have also used a blank dialog to create a test order entry form from my fields, but got the same results. I have compared all settings to a sample dialog that came with Alpha5 and could not find any differences. When I use grids for entering an order, they work fine.

Gordon

[GGandhi]

Re: error on save data to table from dialog

here is my table definition

invoice header table:
invoice_header_id auto increment, numeric, primary key
rest of the fields

invoice detail table:
invoice_detail_id auto increment, numeric, primary key
invoice_header_id numeric (same length as the invoice header id)
rest of the fields

do your tables match the above?
i am using mysql as you can see in my signature, if you are using dbf the same technique will apply.

[GoStern]

Re: error on save data to table from dialog

Hi Gandi,

I set up a new dialog and I created the tables with the builder. Works fine. When I change the table name bindings to my old existing tables, this is when it stops working. How do I modify the the table links to use my old existing tables?

[GGandhi]

Re: error on save data to table from dialog

Works fine

progress!!

you could post your table definition here and i can look at it and suggest.
or this is how to do
start from scratch
build a new dialog put in all the fields from your header table and detail table. remember not to include the primary key from the header table twice ( the second time in the detail table)
then block out the repeating section in a container and frame.
add submit reset buttons
make the dialog look pretty
do the data binding and create table alias make sure all the fields are mapped
then do the server side events
test it you will be good to go.

if you are not satisfied then post your table
i will post a video
i will create the table first then do the dialog as the way you are doing.

[GoStern]

Re: error on save data to table from dialog

It works when I let Alpha generate the tables. The problem is when I change the data binding to my existing tables. that is when it does not work.

[GGandhi]

Re: error on save data to table from dialog

ok
here is a video from my tables using dialog and mysql tables
http://screencast.com/t/u0nqh7rFvOb7

ps: you can give you table details even if you make simple ones.

[GoStern]

Re: error on save data to table from dialog

Hi Gandi,

Thanks for all the time it took to make and post the video.

I have been trying many different ways to see if I can get this to work. I just set up a blank dialog and used two tables from my database that were simple without many records or fields. I linked them together on a random field and the dialog worked properly. So now I believe that there is some configuration of my order header table and/or line items table that is causing this problem. These are much larger and more complicated tables. The have multiple lookups and rules. Interesting that these tables worked fine when I tried to make an order entry form using grids - it worked, but was not as clean as using a dialog.

[GGandhi]

Re: error on save data to table from dialog

okay

i am sure you will figure that out.
if you need something don't hesitate to post back.

They have multiple lookups and rules.

looks like dbf. if you post the fields only i can see what needs to be adjusted if you want.

[GoStern]

Re: error on save data to table from dialog

Hi Gandi,

Thanks for your help. I found the answer on different post regarding problems with dialogs. It was also an answer you gave. You said it could be field rules that were causing a problem. I took out the date field on my invoice and it worked. I slowly added some other fields and linked items and they worked! I then added the date field back in, and it worked this time. Problem solved, I hope!

Best Regards,
Gordon