Method Community

Hello Dave,   I was on the CUSTOMIZE | INTEGRATION TOOLS | Export a file. I had chosen to export all fields.  NOTE: I tried again: I unchecked all and then checked what I needed – it worked.   Thanks! AG

That was the original failing case. The field in Table B that is linked to Table A's record ID cannot be written if I write a new row to table A and then pull the record ID from that new row. It appears that Table B does not know that the record ID for the new row is valid, and so balks at my insert. For example (using brief pseudo ...

Hi aarongoens, Can you please tell me what API function you are using that is causing the problem? Dave

 Jason L, Sorry to keep you waiting...it's been kinda a manic Monday....anyway... It sounds like you've added an extra field for recordid to table B, and have made it required. So it should be part of your insert list. Extending my example from above  string[ arrInsertFieldsArray = new string[ { "ArAccount", ...

If I choose to use the first option of adding a sort field to the table - have you used that with group items?  The client uses group items and in one template they need the detail printed and in another template they just print the group item name.  So I am wondering if this would make it a complex piece to figure out.  If they did ...

I'm just pinging on this. If I'm going about table construction or insertion wrong, please let me know. Thanks.

Hello,    I am trying to export my customer file so i can then use it as a template for importing. This is the error I am receiving: ERROR:Failure. There were problems with running the query, please verify your parameters My profile is set as ADMIN, the API, Table & Tab access is set correctly. What am I doing wrong? Thank ...

Depending on the importance of the feature.  There are 2 different approaches you could consider. You could add a field to the table that would contain the sort order or you could insert a new record (higher record id) then you could re-insert & delete the records with the smaller record id.  The later would have the effect of ...

I appreciate you giving me another option, and that might be exactly what I need in another situation.  I maybe missing something here but I can't see how changing the sort order would allow me to insert a new row in a specific place.  It looks like it would allow me to order by Record ID or Item ID, etc. but still not my choosen ...

[quote user="MikeB"]but it's interesting how this arises in Firefox only.[/quote] Just as a heads up, FireFox is not currently supported on our mobile version of Method - this may help in your testing. ~C