• Registered: 2014-11-08
  • Posts: 3

Topic: 2 questions, how do i get procedures to show, and multi order by seach

Greetings, hoping you can help.

Just started using MVD - as I no longer have access to Delphi. How do I get to the .pas to set .onclick etc procedures?
Also I am having trouble with my bespoke searches (I want multiple order by statement). I am trying set my WHERE variable to the text in an edit box, but  Select * from dbtable Where (dbtable.field = "editbox")  doesn't find anything.(nor does "editbox.text"). Im assuming that I have to set up a parameter to the value in the editbox?

Hoping that this makes sense

Dave

quarrel1's Website

  • Registered: 2014-02-14
  • Posts: 10,294

Re: 2 questions, how do i get procedures to show, and multi order by seach

For enable script, click on toolbar button http://myvisualdatabase.com/help_ru/script/icon_script.png


Creating event in My Visual Database like in Delphi.


You uses button with action SQL query for search?

Select * from dbtable Where dbtable.field = "{editboxname}"
Dmitry.
  • Registered: 2014-11-08
  • Posts: 3

Re: 2 questions, how do i get procedures to show, and multi order by seach

The inclusion of {} sorted it - many thanks, and yes im using sql query for search as I want the results to be sorted by more than 1 criteria.

As to the first problem - I don't have that button on my toolbar - nor do I have the tabs in Object Inspector . My OS is windows 8.1 - don't know if that's the problem? Im using MVD 1.21

quarrel1's Website

  • Registered: 2014-02-14
  • Posts: 10,294

Re: 2 questions, how do i get procedures to show, and multi order by seach

You have very old version, please, download


version 1.46 beta (Freeware)
https://www.dropbox.com/s/30ysr48sd8ca4 … 6.zip?dl=0


or


version 1.46 final (60 days trial)
http://myvisualdatabase.com/download/myvisualdb.exe

Dmitry.
  • Registered: 2014-11-08
  • Posts: 3

Re: 2 questions, how do i get procedures to show, and multi order by seach

Many thanks for the prompt responses - downloaded the latest code.

quarrel1's Website