Append from Variable

[RobPolley]

I had accidentally put this in the WAS forum - sorry! It should be here only.

I have a numeric table field that is correctly loaded into a form variable. I'd like to create a button that appends it FROM THE VARIABLE (not from the table) into a different table.

However, if it's easier to append it from directly from the table rather than from the variable, that's fine. I'd still like to ask for some help with this.

Is this possible?

Any direction would be appreciated.

Thank you.

--Rob

[Tbaker]

Re: Append from Variable

Rob

Are you just adding the value of that variable to the new table - (a new record in that table) which is an append, or are you adding that variable to a record already in that table?

If you are only adding the value of the variable to a new record in the table you can do the following in the onpush event for the button


This assumes that your variable has already been set from the value of the field in the current table.

dim tbl as p
tbl=table.open(your table name)
tbl.enter_begin()
  tbl.yourfieldname=var->youvariablename
tbl.enter_end()

If you are entering this into a record already in that table you will have to lookup the record you are going to add this variable value to, fetch that record and then tbl.change_begin() - tbl.change_end().

I don't know if this is what you want.

Tom Baker

[DaveM]

Re: Append from Variable

Please add tbl.close() after all else.

[Tbaker]

Re: Append from Variable

Dave

Thanks - good heads up

Tom Baker

[G Gabriel]

Re: Append from Variable

However, if it's easier to append it from directly from the table rather than from the variable, that's fine. I'd still like to ask for some help with this.

You don't need the variable.

t=table.current()[COLOR="Blue"] 'the table with the field to append from[/COLOR]
t1=table.opne("the table to append to")
t1.enter_begin()
t1.field1=t.field1
t1.enter_end(.t.)
t1.close()

[RobPolley]

Re: Append from Variable

Thanks, guys; you're awesome. I was able to do this via action scripting. The hardest part was limiting the append to the current record (in the form). I took the easiest possible way out and used "mark".

I made a button on the form which marked the record, did the append using the variables I had created (but I realize I didn't need them) , unmarked the record, and moved me to the next record.

After seeing how easy this all is, I'm psyched to solve every data problem anyone has! Thank you, and thanks Alpha!

--Rob

[G Gabriel]

Re: Append from Variable

Mark and unmark are a bit more time consuming if you are dealing with a lot of records.

Take the plunge and try xbasic.