I think I understand that the cloned DB you made into a form level
variablewhen the function initDB is called as the form is initialized (I
think). So the data connection object variable (myconnectionobject)
exists as longas the form is open and can be accessed from within other
form objects and Ishould have access to any of the data connection
methods and properties whenreferencing myconnectionobject variable.Am I
correct?Cheers,Al
Hi Paul,This works! To make the "Previous" record button work I just had
to change the connection type to Dynamic and now I can move back and
forth through the records.Thanks a bunch!Al
Thanks Paul!That was the problem. I was not going deep enough in the
structure to identify the correct index. parent.parent.parent.index does
work perfectly for my form.Cheers,Al
Hi Paul,I added another post to the discussion. I still can't resolve
the index ofthe table row I'm trying to delete. Using this.index as the
argument toremoveinstance() always removes row 0 until minimum rows are
left.I attached my form; hope you can help.Cheers,AlPS I noticed there
is another discussion posted with the same question.
Thanks Paul,When I point to this.parent.index I get this error:
"Argument mismatch in property or function argument"However, when I use
this.parent.instanceindex it always removes the first table row. The
same thing happens when I use this.index.I guess I need to know the
index of the of the row I'm deleting. I tried to use resolvenode but the
function does not seem to work with the index argument -
resolvenode(this).index returns an error.Is there a function to return
the index of the table row...
Hi All,I have a problem with my forms with tables where I have buttons
to add or remove table rows. Adding rows works great but deleting rows
has a problem when deleting the first row. Example: here is a table with
two rows where column 1 has the add and delete buttons and column 2 has
user imput which looks something like this:Column 1Column 2Add and
delete buttons hererow 1Add and delete buttons hererow 2Add and delete
buttons hererow 3If the user deletes row 2 the table looks like this
which ...
Hi Paul,I tried to use the next() command as you suggested but I get
this error:"next operation failed, because there was no connection
specified"Is it possible that because I cloned the dataconnection the
script will not access the actual dataconnection?If I can make a form
variable and assign it to the cloned dataconnection I should be able to
access it from any script on the form until I close the connection; I
just don't know how to do it.Cheers,Al
Hi Paul,If I understand your question correctly; I am trying to move to
the next record in the record set from a button with the clonedDB.next()
statement in the script. This button is not the same button I use to
query the data connection for the record set.Cheers,Al
In the date field object properties you can click on the patterns
button, select the validation tab and click on the date format you want.
You should also use the same format in the display, edit, and data
tabs.Good luck,Al