1 Topic by lemodizon (edited by lemodizon 2022-05-18 03:57:58)

  • Registered: 2022-05-15
  • Posts: 48

Topic: MVD Combobox (solved thank you very much)

Hi Everyone,

Just want to ask on how do you script in MVD when i select the product name from my combobox it will automatic displayed the price and the current qtty on that product. I already linked my combobox to the table products and i was able to see the list of products.

or do you have sample project so i can check and learn on how things works.

thanks.

Post's attachments

Attachment icon combo.JPG 68.25 kb, 60 downloads since 2022-05-17 

-lemodizon
  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 908

Re: MVD Combobox (solved thank you very much)

Hi

As a rule, the data is displayed in a table.
In the attached file, an example where your question and output in the table.

Post's attachments

Attachment icon ComboBox.zip 336.87 kb, 139 downloads since 2022-05-17 

  • Registered: 2022-05-15
  • Posts: 48

Re: MVD Combobox (solved thank you very much)

Hi sparrow,

thanks for the sample file (comboBox). I will try it. so i can be familiar on how to write & learn a script on MVD.

-lemodizon
  • Registered: 2022-05-15
  • Posts: 48

Re: MVD Combobox (solved thank you very much)

sparrow wrote:

Hi

As a rule, the data is displayed in a table.
In the attached file, an example where your question and output in the table.


Hi sparrow,

I tried your code it work when i choose the product name from the combobox  but it has error "no such column"  i think the relationship of my two tables.

Post's attachments

Attachment icon combobox error.PNG 195.89 kb, 57 downloads since 2022-05-17 

-lemodizon

5 Reply by lemodizon (edited by lemodizon 2022-05-17 15:26:21)

  • Registered: 2022-05-15
  • Posts: 48

Re: MVD Combobox (solved thank you very much)

Hi Everyone,

This is my practice program in MVD. I'm trying the combobox. where i select the product name from the combobox it will automatic display the current quantity & price.

hope you can guide me.

thanks in advance

Post's attachments

Attachment icon SampleInventory.7z 277.23 kb, 117 downloads since 2022-05-17 

-lemodizon
  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,688

Re: MVD Combobox (solved thank you very much)

Hi Lemodizon,
To automatically select a product, use the 'incremental search' property of the combobox (see the screenshot.jpg in the attachment).
Derek.

Post's attachments

Attachment icon SampleInventory2.zip 405.21 kb, 144 downloads since 2022-05-17 

7 Reply by sparrow (edited by sparrow 2022-05-17 17:57:26)

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 908

Re: MVD Combobox (solved thank you very much)

Hi Derek.


Lemodizon,
change query in script 

('SELECT ProdQtty FROM Products WHERE Products.id= '+frmStockOut_Addprod.cboProd.sqlValue+ ' ')

about Script:  http://myvisualdatabase.com/help_en/Pascallanguage.html

  • Registered: 2022-05-15
  • Posts: 48

Re: MVD Combobox (solved thank you very much)

derek wrote:

Hi Lemodizon,
To automatically select a product, use the 'incremental search' property of the combobox (see the screenshot.jpg in the attachment).
Derek.


Hi Derek,

Thanks for the file....  i learned the use "Incremental search" still  i can't figure out the script query  from my combobox to display the price and current quantity.

thanks again

-lemodizon
  • Registered: 2022-05-15
  • Posts: 48

Re: MVD Combobox (solved thank you very much)

sparrow wrote:

Hi Derek.


Lemodizon,
change query in script 

('SELECT ProdQtty FROM Products WHERE Products.id= '+frmStockOut_Addprod.cboProd.sqlValue+ ' ')

about Script:  http://myvisualdatabase.com/help_en/Pascallanguage.html


Hi sparrow,

I already tried to changed query still it has error.

thanks for the link.

-lemodizon
  • Registered: 2022-05-15
  • Posts: 48

Re: MVD Combobox (solved thank you very much)

Hi sparrow and Derek,


This is now working thanks for the help.

I appreciated your efforts.

I changed my script query.

Thanks again

-lemodizon