Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 1 of 2)
humblelion wrote:Hello Dmitry and all MVD fans
Even in the presence of internet access it takes a multiple clicks for
to respond. Is there a way to address this situation or better still another option.
In advance, I thank you for your assistance.
I'm also facing the same problem. Even in the presence of internet, it takes a lot of clicks for
to take effect. How I wish there was an alternative method or a better way of writing this code.
This platform is the best ever platform I have ever come across. I cannot stay a day without visting this page. I want to suggest that we get a Telegram or Whatsapp page for MVD users.
I stand to be corrected
Спасибо, мой брат, попробую.
Hello Dmitry, Derek, Sibprogsistem, thezimguy, ehwagner and all MVD lovers.
I have created a project on employee leave. when my employees request leave, I add a new record to the database and when they return, I delete the record from the database.
I want to keep records all leave requested and return in a table. That is, I want keep all added and deleted leaves in another table.
I want a sample project. Thank you in advance family
ehwagner wrote:hotice546,
See if attached guides you to what you want. I used a Boolean field to distinguish an administrator from a user, but you may have another way. You just need to replace the If statement with whatever method you use.
Exactly as expected. i really appreciate.You are one of my favorite. Thank you very much.
Hello MVD lovers
A want a sample project to check double login. Say, if admin credentials correct, open form1 and if user credential correct, open form2
Thank you so much my brother from another mother
hello MVD users
I want a program to check if computer is connected to internet or not?
Thanks in advance.
ehwagner wrote:hotice546,
See attached for one way of updating a foreign key.
Wow.......you are such a genius I've been thinking of a way out. Thanks once again
derek wrote:Hi Manixs,
As a work-a-round, you could do something like the attached.
Derek.
Thank you Derek for such a wonderful piece.
What if the find and replace column is a associated with a foreign key
Eg.Say students in class A is promoted to class B. NB. There is an already table called class where we have class(A-D)
gonpublic2k wrote:Hello all MVD,
Here I post this utility, still in the works, just a small tool to do an entire backup of a user's profile to a drive or folder locally (or to a shared drive if mapped beforehand). It uses the 'OpenFile' function of MVD to invoke a batch file for the copy operations ( uses ROBOCOPY), and one .INI file to store information that the batch file needs. It's not a great combination but I post it here so that it can be improved and other features added as we progress. I will appreciate your input and ideas and you're free and welcome to edit it to make it better and come up with other solutions.
*** THINGS THAT I WISH TO SEE **
* A progress bar displayed at the bottom showing the progress of the command window
* A log file created after the backup to review all the operations performed or any errros.
* Maybe the mapping of a shared drive or shareed resource on the network done from within MVD ** Don't know if that's possible.
For now I think that's all, I will be making changes and post them here as we go forward.
Thanks and hope you like it.
Wow. such a great project. We will readily help make it one of the best if not the best. Congratulations once again
thezimguy wrote:procedure bulksms_Button1_OnClick (Sender:TObject; Cancel:Boolean);
var
Results: TDataSet;
contacts: String;
begin
SQLQuery('SELECT GROUP_CONCAT(DISTINCT contact) AS contacts '+
'FROM students '+
'WHERE '+
'id_form= "' + bulksms.ComboBox1.sqlValue + '" AND '+
'id_class= "' + bulksms.ComboBox2.sqlValue + '" AND '+
'id_course= "' + bulksms.ComboBox3.sqlValue + '"'+
';', Results);
contacts := Results.FieldByName('contacts').AsString;
ShowMessage(contacts);
end;
Let me know of any challenge
Thank you so much. I'm really grateful
thezimguy wrote:Can you elaborate a little bit on the problem?
Thank you very much in the first place for showing much concern
I want to select a particular column for a seach result.
hotice546 wrote:Helllo Dmitry, Sibprogsistem, Derek and all MVD lovers
How do I query database to select column in tablegrid search results
SELECT GROUP_CONCAT(DISTINCT contact)FROM students WHERE student.id=' + bulksms.TableGrid1.sqlValue
code not working
I need an urgent help
Thank you in advance
Any help from MVD lovers?
Helllo Dmitry, Sibprogsistem, Derek and all MVD lovers
How do I query database to select column in tablegrid search results
SELECT GROUP_CONCAT(DISTINCT contact)FROM students WHERE student.id=' + bulksms.TableGrid1.sqlValue
code not working
I need an urgent help
Thank you in advance
sibprogsistem wrote:OpenFile('mail.ru','C:\Program Files (x86)\Maxthon5\Bin\Maxthon.exe');
or
OpenFile('USA','C:\Program Files (x86)\Maxthon5\Bin\Maxthon.exe');
Thanks so much my brother from another mother. I appreciate every assistance.
I created a mini browser and that solved my problem. Thanks once again
sibprogsistem wrote:openurl('www.myvisualdatabase.com');
Thanks but still not answered. Apart from openurl(), is there any function to open a link address?
Hello Sibprogsistem, Derek and all MVD users
Is the a function to open web link aside openurl()?
sibprogsistem wrote:попробуйте так.
SQLExecute('SELECT firstname FROM students LEFT OUTER JOIN Exeat ON students.id=Exeat.id_students WHERE Exeat.id= ' + Form1.TableGrid1.sqlValue );
Wow, it works like magic, i edited some words and it works perfectly. Sibprogsistem, you are a genius.
sibprogsistem wrote:попробуйте так.
SQLExecute('SELECT firstname FROM students LEFT OUTER JOIN Exeat ON students.id=Exeat.id_students WHERE Exeat.id= ' + Form1.TableGrid1.sqlValue );
Большое спасибо, брат. Я дам ему попробовать
Hello Dmitry, Derek, Siibprogsistem and all MVD lovers
I want to pull an information foreign key id_students in table Exeat.
Example
SELECT fullname FROM students WHERE id_students is found in column id_students in table Exeat
Is this possible?
if not how do I achieve that.
Thanks in advance
hotice546 wrote:derek wrote:You could do it something like this (see attached).
There are other conditions you probably need to consider as well but the syntax is the same.
Excellent, exactly as expected. Thank you so much sir
can i set FROM(datetimepicker1) by default to now?
SOLVED. Thank you all
derek wrote:You could do it something like this (see attached).
There are other conditions you probably need to consider as well but the syntax is the same.
Excellent, exactly as expected. Thank you so much sir
can i set FROM(datetimepicker1) by default to now?
Hello Dmitry, Sibprogsistem, Derek and all MVD lovers.
I want the datetimepicker1(from) to always select today and now else datetimepicker2(to) to show dates not less than today.
Thank you in advance
derek wrote:There's no need to use a script - just doubleclick on the edit field that contains your url.
In the example, doubleclick a row in the tablegrid to select a store, then doubleclick the web address.
Derek.
Thanks Derek but i need a button to click the url without opening browser
Posts found: 1 to 25 of 33