1

(3 replies, posted in Script)

humblelion wrote:

Hello Dmitry and all MVD fans

Even in the presence of internet access it takes a multiple clicks for

ping('google.com')

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

ping('google.com')

to take effect. How I wish there was an alternative method or a better way of writing this code.

2

(1 replies, posted in Talks about all)

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

sibprogsistem wrote:

.

Спасибо, мой брат, попробую.

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

5

(2 replies, posted in General)

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.

6

(2 replies, posted in General)

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

7

(2 replies, posted in General)

gonpublic2k wrote:
hotice546 wrote:

hello MVD users

I want a program to check if computer is connected to internet or not?

Thanks in advance.


Hi @hotice546,

Try this thread:

http://myvisualdatabase.com/forum/viewt … 109#p24109

That'll give you a head start smile

Thank you so much my brother from another mother

8

(2 replies, posted in General)

hello MVD users

I want a program to check if computer is connected to internet or not?

Thanks in advance.

9

(5 replies, posted in General)

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

10

(5 replies, posted in General)

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)

11

(3 replies, posted in General)

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.  smile

Wow. such a great project. We will readily help make it one of the best if not the best. Congratulations once again

12

(5 replies, posted in General)

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

13

(5 replies, posted in General)

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.

14

(5 replies, posted in General)

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

16

(19 replies, posted in General)

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

17

(19 replies, posted in General)

sibprogsistem wrote:

openurl('www.myvisualdatabase.com');

Thanks but still not answered. Apart from openurl(), is there any function to open a link address?

18

(19 replies, posted in General)

Hello Sibprogsistem, Derek and all MVD users

Is the a function to open web link aside openurl()?

19

(3 replies, posted in SQL queries)

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.

20

(3 replies, posted in SQL queries)

sibprogsistem wrote:

попробуйте так.

SQLExecute('SELECT firstname FROM students LEFT OUTER JOIN Exeat ON students.id=Exeat.id_students  WHERE Exeat.id= ' + Form1.TableGrid1.sqlValue );

Большое спасибо, брат. Я дам ему попробовать

21

(3 replies, posted in SQL queries)

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

22

(19 replies, posted in General)

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

23

(19 replies, posted in General)

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?

24

(19 replies, posted in General)

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

25

(19 replies, posted in General)

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