Search options (Page 19 of 42)

Hi Derek,

Thank you very much for the workaround...................
Truly appreciated...........................

I hit another wall that I couldn't go through, dig under or jump over.

My intention was to use editable grid as a part of the record details. For example we have contacts (people), when adding / editing contact I was planning to add their phone numbers using editable grid rather than many fields. However, I couldn't connect editable grid data to selected contact so that editable grid on frmPeople shows only edited person's phone numbers not all (When editing)
On Form1, non editable grid shows the phone numbers of only selected person from TableGrid1 in this case.

Please see the attached sample project below:

In order to avoid sorting issue (when both tGrids are not sorted in the same sequence) I have added a line to Derek's one but didn't work:

procedure frmProduct_OnShow (Sender: string; Action: string);
begin
  frmproduct.tgprodproducts.selectedRow := form1.tgmainprod.selectedrow; // Derek
  frmproduct.tgprodproducts.sortedColumn := form1.tgmainprod.sortedColumn;
end;

Perhaps it needs record ID or rowID added but I cannot construct it correctly

procedure frmProduct_OnShow (Sender: string; Action: string);
begin
  frmproduct.tgprodproducts.selectedRow + RecodID := form1.tgmainprod.selectedrow + RecodID ; 
end;

Dmitry, could you please help?
Please see post #1 on this thread/topic

The following seems to be almost working:

procedure Form1_Button7_OnClick (Sender, v1, v2, v3: string; var Cancel: boolean);
begin
  v1 := 'https://www.google.com/maps/?q=' ;
  v2 := sqlexecute('select street from people where id = ' + inttostr(form1.tablegrid1.dbitemid)); // Searching for street (1 OXBOW CL)
  v3 := sqlexecute('select postcode from people where id = ' + inttostr(form1.tablegrid1.dbitemid)); // Searching for post code (NG2 2NN)
  openurl(v1+v2+v3);
end;

However, I couldn't get search query displayed on Google maps search box correctly.
It's displayed as: 1 OXBOW CLNG2 2NN
It needs to send search query as: 1 OXBOW CL, NG2 2NN

Tried various things but couldn't get it to include comma and space after street  in search query. Please help....

Thanks Bullet3203...
Notes field is a memo text field. Text length will wary. Therefore increasing slide size will not solve the issue.

Best solution I can think of atm is to limit text display for notes on slide tGrid (not on actual notes entry form) by specifying maximum characters to be displayed.

Hopefully Dmitry can offer a solution.

Hi Dmitry,

Thank you very much for the updated MVD and sample project..........

I have tried to add image field to the slide grid but failed?

--------------------------------------------------------------
EDIT:
Done, I was missing calculated photo field on person table.

It's bit of a riddle getting field coordinates correct. It'd be nice to have next grid visual editor within mvd so that we can just visually drop, resize and move them on grid as needed.

Thanks for the post prahousefamily...
It's nice but is it possible in MVD?

Hi EHW,

I did something using inv type DBCR value and it seems to be working excluding certain points I may have missed. However, I think it's bit messy. Most likely there is cleaner and simpler way to do it.

- Added "Convert to Purchase Invoice" btn (marked on properties as visible false) on frmInvoice under sale tab for changing DBCR value to Porvhase. Extra DBCR value field just for visual effect where I may hide actual DBCR field.  "Convert to Purchase Invoice" btn and additional filed with Clear btn visible only on edit of a sale inv
- Disabled  "Convert to Purchase Invoice" btn when sale inv with Cr (Refund) to be edited.
- It wasn't clearing customer details when purchase inv converted to sale then converted back to purchase and converting to sale inv again. So I added clear fields lines under invOnShow event

Please see the attached sample project: