Search results

I was unable to re-import my desktop project and Joseph from TP figured it out. My .tpp file on the computer running Connect was in a folder that didn't have the same name as the .tpp file. Changing that fixed the import which then fixed my data issue. It also led me down the path towards...

No errors listed, just incomplete records. I'm going to re-import my desktop project and see if it was caused by something out of sync there.

9.1.0.1276

I've got 2 processes in a single profile in TPC9 that were working fine a few months ago. Now process #2 is not putting any data in the records it is sending (output attached) <rec> <updatefields> <fld f_idx="0">11422</fld> </updatefields> </rec> It's only putting the Id field in...

Assuming the structure is accurate, you would have the 1 table but filter on Field_Index

No luck, kinda makes sense though because even when I was just deleting the entire table I couldn't make the dropdown empty out.

Closing and reopening the form doesn't change anything. Here is my SQL (tried different variations): INSERT INTO Session1_DD (Field_Index, DisplayValue, FilterValue, DBValue)SELECT 1, 'Test2', 'Test2', 'Test2' INSERT INTO Session1_DD (Field_Index, DisplayValue, FilterValue, DBValue) VALUES...

I can't get that to do anything. Is there some way to see the output or errors from ExecuteSQL lines? I have no indication that anything is happening. Even if I try to delete the entire table, the value is still there in the dropdown.

Thanks for the ideas. In my case it was just going to be a time saver/convenience as the operator will have the shipment number available and can just type it in.

Are the choices for a dropdown stored in the .tsc file, then? I was hoping to be able to overwrite it when the form initializes by doing a select/group by on the table

Is it possible to browse this file with a SQL CE tool? I'd like to see the structure so I know what I can do with ExecuteSQL events. When I tried to open it, it wanted a password for the file.

My session has rows that looks roughly like this: ID, ShipmentNumber, ScanDate, etc I want to make a dropdown on the form that is populated by the unique ShipmentNumbers in the table. I won't know what they are at design time. How can I do this? I know the SQL syntax to determine it, just...