Search results by user ID 5649

Re: Writing two linked tables

Jason_L — Wed, 18 Jul 2012 15:17:46 GMT

I finally got this to work. I needed to add a linked field along with the drop down, then not pass any parameters to the insert call dealing with the linked field. I was counting on the dropdown to hold Table A's record ID, but I had to add an actual linked field to the record ID, and then it worked. Thanks for the help.

Re: Writing two linked tables

Jason_L — Mon, 16 Jul 2012 21:47:15 GMT

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 code)

MethodAPI.MethodAPIInsertV2(all the right stuff, writing a new row to table a)

MethodAPI.MethodAPISelect_XMLV2(get table A record Id for new row)

MethodAPI.MethodAPIInsertV2(writing to Table B, including the result from the line above) <-Failure

Re: Writing two linked tables

Jason_L — Mon, 16 Jul 2012 20:50:52 GMT

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

Re: Uncheck left check box?

Jason_L — Mon, 16 Jul 2012 16:54:58 GMT

I'm just wondering if a workaround has been found.

Re: Writing two linked tables

Jason_L — Fri, 13 Jul 2012 20:34:42 GMT

That is a dropdown in Table B that is pulled in from Table A. I'm trying to keep B synced with A, via A's record ID.

Re: Writing two linked tables

Jason_L — Fri, 13 Jul 2012 19:46:29 GMT

I've just tried that, and it doesn't seem to be working. Here's a code snippet that I've got (with correct variables and all), it's Java syntax, but not tough to follow:

private static final String[ METHOD_TABLE_A_FIELDS_TO_WRITE = {"Company", "Email", "NameFirst", "NameLast", "NameFull", "Notes"};

private static final String[ METHOD_TABLE_B_FIELDS_TO_WRITE = {"NameFirst", "NameLast", "NameFull", "email"};

private static String[ methodTableAValuesToWrite = {"Slappy, Inc.", "slappy@mcgee.net", "AAAA", "AAAA", "AAAA AAAA", "This is a test item"};

private static String[ methodTableBValuesToWrite = {"AAAA", "AAAA", "AAAA AAAA", "slappy@mcgee.net"};

...

String response = service.methodAPIInsertV2(METHOD_COMPANY_NAME, METHOD_USER_NAME, METHOD_USER_PASSWORD, "", METHOD_TABLE_A_NAME, METHOD_TABLE_A_FIELDS_TO_WRITE, methodTableAValuesToWrite );

System.out.println(response);

response = service.methodAPIInsertV2(METHOD_COMPANY_NAME,METHOD_USER_NAME, METHOD_USER_PASSWORD, "", METHOD_TABLE_B_NAME, METHOD_TABLE_B_FIELDS_TO_WRITE, methodTableBValuesToWrite);

System.out.println(response);

My sysout calls show me:

<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "Success" RecordID="2331" ></MethodAPI>
<?xml version="1.0" encoding="windows-1252" ?><MethodAPI response = "Cannot insert the value NULL into column 'TableARecordID', table 'xxx.dbo.TableB'; column does not allow nulls. INSERT fails.
The statement has been terminated." ></MethodAPI>

So it looks to me that the API is automatically inserting null into the linked field, and so my insert is failing. The field is required, and I can try removing that restriction if the field will be updated by a chron job or something at a later time. If not, there's still something missing in this operation. By the way, if I add a known good record ID from table A (I used 1) to the values array, I get a success message.

Writing two linked tables

Jason_L — Fri, 13 Jul 2012 15:45:39 GMT

I have two tables, A and B, with a dropdown field in B that links to the automatically generated RecordID in A. I want to write to B and link it to A at the same time.

Through the API, my program flow works like this:

Take a variable passed in as an argument, and look that up in A, using methodAPISelect_XMLV2.

1) If I have a record ID, then I add that to the values being written into B using methodAPIInsertV2.

2) Else, I write details into A and then fetch the record ID from the field just written. Then add that record ID to the values being added to B.

Situation 1 works very well. Situation 2 does not work. The response shows the API balking on the recordID insert. I think, given other forum posts that it could be that the record just written into A hasn't had time to propigate into A->B lookup table, and so B doesn't understand that the new record does exist in A.

So, do I need to manually write the record ID into a middle lookup table somewhere, or do I need to make my program sleep for a little while to give A time to propigate its new value? If I need to write that record ID into a lookup table, how can I find the name of that table? It doesn't seem like something that would be exposed.

Uncheck left check box?

Jason_L — Mon, 09 Jul 2012 18:15:38 GMT

In a grid attached to a screen, is there any way to programmatically unselect a row (ie, uncheck the checkbox generated on the left)? I've got a button that will loop through the grid and do stuff with all the checked rows, which works just fine. As a cleanup step, I would also like to unselect the row, so when the logic's done running, all the checkboxes are clear. Since the checkbox isn't exposed as an independent object, I can't do this through the normal Select/Unselect Object command. Is there a way to unselect all the rows in the grid at once or individually?

Re: Automatically Fill Grid

Jason_L — Thu, 05 Jul 2012 15:57:01 GMT

Ok. I got it working. It was the difference between attached and detached. A detached table will load, but the same table as an attached table won't. I will keep that in mind for the future.

Re: Automatically Fill Grid

Jason_L — Thu, 05 Jul 2012 14:33:10 GMT

No, I don't have any filters set.